Advanced Data Analysis Techniques
Next: 21 - 25 Dec 2026 · Barcelona
Barcelona, Amsterdam, London +2 more
Professional training course · DMBI-020
Data Analysis with Excel for Professionals
Excel remains the most widely used analysis tool in business. Professionals who master its analytical features can answer questions faster, reduce errors and produce…
- 5 daysClassroom
- 14Upcoming dates
- 7Cities
- £2,840Fees from
Course overview
Why Attend
Excel remains the most widely used analysis tool in business. Professionals who master its analytical features can answer questions faster, reduce errors and produce clearer insights.
This LLMI course builds practical data analysis skills in Excel: cleaning and preparing data, formulas and lookup functions, PivotTables and PivotCharts, Power Query, what-if analysis, statistical functions and dashboards. Participants work with realistic business datasets throughout the week.
Course Objectives
Clean and prepare data efficiently
Use advanced formulas and lookup functions
Analyse data with PivotTables and PivotCharts
Transform data with Power Query
Apply what-if and statistical analysis
Build clear Excel dashboards
Target Audience
Business and financial analysts
Managers working with data
Administrative and reporting staff
HR, sales and operations professionals
Project coordinators
Excel users wanting stronger analysis skills
Course Methodology
Hands-on Excel labs
Realistic business datasets
Step-by-step demonstrations
Practice challenges
Dashboard project
Course outline
-
1Day 1: Preparing Data
- Data structure best practice
- Cleaning techniques
- Text and date functions
- Data validation
- Tables
- Lab: Cleaning a dataset
-
2Day 2: Formulas and Lookups
- Logical functions
- XLOOKUP and INDEX-MATCH
- Dynamic arrays
- Error handling
- Named ranges
- Lab: Lookup exercises
-
3Day 3: PivotTables
- Building PivotTables
- Grouping and calculated fields
- Slicers
- PivotCharts
- Analysis techniques
- Lab: Sales analysis
-
4Day 4: Power Query and Analysis
- Power Query transformations
- Combining data
- What-if analysis
- Statistical functions
- Forecasting
- Lab: Power Query project
-
5Day 5: Dashboards
- Dashboard design
- Charts
- Interactivity
- Automation tips
- Presenting insights
- Capstone: Excel dashboard
Dates and fees
Questions
Frequently asked questions
How long is the Data Analysis with Excel for Professionals course?
The course runs over 5 days of classroom training, usually Monday to Friday.
When is the next Data Analysis with Excel for Professionals course?
The next public date is 16 - 20 Nov 2026 in Paris. There are 14 upcoming dates in total.
Where is this course held?
Upcoming sessions run in Paris, Istanbul, Amsterdam, London, Cape Town, Barcelona, Vienna.
How much does the course cost?
Fees start from £2,840 + VAT per delegate, depending on the city. Fees include tuition and course materials.
Do participants receive a certificate?
Yes. Delegates who complete the course receive a London Leadership Management Innovation certificate of completion.
Can this course be delivered in-house for our team?
Yes. LLMI can tailor and deliver this course privately for your organisation at your premises or in one of our training cities.
Course information last updated 14 November 2026.
Related
More Data Management and Business Intelligence courses
Advanced Power BI: DAX and Data Modelling
Next: 16 - 20 Nov 2026 · Vienna
Vienna, Barcelona, Rome +4 more
ArcGIS Pro: Essential Workflows
Next: 16 - 20 Nov 2026 · Barcelona
Barcelona, Dubai, Cape Town +11 more