16 Classes                                                                32 Hours

• Advance Excel Course-Topic 1- Introduction Of Ms Excel
• What Is Excel?
• Number Of Row And Column
• Edit List And Vba Setting In Excel
• Calculation, Tab Auto Correct & 20 Shortcuts Keys
• Advance Excel Course-Topic 2 -Paste Special
• Paste Special And Many More Paste Options
• Go To (F5) Option
• 20 Navigation Keys
• Advance Excel Course-Topic 3- Name Manager
• Create Name In Manager And Use As Function Validation
• Depending Data Validation
• Advance Excel Course-Topic 4- Pivot Table
• Creating Pivot Table
• Formatting And Customizing Pivot Table
• Using Advanced Option Of Pivot Table
• Pivot Charts
• Consolidation Data From Multiple Sheets And Files Using Pivot Tables
• Using External Date Sources, Using Data Consolidation Feature To Consolidate Data
• Viewing Subtotal Under Pivot
• Advance Excel Course-Topic 5 â??Using Functions
• Date And Time Functions
• Format Cells, Text Functions
• Advance Excel Course-Topic 6- Vlookup Functions
• Using Lookup And Reference Functions
• VLookup With Exact Match And Index
• Advance Excel Course-Topic 7- Advance Vlookup Functions
• VLookup With Advance Tricks.
• VLookup With Tables, Dynamic Ranges
• Nested VLookup With Exact Match
• Using VLookup To Consolidate Data From Multiple Sheets
• Hlookup
• Advance Excel Course-Topic 8 â??Using Logical Functions
• If
• Nested if
• If and

• If or
• If error
• Advance Excel Course-Topic 9 â??Using More Logical Functions
• Sumif
• Sumifs
• Countif
• Countifs
• Sumproduct & Round
• Large,Max,Min,Small,Mode And Many More
• Advance Excel Course-Topic 10 â??Shorting And Filtering Data
• Subtotal Formula & Subtotal Tools
• Shorting Tables
• Using Multiple-Level Shorting
• Using Custom Shorting
• Filtering Data For Selected View (Auto Filter)
• Using Advance Filter Options
• Advance Excel Course-Topic 11 â??Using Text To Columns Functions
• Clean,Trim,Len,Find
• Left,Mid,Right
• Lower,Proper,Rept And Value
• Advance Excel Course-Topic 12 â??Using Formatting Functions
• Auto Formatting Options For Worksheet
• Conditional Formatting Option For Rows, Columns And Cells
• Page Setting And Excel Protection
• Advance Excel Course-Topic 13 â??Using Whatif Analysis
• Intro What If Analysis
• Goal Seek, Data Tables And Scenario Manager
• Insert Hyperlink And Objects
• Advance Excel Course-Topic 14 â??Using Database Formulas
• Dmin,Dmax,Dsum,Dcount And Dcounta
• Informationâ??s Functions Isna,Isrff,Istextisnumber,Iseven And Na
• Advance Excel Course-Topic 15 â??Basic Macro/Vba Introduction
• Relative & Amp Absolute Macros
• Vba Project,Procedures And Write Some Vba/Macros Codes
• Advance Excel Course-Topic 16 â??Final Assignment
• Practical Test & Conclusion ,Advance Tricks & Other Formulas
• The Final Assignment Would Test Contains Questions To Be Solved At The End Of The Course