Professional training in London and 13 international cities info@llmi.uk
Enquire

Professional training course

Data Management, Manipulation & Analysis using Excel®

Course Introduction Data has become more accessible than ever, generated through our daily activities, purchases, and business operations. This wealth of information…

  • 5 daysClassroom
  • 13Upcoming dates
  • 6Cities
  • £2,850Fees from
View dates & register Get quotation Download PDF
Data Management, Manipulation & Analysis using Excel®
Next classroom session Frankfurt 14 - 18 Dec 2026 · £3,250 Also available Istanbul 18 - 22 Jan 2027 · £2,850

Course overview

Course Introduction

Data has become more accessible than ever, generated through our daily activities, purchases, and business operations. This wealth of information offers immense potential for problem-solving and driving improvements, especially in commercial environments. Historically, addressing such challenges required advanced quantitative expertise. However, Excel—a widely available yet often underutilized tool—can effectively meet these demands. 

In the "Data Management, Manipulation & Analysis using Excel®" training course, participants will learn to leverage Excel for data querying, hypothesis testing, and solving complex problems.

By course completion, attendees will gain proficiency in over 50 Excel functions, various chart types, and an array of analysis tools, enabling them to harness data for actionable insights and informed decision-making.

Training Objectives

By attending this training course, participants will achieve the following objectives:

  • Develop proficiency with over 50 Excel functions.
  • Identify the most appropriate chart for specific tasks.
  • Effectively manipulate both textual and numerical data.
  • Conduct data analysis using suitable tools.
  • Analyse relationships between variables and generate accurate forecasts.

Who should Attend?

This training course is designed for middle and senior managers responsible for divisional or organizational outcomes, as well as consultants and professionals who support them. Suitable participants include:

  • Individuals with line management responsibilities.
  • HR professionals.
  • Engineers in the Oil and Gas, Energy, and Telecom sectors.
  • Senior finance professionals.
  • Board-level executives and non-executive directors.


Course outline

  1. 1Day One: An Introduction to the MS Excel Environment
    • Cell referencing, cell formatting and entering formula
    • Workbooks versus Worksheets
    • Copy and pasting
    • Left click versus right click
    • Paste Special
    • Introductory charts
  2. 2Day Two: Using MS Excel Functions for Fundamental Data Analysis
    • Use of text function, FIND(), LEN(), LEFT(), RIGHT() and &
    • Use of count functions, COUNTA(), COUNTIF(), COUNTIFS() and SUMIF()
    • Basic statistical functions, Max and Average
    • Filtering, sorting and use of conditional formatting
    • Scatter diagrams
  3. 3Day Three: Intermediate MS Excel Functions
    • Use of VLOOKUP() and HLOOKUP()
    • Date functions, YEAR(), MONTH(), DAY(), YEARFRAC()
    • Selecting appropriate charts
    • Introduction to Pivot tables
  4. 4Day Four: Carrying out Statistical Analysis using MS Excel
    • Using MS Excel to calculate mean, mode and median
    • The difference between the various standard deviation and variance function in MS Excel
    • Using MS Excel to examine inter-dependency
    • Drawing histograms in MS Excel
    • Introduction to Data Analysis functions
  5. 5Day Five: What if and Scenario Analysis Using MS Excel
    • Naming cells in MS Excel
    • Linking cells together to undertake scenario analysis
    • Introduction to solver
    • Advanced charting
    • Sharing MS Excel output with other office formats

Schedule

Dates and fees

13 upcoming dates in 6 cities. Fees are per delegate; bring colleagues and every seat is discounted.

All dates as PDF
December 2026
14DEC 14 - 18 Dec 2026Mon to Fri · 5 daysNext session
Germany flag FrankfurtGermany · Classroom
£3,250per delegate2+ people: £2,600 each
Register
January 2027
18JAN 18 - 22 Jan 2027Mon to Fri · 5 days
Turkey flag IstanbulTurkey · Classroom
£2,850per delegate2+ people: £2,280 each
Register
February 2027
15FEB 15 - 19 Feb 2027Mon to Fri · 5 days
South Africa flag Cape TownSouth Africa · Classroom
£4,250per delegate2+ people: £3,400 each
Register
March 2027
15MAR 15 - 19 Mar 2027Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£3,850per delegate2+ people: £3,080 each
Register
April 2027
19APR 19 - 23 Apr 2027Mon to Fri · 5 days
France flag ParisFrance · Classroom
£4,500per delegate2+ people: £3,600 each
Register
May 2027
17MAY 17 - 21 May 2027Mon to Fri · 5 days
Germany flag FrankfurtGermany · Classroom
£3,250per delegate2+ people: £2,600 each
Register
June 2027
21JUN 21 - 25 Jun 2027Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£3,850per delegate2+ people: £3,080 each
Register
July 2027
19JUL 19 - 23 Jul 2027Mon to Fri · 5 days
Germany flag FrankfurtGermany · Classroom
£3,250per delegate2+ people: £2,600 each
Register
August 2027
16AUG 16 - 20 Aug 2027Mon to Fri · 5 days
Turkey flag IstanbulTurkey · Classroom
£2,850per delegate2+ people: £2,280 each
Register
September 2027
20SEP 20 - 24 Sep 2027Mon to Fri · 5 days
Austria flag ViennaAustria · Classroom
£4,250per delegate2+ people: £3,400 each
Register
October 2027
18OCT 18 - 22 Oct 2027Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£3,850per delegate2+ people: £3,080 each
Register
November 2027
15NOV 15 - 19 Nov 2027Mon to Fri · 5 days
France flag ParisFrance · Classroom
£4,500per delegate2+ people: £3,600 each
Register
December 2027
20DEC 20 - 24 Dec 2027Mon to Fri · 5 days
Germany flag FrankfurtGermany · Classroom
£3,250per delegate2+ people: £2,600 each
Register

Questions

Frequently asked questions

How long is the Data Management, Manipulation & Analysis using Excel® course?

The course runs over 5 days of classroom training, usually Monday to Friday.

When is the next Data Management, Manipulation & Analysis using Excel® course?

The next public date is 14 - 18 Dec 2026 in Frankfurt. There are 13 upcoming dates in total.

Where is this course held?

Upcoming sessions run in Frankfurt, Istanbul, Cape Town, Barcelona, Paris, Vienna.

How much does the course cost?

Fees start from £2,850 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 Digital Innovation and Transformation courses

View all

Training a team?

Any course in our catalogue can be delivered privately for your organisation, at your offices or in one of our cities, with content shaped around your goals.

Plan in-house training Speak to an advisor