Advanced Excel Course in Borivali, Kandivali, Dahisar & Charkop

About the Advanced Excel course

Advanced Excel teaches the features used in real offices: advanced formulas, lookup functions (VLOOKUP, XLOOKUP, INDEX-MATCH), pivot tables and charts, dashboards, data cleaning and validation, and an introduction to macros.

It is valuable for accounts, MIS, data entry and analyst roles.

Eligibility: Recommended: basic Excel knowledge.

After this course you will be able to

• Use advanced formulas and lookup functions
• Summarise data with pivot tables
• Build dashboards and charts
• Clean and validate large datasets

Syllabus topics

1. Advanced formulas
2. Lookup functions (VLOOKUP, XLOOKUP, INDEX-MATCH)
3. Pivot tables and charts
4. Dashboards
5. Data cleaning and validation
6. Intro to macros

Tools & software you will use

• MMS Excel
• Google Sheets

Logos belong to their respective owners and only show which software is used in class.

Who should join

• Accounts and MIS staff
• Students and job seekers
• Business owners

Career opportunities after Advanced Excel

Roles commonly available to learners with these skills. This is not a guarantee of a job.

• Data Analyst
• Business Analyst
• MIS Executive
• Reporting Analyst
• Operations Analyst

Learn Advanced Excel near you

We teach Advanced Excel at our branches in Borivali West, Kandivali West (Charkop) and Dahisar East. Students also join from Gorai, Malad, Mira Road and across Mumbai. Call the branch nearest to you.

Frequently asked questions