Advanced Excel for Analytics
Power Query, PivotTables, the Data Model and modern Excel functions for faster analysis.
- ✓ Instructor-led live sessions, online or in Bengaluru
- ✓ Hands-on labs in every module
- ✓ Capstone project with trainer review
- ✓ Curriculum customisable for corporate teams
- ✓ Certificate of completion
Next batch: Sat, 28 Nov 2026 · 16 hours · 2 days
Advanced Excel for Analytics
Duration: 16 hours · 2 days
Next batch: Sat, 28 Nov 2026
Format: Online live · Bengaluru classroom
Modules: 7 · Topics: 34
Level: Beginner to Intermediate
Fee: ₹7,499
Trusted by leading experts
Upcoming batches
Open batches for individuals; corporate batches on your dates.
| Programme | Starts | Mode | Schedule | Duration | |
|---|---|---|---|---|---|
| Advanced Excel for Analytics | Sat, 28 Nov 2026 | Online live | Weekend (Sat) | 3 Saturdays | Enquire |
| Advanced Excel for Analytics | Wed, 03 Feb 2027 | Online live | Weekday | 2 days | Enquire |
Soaring demand, and where it takes you
Excel remains the most widely used analysis tool in business, and modern features can save teams significant time.
Become an expert
Roles this programme prepares you for:
Become a Excel Power User
Automates analysis with modern Excel.
- Clean and combine data with Power Query
- Summarise data with PivotTables
- Model data with the Data Model and relationships
About the course
Modern Excel for analysis: Power Query for repeatable data preparation, PivotTables and the Data Model, dynamic array functions, lookup functions and clear charts.
Power Query, PivotTables, the Data Model and modern Excel functions for faster analysis.
Why should I attend?
Business users
Finance, HR and operations staff
Analysts
Managers who build reports
Prerequisites
Basic Excel (formulas, formatting)
Level
Beginner to Intermediate
Delivery modes, duration and fee
Online live
Instructor-led virtual classroom; weekday (full-day) or weekend (Saturday) batches
Bengaluru classroom
In-person batches at our Bengaluru training venue
On-site at your office
Private corporate batch anywhere in India, scheduled around your teams
Blended
Live sessions plus guided self-paced labs and mentor check-ins
Duration: 16 hours · 2 days
Course fee (open batch): ₹7,499
Corporate / team batches: per-participant or flat batch pricing on request, based on group size, format and customisation.
What will you learn
- Clean and combine data with Power Query
- Summarise data with PivotTables
- Model data with the Data Model and relationships
- Use dynamic arrays such as FILTER, SORT and UNIQUE
- Use XLOOKUP and other modern lookups
- Build clear charts and simple dashboards
Skills you will gain
Data preparation
Analysis
Presentation
Tools and platforms covered
Course curriculum
M01 Modern Excel overview
- Tables
- Structured references
- Good practice
- Data validation
- Named ranges
🧪 Hands-on: Convert ranges to tables
M02 Power Query
- Importing
- Transforming
- Merging and appending
- Unpivoting
- Custom columns
🧪 Hands-on: Automate a monthly report
M03 PivotTables
- Summaries
- Grouping
- Slicers
- Calculated fields
- Timelines
🧪 Hands-on: Analyse sales data
M04 Data Model
- Relationships
- Measures basics
- Multiple tables
- DAX measures
- Power Pivot
🧪 Hands-on: Build a multi-table pivot
M05 Functions
- XLOOKUP
- Dynamic arrays
- LET and LAMBDA overview
- FILTER, SORT, UNIQUE
- Error handling
🧪 Hands-on: Solve lookup problems
M06 Charts and dashboards
- Chart choice
- Formatting
- Dashboard layout
- Conditional formatting
- Sparklines
🧪 Hands-on: Build a dashboard
M07 Capstone: analytics dashboard
- Import
- Model
- Analyse
- Dashboard
🧪 Hands-on: Build a refreshable sales dashboard
Hands-on projects
Automated monthly report
A refreshable Excel report built on Power Query and PivotTables.
Why train with us
Built around your stack
Labs and examples adapted to the tools, cloud and data your team actually uses.
Practice-first
Every module ends in a lab, and the course ends with a reviewed capstone.
Practitioner-led
Delivered by Karthick Selvam and vetted specialist trainers from our network.
Visible progress
Attendance, lab completion and assessment results shared with your L&D team.
Certificate of completion
Participants who complete the labs and capstone receive a Learning Dots certificate of completion for Advanced Excel for Analytics. [confirm certificate wording / sample image]
Learner reviews
“[Verified learner review for this course]”
“[Verified learner review for this course]”
Meet your trainer
Karthick Selvam
Founder · Data Engineering Corporate Trainer, Bengaluru
[Trainer bio, experience and areas of expertise]
Frequently asked questions
Which Excel version is needed?
Microsoft 365 Excel is recommended for dynamic arrays.
Can the curriculum be customised for our team?
Yes. Modules, depth, duration and labs can be tailored to your stack and goals.
What delivery formats are available?
Online live instructor-led sessions, Bengaluru classroom, or on-site at your office.
How do we enquire or book?
Use the enquiry form on this page or the Enquire button next to any batch.
What does it cost?
The open-batch fee is ₹7,499 per participant plus GST. Corporate batches are priced on group size, format and customisation.
How long is the course?
16 hours · 2 days. Corporate batches can be split into half-day sessions.
A closer look
About this course
Modern Excel for analysis: Power Query for repeatable data preparation, PivotTables and the Data Model, dynamic array functions, lookup functions and clear charts.
What is Advanced Excel for Analytics?
Power Query, PivotTables, the Data Model and modern Excel functions for faster analysis.
Who this course is for
Business users, Finance, HR and operations staff, Analysts, Managers who build reports.
What you will be able to do
Clean and combine data with Power Query. Summarise data with PivotTables. Model data with the Data Model and relationships. Use dynamic arrays such as FILTER, SORT and UNIQUE. Use XLOOKUP and other modern lookups. Build clear charts and simple dashboards.
Career paths
Roles this course supports include Excel Power User, Financial Analyst, Operations Analyst. Excel remains the most widely used analysis tool in business, and modern features can save teams significant time.
Related courses
Advanced SQL for Data Professionals
Window functions, CTEs, query plans, modelling for analytics and writing SQL that scales.
Power BI for Business Analytics
Data modelling, DAX, Power Query and dashboard design for decision-makers.
Analytics & BIPython for Data Engineering & Analysis
Python, pandas and automation for cleaning, transforming and moving data reliably.
Data & Analytics guides
Python vs SQL for Data Work: Which to Learn First?
SQL and Python solve different parts of data work. Most data professionals need both.
What Is Power BI?
Power BI is Microsoft's business intelligence platform for connecting to data, modelling it and building interactive reports.
What Is Data Science?
Data science combines statistics, programming and domain knowledge to extract insights and build predictive models from data.
Power BI vs Tableau: Which Should Your Team Learn?
Both are leading BI tools. The best choice usually depends on your existing ecosystem.