Advance Excel Certification Course

Shine Computer Education is the Best  Advance Excel Training Institute, Class in Vadodara near akota. Learn Advance Excel Certification Course in Vadodara from No#1 Advance Excel Training Institute. This Advanced Microsoft Excel Course Syllabus is designed by Industry Experts.

Our Advanced Excel Course Syllabus covers in-depth knowledge of pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others etc.

This advanced Excel course syllabus is designed for the intermediate Excel user who desires to learn more advanced skills. Learn the most advanced formulas, functions, charts and types of financial analysis to be an Excel power user.

Main Modules:

• Module 1 - Excel Introduction and New Features
• Module 2 - Formatting in Excel
• Module 3 - Excel Basic Formulas and Functions
• Module 4 - Working with IF and Nested IF formulas
• Module 5 - Pivot Table and Chart in Details
• Module 6 - Pagelayout and Printing
• Module 7 - Filter and Advance Filter
• Module 8 - Flash Fill, Data Validation
• Module 9 - Advance Text Formulas
• Module 10 - Working with Table and Forms
• Module 11 - Vlookup with Different Exercises
• Module 12 - HLookup With Exercises
• Module 13 - Match and Index Function
• Module 14 - Creating Advance Interactive Dashboards
• Module 15 - Use of Macro
• Module 16 - Working with shortcuts
• Module 17 - Advance Formulas with Exercises