COURSE OVERVIEW

Excel Mastery is a focused, hands-on workshop that takes you from competent spreadsheet user to confident analyst. It is built on a simple premise: the Excel features you already half-know are exactly the ones AI tools build upon, and understanding how they work under the hood makes you dramatically more effective at prompting AI to help you.
The single two-hour session moves in two halves. First, we rebuild your foundations and push into the modern formula layer — multi-condition aggregation, XLOOKUP, LAMBDA, dynamic arrays and PIVOTBY. Then we bring AI into the workflow, using Claude to assess data quality, clean dirty datasets, resolve mismatched keys and reshape data that traditional joins cannot handle.
You will leave with working formulas, reusable prompt templates and a repeatable cleaning framework you can apply to your very next dataset

COURSE MODULES

Lecture A : Excel Power Fundamentals

Lecture B : AI-Powered Data Work

LEARNING OUTCOMES

By the end of the session you will be able to:

• Write confident multi-condition formulas using SUMIFS, XLOOKUP, XMATCH and LAMBDA
• Judge when a Pivot Table is the right tool, and when to migrate to a formula-driven summary
• Replace refresh-dependent reports with self-updating dynamic array and PIVOTBY pipelines
• Prompt AI tools to generate, explain and debug Excel formulas reliably
• Detect duplicates, outliers and logical errors across large datasets with Claude
• Merge datasets with imperfect or semantically different keys through AI-assisted resolution
• Build documented, reusable cleaning templates that you can apply to every new dataset

WHO SHOULD ATTEND

• Data Analysts
• MIS & MEL Professionals
• Researchers
• Evaluators
• Programme Managers
• Finance & Operations Teams
• New Job Aspirants

Course Fees

LAUNCH ANNOUNCEMENT COMING SOON!

The exact batch dates will be announced shortly. Register your interest today to be the first to know!