New batches start 11 August 2026. Enrol now →
Maruti AI Technology Enrol now

← Data Science & Analytics

Data Science & Analytics

Advanced Excel with AI

Master Excel formulas, data management and AI-powered automation

You go from Excel essentials and formulas to data analysis, data management and advanced formula work, then use AI tools for automation and business intelligence. By the end, you can manage, analyse and visualise data in Excel with AI handling the repetitive parts.

25h
of content
10
modules
66
lessons
Fees from
₹2,000

per level · 3 levels · complete programme ₹8,200

Duration
3 mo
Enrol now Talk to us first

Fees by level

Start at any level, or take the complete programme. The fee you pay for a level is locked for you.

LevelWhat it coversDurationFee
Beginner Start from zero 1 mo ₹2,000
Intermediate Build working projects 1 mo ₹2,700
Advanced Get job-ready 1 mo ₹3,500
Complete programme (all levels) ₹8,200

All fees are in Indian Rupees and include applicable taxes. See our pricing & payment terms.

The complete curriculum

This is the entire syllabus — all 10 modules and 66 lessons, in the order you'll learn them. Nothing hidden.

↓ Download full curriculum (PDF)
01 Getting Started with Excel 3 lessons ▶
  1. 1.1Intro to MS Excel-Basic Navigation
  2. 1.2Excel Basics-Editing Sheets_Cells_Range_Column_Rows
  3. 1.3Customizing Quick Access Toobar
02 Excel Essential 4 lessons ▶
  1. 2.1Quick Access Toolbar HACKS
  2. 2.2Customizing Ribbon
  3. 2.3Excel Shortcuts-Navigation, Editing, Selection
  4. 2.4Excel Shortcuts-Formatting, Paste Special, Formulas, Power Moves
03 Working with Data 2 lessons ▶
  1. 3.1Cell Referrencing
  2. 3.2Cell Referencing - Examples
04 Essential Formulas 10 lessons ▶
  1. 4.1Sum Function(Detailed)- Part 1
  2. 4.2Sun Function(Detailed)-Part 2
  3. 4.3Average Function
  4. 4.4Min and Max Function
  5. 4.5COUNT Function
  6. 4.6COUNTA & COUNTIF Function
  7. 4.7COUNTIFS Function
  8. 4.8SUMIF Function
  9. 4.9SUMIFS Function
  10. 4.10AVERAGEIF & AVERAGEIFS Function
05 Working with Tabs and Formatting 6 lessons ▶
  1. 5.1Home Tab-Part 1
  2. 5.2Home Tab-Part 2
  3. 5.3Number Formatting
  4. 5.4Styles Group-Cell Formatting
  5. 5.5Conditional Formatting-Part 1
  6. 5.6Conditional Formatting-Part 2
06 Data Analysis Basics 6 lessons ▶
  1. 6.1INSERT TAB
  2. 6.2TABLE GROUP
  3. 6.3PIVOT TABLE-Part 1
  4. 6.4PIVOT TABLE-Part 2
  5. 6.5CHARTS in MS Excel
  6. 6.6PIVOT CHARTS
07 Data Management 7 lessons ▶
  1. 7.1PAGE LAYOUT-Basics
  2. 7.2Basic Data Management - Sorting, Filtering, Removing Duplicates
  3. 7.3Working with Multiple Sheets-Linking and Consolidating
  4. 7.4Introduction to TEMPLATES in MS Excel
  5. 7.5Creating Basic Excel Template
  6. 7.6Interactive Dashboard using AI for beginners
  7. 7.7Data Validation
08 Advanced Formulas 11 lessons ▶
  1. 8.1Logical Functions-IF, AND, OR, NOT
  2. 8.2Nested IF
  3. 8.3Nested IF vs IFS
  4. 8.4Understanding LOOKUP Functions
  5. 8.5LOOKUP FUNCTIONS
  6. 8.6VLOOKUP with MATCH
  7. 8.7INDEX Function
  8. 8.8INDEX+MATCH Function
  9. 8.9TEXT Functions
  10. 8.10MID Function-Exercise
  11. 8.11DATE & TIME Function
09 Advanced Data Management & Visualization 5 lessons ▶
  1. 9.1Named Ranges in MS Excel
  2. 9.2Structured Referencing in TABLE
  3. 9.3Advanced Charting-SPARKLINES
  4. 9.4WHAT-IF ANALYSIS in MS Excel
  5. 9.5ERROR HANDLING in MS Excel
10 Automation & Business Intelligence using AI 12 lessons ▶
  1. 10.1POWER QUERY in MS Excel
  2. 10.2POWER PIVOT in MS Excel
  3. 10.3DAX Functions in MS Excel
  4. 10.4MACROS in MS Excel
  5. 10.5DATA CREATION using AI
  6. 10.6FORMAT DATA using AI
  7. 10.7FUNCTIONS_FORMULAS using AI
  8. 10.8VISUALIZATION using AI
  9. 10.9AI MASTER CLASS-FUNCTIONS & VISUALIZATION
  10. 10.10DASHBOARD using AI-PART 1
  11. 10.11DASHBOARD using AI-PART 2
  12. 10.12ADVANCED DASHBOARD-MS EXCEL USING AI

Tools you'll use

Excel

Every course includes

Live, instructor-led classes Course materials & lab access Doubt-clearing sessions Final assessment + one free re-attempt Verifiable certificate

How certification works

Related courses

Data Science & Analytics

Business Analytics

Combine Excel, SQL, Power BI and Python to turn business data into decisions

from ₹6,000· 3 levels
7 mo
Data Science & Analytics

Data Analytics

Analyse data end-to-end with Excel formulas, pivot tables, SQL and Power BI

from ₹5,500· 3 levels
5 mo
Data Science & Analytics

Data Engineering

Write SQL, build Python data pipelines, and process big data with Spark

from ₹8,000· 3 levels
8 mo