Back to Courses

Experience Our Ghatkopar East Lab: Book a Free Demo Lesson

AE-01 Advanced Excel, Business Analytics & Executive MIS Dashboards

Advance Excel

Master Nested Formulas, XLOOKUP, Dynamic Arrays, Power Query & Pivot Visuals

Teaching Since 1992 50,000+ Students Taught 100% Practical Lab Focus Lectures on Smartboard

Book a Free Demo Lesson Download Full Syllabus PDF

Program Specifications

COURSE DURATION 1 Months

PRACTICAL LAB SESSIONS 24 Modules

TOTAL TUITION FEES ₹2,500.00

WHO CAN JOIN? Commerce & Science Graduates, Working Professionals, Accountants, Managers

CENTER LOCATION Ghatkopar East, Mumbai

CONTACT DIRECT 9323925720 / 8169827233

Risk-Free Trial Class • Dedicated 1:1 Support

1992

Teaching Since

30+ Years Trust Legacy

50K+

Students Taught

Alumni in Top Mumbai Firms

100%

Practical Focus

No Rote Theory Learning

#1 Lab

Robotics & PC Lab

One & Only in Ghatkopar

Industry Relevance & Practical Edge

The Universal Currency of Corporate Data & Business Reporting

Employers judge analytical speed by how cleanly an employee handles complex data. Master multi-condition lookups, automated reconciliation models, and dynamic boardroom summary dashboards that impress leadership.

Tools & Software Mastered:

MS Excel 365 Power Query Power Pivot Dynamic Slicers Interactive Visual KPIs

Senior Instruction Team (25+ Years Experience): Suketu Sir, Harsh Sir, Moin Sir — Personalized 1:1 Attention & Continuous Progress Tracking.

Qualifying Career Opportunities

Completing this hands-on course prepares you for immediate commercial placement in roles such as:

MIS Executive Business Data Analyst Operations Coordinator Financial Modeling Assistant

Authorized Institute Credential

Issued with unique digital verification key, recognized by Mumbai commercial firms.

Step-by-Step Curriculum

Detailed Lab Modules & Practical Exercises

Every theoretical concept is paired with an actionable lab exercise and assignment sheet.

Topics Taught: Introduction to Excel - File structure, Menu 7 Ribbons

Lab Sheet Practice: Sheet no: 1-Adv.Excel-Introduction to Excel - File structure, Menu 7 Ribbons

Topics Taught: Excel file and Worksheets

Lab Sheet Practice: Sheet no: 2--Excel file and Worksheets

Topics Taught: Modifying and Formatting Worksheet - Font, Alignment, Cells

Lab Sheet Practice: Sheet no: 3--Modifying and Formatting Worksheet - Font, Alignment, Cells

Topics Taught: Formula and Functions - Concept, Syntax

Lab Sheet Practice: Sheet no: 4--Formula and Functions - Concept, Syntax

Topics Taught: Flash Fill

Lab Sheet Practice: Sheet no: 5--Flash Fill

Topics Taught: Basic Formula and Functions - Sum, Average, Max, Min, Count etc.

Lab Sheet Practice: Sheet no: 6--Basic Formula and Functions - Sum, Average, Max, Min, Count etc.

Topics Taught: Use of Basic Formula and Functions - Sum, Average, Max, Min, Count etc. with Multiple parameters

Lab Sheet Practice: Sheet no: 7--Use of Basic Formula and Functions - Sum, Average, Max, Min, Count etc. with Multiple parameters

Topics Taught: All Numeric and Text Function

Lab Sheet Practice: Sheet no: 8--All Numeric and Text Function

Topics Taught: All Logical Functions with detailed Examples Part 1

Lab Sheet Practice: Sheet no: 9--All Logical Functions with detailed Examples Part 1

Topics Taught: All Logical Functions with detailed Examples Part 2

Lab Sheet Practice: Sheet no: 10--All Logical Functions with detailed Examples Part 2

Topics Taught: All Financial Functions Part 1 and Part 2

Lab Sheet Practice: Sheet no: 11--All Financial Functions Part 1 and Part 2

Topics Taught: All Date & Time Functions

Lab Sheet Practice: Sheet no: 12--All Date & Time Functions

Topics Taught: Cell Name range, Relative & Absolute Cell Referencing

