training@british-skills.co.uk+447700100602www.british-skills.co.ukBRT Skills Training FZCO, IFZA, Dubai Silicon Oasis, Dubai, United Arab EmiratesIssued: 3 November 2026
AI, Data & Digital Transformation
Advanced Excel for Data Analysis
Course codeAIX-DAT-004
Duration5 days
LanguageEnglish or Arabic
Subject areaAI, Data & Digital Transformation
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
Upcoming dates and fees
| Dates | Venue | Fee |
|---|---|---|
| 7–11 December 2026 | Online | £2,450 per delegate |
| 8–12 March 2027 | London | £4,950 per delegate |
| 17–21 May 2027 | Madrid | £4,750 per delegate |
More dates and online registration: www.british-skills.co.uk/training-course/advanced-excel-for-data-analysis