Excel Advanced with AI – Live Course (Basic to Advanced)

Note : The Advance Excel LIVE Course Batch Timings is 7:10pm to 8:00pm 

MICROSOFT EXCEL – COMPLETE COURSE SYLLABUS | 67 Sessions | 12 Modules | 1 Capstone Dashboard Project

MODULE 1: Excel Fundamentals & Interface

Session 1 – Course Introduction & Roadmap

Introduction to Microsoft Excel and its relevance
Why Excel is essential across all industries
Road map of Data Analytics
Course structure and learning methodology
Session 2 – Excel Interface – Part I

Outer and inner interface of Excel
Understanding Worksheets vs. Workbooks
Navigating the Excel environment
Session 3 – Excel Interface – Part II

Completing the interface overview
Checking and understanding Excel versions
Importance of version compatibility
Changing themes and customizing the Ribbon (adding tabs & features)
Session 4 – Navigation & Data Entry

Cell, sheet, and workbook movement shortcuts
Manual data entry techniques and shortcut keys
Serial number writing techniques
Session 5 – Selection, Insert/Delete & Sheet Management

Selection shortcut keys
Inserting and deleting columns, rows, and cells
Renaming sheets and applying tab colors
Sheet selection shortcuts
Heading creation
Auto-adjusting cell height and width
Clearing data
MODULE 2: Formatting & Data Management

Session 6 – Formatting Basics – Alignment

Understanding the meaning of formatting
Creating headings professionally
Alignment group — detailed walkthrough
Session 7 – Font & Alignment Groups

Completing the Font group
Completing the Alignment group
Shortcut keys for formatting
Building a complete, well-formatted dataset
Session 8 – Clipboard Group & File Management

Clipboard group: Format Painter, Copy, Cut, Paste, Multiple Copy-Paste
File tab: Save, Save As, AutoSave
Excel file extensions
Session 9 – Number & Date Formats

Number formatting in depth
Date formatting — detailed explanation and practical usage
MODULE 3: Formulas & Functions – Core

Session 10 – Formulas & Functions – Introduction

Difference between functions and formulas
Basic arithmetic formulas
Different types of SUM
Session 11 – Core Statistical Functions

SUM, PRODUCT, COUNT, COUNTA, COUNTBLANK
MAX, MIN, AVERAGE
Session 12 – Advanced Math Functions

SUMPRODUCT
SUMX2PY2, SUMX2MY2, SUMXMY2 and related functions
MODULE 4: Conditional Formatting, Filter & Sort

Session 13 – Conditional Formatting – Part I

Highlight rules: Number, Text, and Date conditions
Duplicate value highlighting
Session 14 – Conditional Formatting – Part II

Data Bars and Icon Sets
Quick Handle shortcut key
Session 15 – Filter & Custom Filtering

Applying basic filters
Custom filter conditions and criteria
Session 16 – Filtration & Sorting – Introduction

Completing filtration techniques
Introduction to sorting data
Session 17 – Sorting & Tables – Introduction

Completing sorting (single and multi-level)
Understanding the meaning of a Table
Data range vs. Table — key differences
Session 18 – Excel Tables – Deep Dive

Creating Tables in Excel
Detailed explanation of all table features and settings
Session 19 – Fill Series

Using Fill Series for sequential data
Custom series, auto-fill patterns and practical applications
MODULE 5: Advanced Formulas

Session 20 – Cell Referencing – Introduction

Understanding relative, absolute, and mixed cell referencing
Practical demonstrations
Session 21 – Number Category Formulas & Cell Referencing

Number category formulas
Completing cell referencing concepts with practical examples
Session 22 – Text Functions – Part I

TEXT, LEN, TRIM, TEXTJOIN, TEXTSPLIT
CONCATENATE, CONCAT, LEFT, RIGHT, MID
LOWER, UPPER, PROPER
SUBSTITUTE, SEARCH, FIND, REPLACE
Session 23 – Text Functions – Part II

Completing all Text category functions
Practical assignments and use cases
Session 24 – Date & Time Functions – Part I

DATE, DAY, MONTH, YEAR, TEXT
DAYS, DAYS360, NETWORKDAYS, NETWORKDAYS.INTL
WORKDAY, WORKDAY.INTL, EDATE, EOMONTH
TIME, HOUR, MINUTE, SECOND, DATEDIF, YEARFRAC, WEEKNUM
Session 25 – Date & Time Functions – Part II

Completing all Date & Time category functions
Real-world scenarios and practice
Session 26 – Logical Functions – Basics

Understanding logical formulas
IF, AND, OR with practical examples
Session 27 – Nested Logical Functions

SWITCH function
IF with AND / IF with OR
Nested IF for multiple conditions
Session 28 – Array Functions

SEQUENCE, UNIQUE
VSTACK, HSTACK
TOCOL, TOROW
Session 29 – Intermediate Conditional Functions

SUMIF, AVERAGEIF, COUNTIF
IFS function with multiple conditions
MODULE 6: Lookup & Reference Functions

Session 30 – Lookup & Reference – Introduction

Understanding the Lookup & Reference category
Overview of when and why to use lookup functions
Session 31 – VLOOKUP & HLOOKUP

VLOOKUP with various conditions
HLOOKUP explained with examples
Session 32 – XLOOKUP & Advanced Lookup