Lab Sheet Practice: Sheet no: 13--Cell Name range, Relative & Absolute Cell Referencing

Topics Taught: Inserting images and Shapes

Lab Sheet Practice: Sheet no: 14--Inserting images and Shapes

Topics Taught: Insert- Slicer, Timeline

Lab Sheet Practice: Sheet no: 15--Insert- Slicer, Timeline

Topics Taught: Charts and it types

Lab Sheet Practice: Sheet no: 16--Charts and it types

Topics Taught: Page Setup, Scale to Fit, Sheet options with Printing & Templates

Lab Sheet Practice: Sheet no: 17--Page Setup, Scale to Fit, Sheet options with Printing & Templates

Topics Taught: Data - Sort

Lab Sheet Practice: Sheet no: 18--Data - Sort

Topics Taught: Data -Filter

Lab Sheet Practice: Sheet no: 19--Data -Filter

Topics Taught: Data - Advance Filters

Lab Sheet Practice: Sheet no: 20--Data - Advance Filters

Topics Taught: Data - Subtotal

Lab Sheet Practice: Sheet no: 21--Data - Subtotal

Topics Taught: Data - Text to Columns, Consolidate, Remove Duplicates

Lab Sheet Practice: Sheet no: 22--Data - Text to Columns, Consolidate, Remove Duplicates

Topics Taught: Data - What if Analysis, Forecast Sheet

Lab Sheet Practice: Sheet no: 23--Data - What if Analysis, Forecast Sheet

Topics Taught: DSUM,DAVRG,DCOUNT

Lab Sheet Practice: Sheet no: 24--DSUM,DAVRG,DCOUNT

Topics Taught: Conditional Formatting - Basics

Lab Sheet Practice: Sheet no: 25--Conditional Formatting - Basics

Topics Taught: Conditional Formatting using Formulas - 18 cases - Advance

Lab Sheet Practice: Sheet no: 26--Conditional Formatting using Formulas - 18 cases - Advance

Topics Taught: Data Validation Basics

Lab Sheet Practice: Sheet no: 27--Data Validation Basics

Topics Taught: Advance Data Validation using Formulas - 40 cases - Advance

Lab Sheet Practice: Sheet no: 28--Advance Data Validation using Formulas - 40 cases - Advance

Topics Taught: Data - Get and Transform Data from internal and External Sources

Lab Sheet Practice: Sheet no: 29--Data - Get and Transform Data from internal and External Sources

Topics Taught: Formula Auditing - Tracing Precedents and Dependents, Error Checking

Lab Sheet Practice: Sheet no: 30--Formula Auditing - Tracing Precedents and Dependents, Error Checking

Topics Taught: Review Menu- Protecting Excel Worksheet and Workbook

Lab Sheet Practice: Sheet no: 31--Review Menu- Protecting Excel Worksheet and Workbook

Topics Taught: Excel PivotTable - Concept - structure

Lab Sheet Practice: Sheet no: 32--Excel PivotTable - Concept - structure

Topics Taught: Excel PivotTable Adv - Example

Lab Sheet Practice: Sheet no: 33--Excel PivotTable Adv - Example

Topics Taught: Using Freeze Panes Tools

Lab Sheet Practice: Sheet no: 34--Using Freeze Panes Tools

Topics Taught: Working with Excel's LOOKUP (V/H/Xlookup) Functions

Lab Sheet Practice: Sheet no: 35--Working with Excel's LOOKUP (V/H/Xlookup) Functions

Topics Taught: Working with Excel's Index and Matches

Lab Sheet Practice: Sheet no: 36--Working with Excel's Index and Matches

Topics Taught: Working with Excel's Array & LAMBDA

Lab Sheet Practice: Sheet no: 37--Working with Excel's Array & LAMBDA

Topics Taught: Working with Excel's Indirect & OFFSET

Lab Sheet Practice: Sheet no: 38--Working with Excel's Indirect & OFFSET

Topics Taught: Developer Menu - Automating Repetitive Tasks in Excel with Macros

Lab Sheet Practice: Sheet no: 39--Developer Menu - Automating Repetitive Tasks in Excel with Macros

Topics Taught: Developer Menu - Programming Automating Repetitive Tasks in Excel using VBA (Visual Basic for Applications)

Lab Sheet Practice: Sheet no: 40--Developer Menu - Programming Automating Repetitive Tasks in Excel using VBA (Visual Basic for Applications)

