Kemps Corner (H.O) +91 98201 34058WhatsApp +91 98201 34058Bandra (W) +91 98333 61338
Classroom training since 1985 · Kemps Corner · Bandra (W)
Kemps Corner +91 98201 34058 Bandra (W) +91 98333 61338 Free Demo SessionWhatsApp

Home › Courses › Office Automation › Advanced Excel Course

Classroom training · Kemps Corner & Bandra (W)

Advanced Excel Training in Mumbai: MIS Reporting & Data Analysis

20 hours · Classroom training · Free demo session

Lookups, pivot tables, dashboards and MIS reports. Hands-on with a trainer beside you, at Kemps Corner or Bandra (W).

  • 20 hrs classroom training
  • Fee ₹8,500
  • Free demo session
Book a FREE Demo Session →WhatsApp us
Kemps Corner+91 98201 34058WhatsApp
Bandra (W)+91 98333 61338WhatsApp
Online sessions available

Microsoft tools you'll learn

  • VLOOKUP & INDEX-MATCH
  • Pivot Tables
  • MIS reports
  • Data validation
  • Macros
  • What-If Analysis
  • Charts

Book your FREE Demo Session

We'll call you back to fix a time at Kemps Corner, Bandra (W) or online.

Your details go only to Compufield. We'll call you, no spam.

Course content

What you'll learn

Advanced Excel Course (Office 365, 2024, 2021): this program is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features that improve their efficiency with worksheets, analysing data, creating MIS reports and automating tasks.

1

Professional Advanced Excel Syllabus & Training

Customizing common options in Excel · Absolute and relative cells · Protecting and un-protecting worksheets and cells

2

Advanced Excel Course - Working with Functions

Writing conditional expressions (using IF) · Using logical functions (AND, OR, NOT) · Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX) · +4 more

3

Advanced Excel Course - Data Validations

Specifying a valid range of values for a cell · Specifying a list of valid values for a cell · Specifying custom validations based on formula for a cell

4

Advanced Excel Course - Working with Templates

Designing the structure of a template · Using templates for standardization of worksheets

5

Advanced Excel Course - Sorting and Filtering Data

Sorting tables · Using multiple-level sorting · Using custom sorting · +2 more

6

Advanced Excel Course - Working with Reports

Creating subtotals · Multiple-level subtotals · Creating Pivot tables · +9 more

7

Advanced Excel Course - More Functions

Date and time functions · Text functions · Database functions · +1 more

8

Advanced Excel Course - Formatting

Using auto formatting option for worksheets · Using conditional formatting option for rows, columns and cells

9

Advanced Excel Course - Macros

Relative & Absolute Macros · Editing Macros

10

Advanced Excel Course - WhatIf Analysis

Goal Seek · Data Tables · Scenario Manager

11

Advanced Excel Course - Charts

Using Charts · Formatting Charts · Using 3D Graphs · +4 more

12

Advanced Excel Course - New Features Of Excel

Sparklines, Inline Charts, data Charts · Overview of all the new features

13

Advanced Excel Course - Final Assignment

The Final Assignment contains questions to be solved at the end of the Course

Professional Advanced Excel Syllabus & Training →

By the end of this course you can

  • Perform complex calculations more efficiently using Excel functions
  • Organise and analyse large volumes of data
  • Create MIS reports
  • Design and use templates
  • Consolidate and manage data from multiple workbooks

Who this course is for

  • Executives and managers who already use Excel but need more powerful features and options
  • MIS, finance, sales and operations staff

Before you start: Familiarity with basic Excel operations such as simple calculations, formatting and printing.

Fees and options

Fees and related courses

This course is highlighted. Every course starts with a free demo session.

Fees shown are for classroom training at Kemps Corner and Bandra (W). Live online sessions have different fees: call or WhatsApp +91 98201 34058 (Kemps Corner) or +91 98333 61338 (Bandra (W)).

Ready for dashboards?After Advanced Excel, most learners move on to Power BI.Power BI courses →

Inside our classrooms

Real classrooms. Real trainers.

Learn Advanced Excel on real computers with a trainer beside you, at our centres or at your company.

Advanced Excel class with students at Compufield Bandra (W)
Bandra (W)
Advanced Excel class with students at Compufield Bandra (W)
Bandra (W)
Advanced Excel class with students at Compufield Bandra (W)
Bandra (W)
Corporate Advanced Excel training for a company team in Mumbai
Corporate training
Corporate Advanced Excel training for a company team in Mumbai
Corporate training

Free demo session

Book your FREE Demo Session

Visit us at Kemps Corner or Bandra (W), or join online. Call or WhatsApp the centre nearest you.

For companies

Corporate Advanced Excel training

We run these courses as corporate workshops and training programmes for company teams, at your office or at our centres.

  • Training at your office (client location)
  • MS Office, Excel and MIS training for company teams
  • Customised content for your industry and data
  • Copilot for Microsoft 365 for your teams

Train your team

Tell us your team size and the tools you use. We'll suggest a workshop that fits.

Visit IT Corporate Training ↗ Enquire for your company

Corporate workshops in action. Led by Faiyaz M Khairaz, Microsoft Certified Trainer, with 22+ years of corporate training.

Student reviews

What our students say

Read all reviews on Google ↗
★★★★★
I have completed my course in diploma in MS office + generative AI. Good institution with teachers.
Vedant S.MS Office + Generative AI · Sep 2026 · Google review
★★★★★
Great place to learn MS office with AI. The trainers over here are really very helpful and are very…
Taha M.MS Office with AI · Sep 2026 · Google review
★★★★★
I completed my ms office + advance excel + tally course from this institute, would recommend this…
Saba Q.MS Office, Advanced Excel & Tally · Aug 2026 · Google review
★★★★★
Great place to learn digital courses, I have recently completed my Advanced Excel with AI course…
Sukanya B.Advanced Excel with AI · Aug 2026 · Google review
★★★★★
Completed my Advance excel course with AI recently from here.. the course was quite helpful for my…
Raj S.Advanced Excel with AI · Aug 2026 · Google review
★★★★★
I recently completed the Advanced AI, Excel & PowerPoint course through online classes at…
Sk Shabir A.AI, Excel & PowerPoint · Online · Jul 2026 · Google review

Questions about the Advanced Excel Course

How long is the Advanced Excel Course?

20 hours of classroom training at Kemps Corner or Bandra (W), with a trainer beside you.

What are the fees?

₹8,500 for classroom training. Live online sessions have different fees, so please call Kemps Corner on +91 98201 34058 or Bandra (W) on +91 98333 61338.

What should I know before joining?

Familiarity with basic Excel operations such as simple calculations, formatting and printing.

Are classes in the classroom or online?

Both. Classroom training at Kemps Corner and Bandra (W). Live online sessions are run by both centres and have different fees.

Can I try a class before joining?

Yes. Every course starts with a free demo session.

Do you train company teams?

Yes. We run this course as a corporate workshop at your office.

Book your FREE Demo Session

Kemps Corner · Bandra (W) · Online sessions available

Kemps Corner +91 98201 34058Bandra (W) +91 98333 61338
Book a free demoWhatsApp us
WhatsApp us
WhatsApp usFree Demo
Chat with us on WhatsApp

What would you like to learn? We'll reply on +91 98201 34058.

Start WhatsApp chat →