Advanced Excel for Data Analysis
Overview
Excel remains the most widely used analysis tool in organisations. This practical course builds advanced skills in formulas, lookups, PivotTables, data cleaning, what-if analysis and dashboards, so participants can analyse data faster and more reliably.
Who should attend
Analysts, accountants, administrators, and professionals who work regularly with Excel data.
Training methodology
Interactive presentations, practical exercises, case studies, group discussions, role-plays where relevant, and a personal action plan that participants apply in their own work.
Objectives
By the end of this course, participants will be able to:
- Use advanced formulas and lookup functions
- Clean and structure data for analysis
- Summarise data with PivotTables and PivotCharts
- Perform scenario and what-if analysis
- Build simple interactive dashboards
Course outline
Day 1Formulas and Functions
- Logical functions
- Text and date functions
- Named ranges
- Error handling
- Exercises
Day 2Lookups and Data Preparation
- XLOOKUP and INDEX-MATCH
- Data validation
- Removing duplicates and cleaning
- Tables and structured references
- Exercises
Day 3PivotTables
- Creating PivotTables
- Grouping and calculated fields
- Slicers and timelines
- PivotCharts
- Exercises
Day 4What-If Analysis
- Goal Seek
- Scenario Manager
- Data tables
- Introduction to Power Query
- Exercises
Day 5Dashboards
- Dashboard design
- Conditional formatting
- Dynamic charts
- Protecting workbooks
- Final project
