Data Analysis with Excel for Professionals (DMBI-020) Training Course

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 or online

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

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.

Can I take Data Analysis with Excel for Professionals online?

Yes. Every date can also be joined live online in a virtual classroom with the trainer, for £1,050 per participant. Choose "Live online" in the dates table when you register.

How much does the course cost?

Fees start from £2,840 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.

Data Analysis with Excel for Professionals

Course overview

Course outline

Dates and fees

Frequently asked questions

More Data Management and Business Intelligence courses

Advanced Data Analysis Techniques

Advanced Power BI: DAX and Data Modelling

ArcGIS Pro: Essential Workflows

Training a team?