MS Advanced Excel Course in Pune

6 Lesson

16 Hours

Add to Wishlist

igmGuru offers the best online advanced Excel training in Pune. This course content is designed by skilled and certified Excel professionals. Enroll now to learn advanced Excel tools, data analysis, formulas, PivotTables, charts, and other key features to boost your skills and career. Get ready to become certified in Advanced Excel for professional work.

Enroll Now

Advanced Excel Course in Pune Overview

Our Excel training in Pune offers a 16-hour, instructor-led course covering advanced Excel functions, VBA programming, pivot tables, and data visualization. This program is designed for professionals like data analysts, accountants, and project managers. Our program includes lifetime access to the study material, 24/7 support, Flexible learning options, and preparation for the Microsoft Excel certification exam.

Prerequisites

Basic knowledge of Microsoft Excel is helpful but not mandatory
Basic Understanding of data entry and formatting
Basic computer skills

What Will You Learn in this Course

Advanced formulas and functions (VLOOKUP, HLOOKUP, INDEX, MATCH, IF, etc.)
Data analysis using PivotTables and PivotCharts
Data validation and conditional formatting
Creating dynamic dashboards and reports
Financial modeling and forecasting
Advanced charting techniques
Working with Macros and an Introduction to VBA
Data cleaning and Power Query basics
Tips and tricks to improve speed and efficiency
Preparation for the Microsoft Office Specialist (MOS) Excel Expert Certification

Key Features

Experienced & Professional Trainers
Small Batches Upto 10 Participants
24 X 7 Lifetime Support & Access
1 On 1 Training Option Available
Flexible Schedule
Instructor-Led Training within 16 Hrs

Advanced Excel Course in Pune Syllabus

Lesson 1 - Getting Started

1. Intro to Excel

2. Setting up tables

3. Cleaning bad data

4. Cleaning using Power Query

5. Writing formulas

6. Creating pivot tables

7. Making charts

8. Filtering & sorting

9. Shortcuts

Lesson 2 - Data + Tables + PQ

1. Excel Tables

2. Filtering, slicing tables

3. Bad data to good with PQ

4. Unpivoting data with PQ

5. Merging multiple files to one table

Lesson 3 - Writing Formulas

1. Referencing data

2. IF condition, CHOOSE, IFS

3. Statistical analysis

4. Conditional sum, count

5. Lookups

6. Advanced Lookups

7. Date formulas

8. Text analysis

9. Sentiment analysis

10. Exploratory data analysis

Lesson 4 - Making Pivot Tables

1. Creating pivot tables Data model + relationships

2. Multiple table pivots

3. Customizing pivots

4. Extra calculations in Pivots

5. Grouping data

6. Slicing and dicing

7. Get Pivot Data

Lesson 5 - Charts + Graphs

1. Intro to Charting

2. Picking right charts

3. Anatomy of Excel chart

4. Formatting charts

5. New charts in Excel 2016

6. Budget vs. Actual charts

7. Then vs. Now charts

8. Conditional charts

9. Sparklines

10. Interactive charts

Lesson 6 - Advanced Concepts

1. Data validation

2. Creating templates

3. Workbook protection

4. Publishing to web

5. Shapes + pictures

6. Navigation buttons

7. Printing

8. Form controls

9. Custom ribbons

Talk To Us

We are happy to help you

1-800-7430-173 (US Toll Free)

+91 7240740740 (India)

Drop Us a Query

Fields marked * are mandatory

Name

Phone Number

Comments

Request For Live Demo Class

MS Excel Course Fees

SELF PACED LEARNING

US $ 199.00 US $ 99.00

Refund Policy

Duration : 16 hrs
Lifetime Free Upgrade
Reference Documents
24x7 Support & Access

WATCH 1st CLASS FREE

Online Class Room Program

US $ 699.00

100% Money Back Guarantee

Duration : 16 Hrs
Plus Self Paced

Classes Starting From

Fast Track Batch 07 Aug 2026
Weekday Batch 10 Aug 2026
Weekend Batch 08 Aug 2026

Corporate Training

Customized Training Delivery Model
Flexible Training Schedule Options
Industry Experienced Trainers
24x7 Support

Trusted By Top Companies Worldwide

Want to know Today's Offer

Microsoft Advanced Excel Certification

This Advanced Excel Course is designed to help you develop advanced spreadsheet and data analysis skills while preparing for the Microsoft Office Specialist (MOS): Excel Expert (Microsoft 365 Apps) certification. The training covers advanced formulas and functions, Power Query, PivotTables, PivotCharts, advanced charting, workbook management, data analysis, automation techniques, and reporting best practices. Upon successful completion of the course, you receive a course completion certificate from igmGuru and are prepared to pursue the Microsoft Office Specialist (MOS): Excel Expert certification.

Microsoft Office Specialist (MOS): Excel Expert Certification Guide

Below are the details for the Advanced Excel certification exam (Expert Level (MO-211)).

Exam Overview

Official Name: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps)
Certification Provider: Microsoft
Exam Code: MO-211
Exam Format: Performance-Based
Exam Duration: 50 Minutes
Passing Score: 700 out of 1000 (scaled score)
Exam Cost: USD 100 (may vary by region)
Exam Delivery: Certiport Authorized Testing Centers
Language: Multiple languages (availability varies by region)

Microsoft Advance Excel FAQ's

Are there any other Certification courses igmGuru offers?

Yes, igmGuru offers several other online certification courses. These include specialized online certification courses, tailored to different levels. igmGuru, greatly emphasizes upskilling and boosting career opportunities across any industry sectors, with each online certification course designed to help learners enhance their expertise.

Are there any other online courses igmGuru offers under Business Intelligence?

Yes, igmGuru offers several other online courses under Business Intelligence. These include specialized online courses, tailored to different skill levels. igmGuru greatly emphasizes upskilling and boosting career opportunities across IT industry sectors, with each online course designed to help learners enhance their expertise in Business Intelligence. Below are few courses.

1-800-7430-173

(US Toll Free)

+91-7240-740-740

(India)