Advanced Excel Course in 60 days

"Become an Excel Expert in 60 Days"

Course Modules

1. Week 1-2: Excel Essentials Review

   • Introduction to Excel Interface

   • Basic Formulas and Functions

   • Data Formatting and Conditional Formatting

   • Charts and Graphs Basics

2. Week 3-4: Advanced Formulas and Functions

   • Advanced Lookup Functions (VLOOKUP, HLOOKUP)

   • INDEX and MATCH

   • Logical Functions (IF, AND, OR)

   • Text Functions (LEFT, RIGHT, MID, CONCATENATE)

   • Date and Time Functions

3. Week 5-6: Data Analysis and Visualization

   • Pivot Tables and Pivot Charts

   • Data Validation

   • Advanced Charting Techniques

   • Text Functions 

   • Scenario Analysis and Data Tables

4. Week 7-8: Data Management and Automation

   • Sorting and Filtering Data

   • Importing and Exporting Data

   • Data Cleaning Techniques

   • Macros Basics

   • Introduction to VBA (Visual Basic for Applications)

5. Week 9-10: Advanced Data Analysis Tools

   • Power Query

   • Power Pivot

   • Goal Seek

   • Statistical Analysis

6. Week 11-12: Automation with VBA

   • VBA Programming Basics

   • Writing and Debugging Macros

   • User Forms and Controls

   • Automating Reports and Dashboards

Salient Features:

• Expert Instructors 

• Interactive Sessions 

• Individual Attention

• 100% Practical Training

• Special Discount for Group

• Limited Seats

• Resource Materials (e-books)

• Hands-On Projects

• An ISO 9001:2015 & MSME Certified Institute