Best Advanced Excel Training Institute in Kolkata

→ Basic of Excel
→ Working with Excel Files
→ Entering data
→ Working with numbers
→ Formatting data
→ Managing your data in excel worksheet
→ Working with text and date
→ Manipulating data,Working with charts
→ PMT,IPMT & PPMT
→ Use MACROS in Excel
→ MIS REPORT : Types, Examples & how to Effectively Prepare it
→ How to Make Master Sheet.
→ Split Data from a Master Sheet into several worksheets in Excel
→ Data Entry Form in Excel without VBA | Data Entry in Excel | Like a Software
→ Forecast, AND, OR Formulas
→ Correl,Ceiling,Frequency
→ Sparklines (Line, Column, Win/Loss)
→ Working with Pivot Table
→ Pivot Chart,Slicer,Timeline,Power View
→ Power Pivot,Solver
→ Formula Auditing
→ Sorting,Filter,Advanced Filter
→ Data Validation
→ Consolidate
→ VLookup,HLookup,XLookup
→ Istext With Vlookup,Isnumber With Vlookup
→ Vlookup In Same Sheet
→ Vlookup In Deferent Sheet
→ Dynamic MAP chart in excel
→ Match Function
→ Hlookup with Match Function
→ Vlookup with Match Fundtion
→ Index Formula
→ Index + Match Function
→ DSUM Function
→ DAverage Function
→ DMin,DMax Function
→ Abs,Concatenate,Exp,
→ Exact,Fact,GCD,Int,LCM
→ Left,Len,Lower
→ Max,Mid,Mod,Now
→ Power,Proper,Replace
→ Rept,Right,Round,Search,Sqrt
→ Today,Trim,Upper
→ Conditional Formatting
→ Find,Round,Round Up,Round Down
→ working with Salary Sheet,
→ Absolute & Relative Cell References
→ Multiple IF Function
→ What If Analysis(Goal Seek,Scenario Manager)
→ Subtotal,Text To Columns
→Remove Duplicates,Freeze Panes
→ Istext,Isnumber,N Formula
→ CountA,Count Blank,Count If
→ SumIf,SumIfs,Choose
→ Printing excel files
→ Managing Excel files
→ Grouping and outlining data
→ Shortcut keys and references,etc.
→ Live Project.

Minimum Eligibility:	Minimum 12 Pass	Course Fee Rs. 7,500/- (Offline Training) Rs. 10,000/- (Online Training)
Course Duration:	2-3 Months
Mode Of Training:	Online and Offline

Advanced Excel

Diploma in Advanced Excel

Our Successful Students

Advanced Excel Course Details :

Contact With Us

Popular Link

l a t e s t v i d e o

How to Use Tables in Microsoft Word 2022

ABOUT NICS COMPUTER & RAJA KUNDU

How to Take a Screenshot on Your Computer or Laptop by NICS COMPUTER

Contact With Us

| Quick Links

| Courses

| Follow Us

| Location