London Leadership Management Innovation llmi.uk
info@llmi.uk
Data Management and Business Intelligence · DMBI-020

Data Analysis with Excel for Professionals

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

Day 1: Preparing Data
  • Data structure best practice
  • Cleaning techniques
  • Text and date functions
  • Data validation
  • Tables
  • Lab: Cleaning a dataset
Day 2: Formulas and Lookups
  • Logical functions
  • XLOOKUP and INDEX-MATCH
  • Dynamic arrays
  • Error handling
  • Named ranges
  • Lab: Lookup exercises
Day 3: PivotTables
  • Building PivotTables
  • Grouping and calculated fields
  • Slicers
  • PivotCharts
  • Analysis techniques
  • Lab: Sales analysis
Day 4: Power Query and Analysis
  • Power Query transformations
  • Combining data
  • What-if analysis
  • Statistical functions
  • Forecasting
  • Lab: Power Query project
Day 5: Dashboards
  • Dashboard design
  • Charts
  • Interactivity
  • Automation tips
  • Presenting insights
  • Capstone: Excel dashboard

Dates and fees

DatesCityFee
16 - 20 Nov 2026Paris, France£4,500
7 - 11 Dec 2026Istanbul, Turkey£2,850
11 - 15 Jan 2027Amsterdam, Netherlands£4,250
8 - 12 Feb 2027London, United Kingdom£4,200
8 - 12 Mar 2027Istanbul, Turkey£2,850
12 - 16 Apr 2027Cape Town, South Africa£2,840
10 - 14 May 2027Barcelona, Spain£3,850
14 - 18 Jun 2027Paris, France£4,500
12 - 16 Jul 2027Istanbul, Turkey£2,850
9 - 13 Aug 2027Amsterdam, Netherlands£4,250
13 - 17 Sep 2027London, United Kingdom£4,200
11 - 15 Oct 2027Istanbul, Turkey£2,850
8 - 12 Nov 2027Vienna, Austria£4,250
13 - 17 Dec 2027Barcelona, Spain£3,850
London Leadership Management InnovationRegister at llmi.uk/course/data-analysis-with-excel-for-professionals