Domain 01 . Digital Foundations

Microsoft Excel Advanced

Hours of teaching

Intermediate to Advanced

Level

Modules

Classroom . Online . Hybrid

Mode

Course overview

An advanced Excel course for analysts who need reliable, repeatable models and dashboards. The course replaces manual spreadsheet habits with repeatable structures: proper tables, dynamic array formulas, Power Query transformations, a data model with measures, and dashboards that refresh rather than being rebuilt.

Learners deliver sales, finance and HR dashboards driven by refreshable queries.

Who it is for

Analysts and MIS executives
Finance, HR and operations staff
Managers building their own reports
Anyone preparing for Power BI

Prerequisites

Working knowledge of Excel formulas and pivot tables.

How it runs

Learn → Practise → Build → Experience → Demonstrate, ending in a capstone. Delivered by practitioners from the engineering bench, in Madurai, Coimbatore and online.

Final project

Automated Reporting Workbook

Programme sheet

The printed sheet carries the full module breakdown, labs, project work and certification path. Fees, dates and formats for the next intake are confirmed by the education team on enquiry.

Download the programme sheet →Enquire or apply →

Learning outcomes

Structure data for analysis rather than presentation.

Transform and combine sources with Power Query.

Create pivot-driven interactive dashboards.

Protect and audit workbooks for shared use.

Use XLOOKUP, INDEX/MATCH and dynamic arrays.

Build a data model with relationships and measures.

Automate repetitive work with macros and basic VBA.

Module structure

8 modules

Module 01

Foundations for Analysis

Tables and structured references . Data types . Error handling . Named ranges . Auditing tools . File hygiene

Module 02

Advanced Formulas

XLOOKUP . SUMIFS family . LET and LAMBDA . INDEX and MATCH . Dynamic arrays . Text and date functions

Lab

Formula Workbook

Module 03

Data Cleaning

Text to columns . Duplicates . Flash fill . Data validation . Find and replace patterns

Module 04

Power Query

Append and merge . Parameters . Transform steps . Unpivot . Refresh and load options

Lab

ETL for a Monthly Report

Module 05

Pivot Tables and Charts

Layouts . Grouping . Pivot charts . Slicers and timelines . GETPIVOTDATA

Module 06

Power Pivot and DAX

Data model . Measures . Time intelligence . Relationships . KPIs

Lab

Model-Driven Report . Calculate

Module 07

Dashboards

Layout principles . Interactivity . Form controls . Sparklines . Print and export

Lab

Sales Dashboard . Chart Selection

Module 08

Automation

Macro recorder . Loops and conditions . Scheduling . VBA basics . User forms overview . Error trapping

Assessment & certification

Module assignments and labs

25%

Mini projects

20%

Internal assessments

15%

Final project and review

40%

Learners who complete all modules, submit the final project and clear the review receive a course completion certificate from Kaizen Infinities Private Limited. Project work is documented for the learner's portfolio, and interview preparation is included in the closing sessions.

Career outcomes . Roles this programme prepares for

Data AnalystMIS ExecutiveFinance AnalystOperations AnalystReporting Specialist

Enquire or apply →Programme sheet (PDF)Institutions can commission a cohort

Also in Digital Foundations

01 . Digital FoundationsBasic Computer & IT SkillsSyllabus →01 . Digital FoundationsMS OfficeSyllabus →01 . Digital FoundationsTally & Accounting BasicsSyllabus →01 . Digital FoundationsDigital SkillsSyllabus →01 . Digital FoundationsBasic ProgrammingSyllabus →

All Digital Foundations programmes →