XLOOKUP in depth
Returning multiple values with VLOOKUP and XLOOKUP
VLOOKUP with TRUE condition (approximate match)
Session 33 – Nested & Combined VLOOKUP

Nested VLOOKUP
VLOOKUP with CHOOSE
VLOOKUP with MATCH
Session 34 – INDEX, MATCH & XMATCH

INDEX function
MATCH function
INDEX-MATCH combination
XMATCH explained
MODULE 7: Reporting & Specialized Functions

Session 35 – Advanced Reporting Formulas

Creating reports using SUMIFS
AVERAGEIFS and COUNTIFS
Multi-criteria reporting scenarios
Session 36 – FILTER Formula & Developer Tab Automation

FILTER formula with multiple conditions
Building a dynamic search box
Introduction to Developer Tab automation
Session 37 – Specialized & Database Functions

LAMBDA formula
REGEXEXTRACT, REGEXREPLACE
DGET, DSUM, DAVERAGE, DCOUNT
Session 38 – Go To Special – Part I

Understanding Go To Special
Selecting blanks, formulas, constants, errors, and more
Session 39 – Go To Special & Find and Replace

Completing Go To Special
Find and Replace — complete walkthrough with advanced options
Session 40 – Paste Special

All Paste Special options explained
Values, formats, transpose, operations — practical usage
MODULE 8: Data Visualization & Charts

Session 41 – Insert Tab – Visuals & Illustrations

Overview of the Insert tab
Images, Shapes, Icons, Illustrations
3D Models and their usage
Session 42 – Pivot Tables – Introduction

What is a Pivot Table and why use it
Recommended Pivot Tables
Generating datasets using AI prompts
Data overview and creating your first Pivot Table
Session 43 – Pivot Table Design Tab

Complete walkthrough of the Pivot Table Design tab
Styles, layouts, and formatting options
Session 44 – Pivot Table Options

Detailed Pivot Table options settings
Display, layout, and data options
Session 45 – Pivot Table – Show Values As

Show Values As: % of total, running total, difference, and more
Advanced value display settings
Session 46 – Pivot Table Settings Completed

Completing all Pivot Table settings
Field settings, grouping, filters, and slicers
Session 47 – Chart Fundamentals

Chart elements explained
Difference between Bar and Column charts
Best practices for choosing chart types
Session 48 – Bar, Column & Advanced Charts

Bar Chart and Column Chart creation
Dual-axis (two-axis) chart
Thermometer chart
Session 49 – Pie, Line & Hierarchy Charts

Pie Chart and Donut Chart
Line Chart and Area Chart
Treemap Chart and Sunburst Chart
Session 50 – Statistical & Specialty Charts

Histogram
Map Chart
Radar Chart and Funnel Chart
MODULE 9: Dashboard Project

Session 51 – Dashboard Project – Kickoff

Creating and understanding the dataset
Data overview and analysis
Client handling for freelancing projects
Session 52 – Dashboard Planning & KPI Creation – Part I

Dashboard layout planning
KPI planning and defining metrics
Beginning KPI creation
Session 53 – KPI & Visualization

Completing KPI creation
Visualization planning
Building visual elements
Session 54 – Dashboard Construction – Part I

Completing visualizations
Initial dashboard settings
Planning and beginning dashboard layout
Session 55 – Dashboard Construction – Part II

Continuing dashboard creation
Refinement and data connections
Session 56 – Dashboard – Completion & Extras

Finalizing the dashboard with hyperlinks and icons
QR Code generation using AI
Add-in integrations
Session 57 – AI-Powered Reporting

Dashboard and report creation using AI tools
Using Claude, Copilot, and ChatGPT in Excel workflows
Presenting your dashboard via AI-generated PowerPoint
MODULE 10: Excel Tools & Data Management

Session 58 – Sparklines, Formula Tab & View Tab

Creating and customizing Sparklines
Formula tab walkthrough
View tab options
Session 59 – Review Tab & Page Layout

Review tab: comments, protection, and spell check
Introduction to Page Layout tab
Session 60 – Print Settings

Complete print setup walkthrough
Page breaks, print areas, headers, and footers for print
Session 61 – Data Tab & Validation – Part I

Data tab overview
Advanced Filter
Flash Fill and Text to Columns
Introduction to Data Validation
Session 62 – Data Validation & Consolidation

Completing Data Validation (dropdowns, custom rules)
Data Consolidation from multiple sheets/sources
Session 63 – Data Analysis Tools & Power Query Intro

Forecasting and Data Table
Subtotal and Goal Seek
Introduction to Power Query
MODULE 11: Power Query & Automation

Session 64 – Power Query – Interface & Transforms

Power Query interface overview
Importing data from various sources
Transformations: Trim, Proper, Lower, Upper, Suffix, Prefix, Split
Session 65 – Power Query – Merge, Append & Automation

Merging and appending queries
How automation works in Power Query
Introduction to data cleaning concepts
Session 66 – Macro Recording & VBA Introduction

Recording macros
Developer tab tools overview
Writing VBA code with the help of AI
MODULE 12: Career & Placement Guidance

Session 67 – Career Guidance & Course Wrap-Up

How to build an ATS-friendly resume
Job application strategies and top job portals
Career counselling for Excel & Data Analytics roles
Future scope of Excel in the industry