Topics Taught: PivotTables

Lab Sheet Practice: Sheet no: 41--PivotTables

Topics Taught: Pivot Chart

Lab Sheet Practice: Sheet no: 42--Pivot Chart

Topics Taught: Power Query and Data Analysis Part 1

Lab Sheet Practice: Sheet no: 43--Power Query and Data Analysis Part 1

Topics Taught: Power Query and Data Analysis Part 2

Lab Sheet Practice: Sheet no: 44--Power Query and Data Analysis Part 2

Topics Taught: Power Query and Data Analysis Part 3

Lab Sheet Practice: Sheet no: 45--Power Query and Data Analysis Part 3

Topics Taught: Power Pivot

Lab Sheet Practice: Sheet no: 46--Power Pivot

Topics Taught: DAX Formulas

Lab Sheet Practice: Sheet no: 47--DAX Formulas

Topics Taught: KPI's

Lab Sheet Practice: Sheet no: 48--KPI's

Topics Taught: Dashboard

Lab Sheet Practice: Sheet no: 49--Dashboard

Topics Taught: Financial & Statistical Modeling

Lab Sheet Practice: Sheet no: 50--Financial & Statistical Modeling

Topics Taught: Creating Customize Ribbons, Menu and Tool(bars) - Suketu Tools, Finance Tools & HR tools

Lab Sheet Practice: Sheet no: 51--Creating Customize Ribbons, Menu and Tool(bars) - Suketu Tools, Finance Tools & HR tools

Topics Taught: Misc. Topics

Lab Sheet Practice: Sheet no: 52--Misc. Topics

Topics Taught: Excel Special Problems

Lab Sheet Practice: Sheet no: 53--Excel Special Problems

Zero Risk • Immediate Practical Exposure

Book Your Free Trial Demo Lesson Today

Visit our Ghatkopar East center, meet our faculty, sit at a live computer workstation, and experience our teaching before paying any admission fees.

Book a Free Demo Lesson Now WhatsApp: 9323925720

Shri Kathiawad Sthanakwasi Jain Samaj, Near Railway Station, Ghatkopar East, Mumbai. • Direct Hotline: 9323925720 / 8169827233

Advance Excel

Teaching Since

Students Taught

Practical Focus

Robotics & PC Lab

The Universal Currency of Corporate Data & Business Reporting

Tools & Software Mastered:

Qualifying Career Opportunities

Authorized Institute Credential

Detailed Lab Modules & Practical Exercises

Module 1 Adv.Excel

Module 2 Adv.Excel

Module 3 Adv.Excel

Module 4 Adv.Excel

Module 5 Adv.Excel

Module 6 Adv.Excel

Module 7 Adv.Excel

Module 8 Adv.Excel

Module 9 Adv.Excel

Module 10 Adv.Excel

Module 11 Adv.Excel

Module 12 Adv.Excel

Module 13 Adv.Excel

Module 14 Adv.Excel

Module 15 Adv.Excel

Module 16 Adv.Excel

Module 17 Adv.Excel

Module 18 Adv.Excel

Module 19 Adv.Excel

Module 20 Adv.Excel

Module 21 Adv.Excel

Module 22 Adv.Excel

Module 23 Adv.Excel

Module 24 Adv.Excel

Module 25 Adv.Excel

Module 26 Adv.Excel

Module 27 Adv.Excel

Module 28 Adv.Excel

Module 29 Adv.Excel

Module 30 Adv.Excel

Module 31 Adv.Excel

Module 32 Adv.Excel

Module 33 Adv.Excel

Module 34 Adv.Excel

Module 35 Adv.Excel

Module 36 Adv.Excel

Module 37 Adv.Excel

Module 38 Adv.Excel

Module 39 Adv.Excel

Module 40 Adv.Excel

Module 41 Adv.Excel

Module 42 Adv.Excel

Module 43 Adv.Excel

Module 44 Adv.Excel

Module 45 Adv.Excel

Module 46 Adv.Excel

Module 47 Adv.Excel

Module 48 Adv.Excel

Module 49 Adv.Excel

Module 50 Adv.Excel

Module 51 Adv.Excel

Module 52 Adv.Excel

Module 53 Adv.Excel

Book Your Free Trial Demo Lesson Today