A highly interactive training course on

Data Management, Manipulation & Analysis using Excel®

Excel with the Power of Data

Course Schedules

London

28 Apr-02 May 2025

$5,950

Dubai

08-12 Sep 2025

$5,950

Dubai

01-05 Dec 2025

$5,950

Training course overview

Never before has data been so readily available, generated from our daily routines, purchases, and business activities. This rich dataset offers incredible opportunities to solve problems and enhance various aspects of our lives, particularly in commercial activities. Traditionally, this problem-solving required advanced quantitative skills, but every desktop around the world is equipped with an underutilized tool: Excel.

In this Coventry Academy training course, you will learn how to leverage Excel to query data, test hypotheses, and tackle complex problems. By the end of the course, you will be proficient in over 50 Excel functions and a wide range of charts and analysis tools, empowering you to make data-driven decisions with confidence.

What are the goals?

By attending this Coventry Academy training course, you should achieve these goals:

Be Familiar with 50+ Excel Functions
Recognise the Right Chart for the Right Task
How to Manipulate Both Textual and Numerical Data
Be able to Analyse Data Using Appropriate Tools
Analyse Relationships Amongst Variables and Generate Forecasts

Who is this training course for?

This Coventry Academy training course is suitable for middle and senior managers who have responsibility for divisional or organizational success, as well as consultants and professionals who support them. For example:

Anyone with Line Manager Responsibility
HR Professionals
Oil and Gas, Energy and Telecom Team Engineers
Senior Finance Professionals
Board Level Executives and Non-Executives

Course Outline

Day 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

Day 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

Day Three: Intermediate MS Excel Functions

Use of VLOOKUP() and HLOOKUP()
Date functions, YEAR(), MONTH(), DAY(), YEARFRAC()
Selecting appropriate charts
Introduction to Pivot tables

Day 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

Day Five: What if and Scenario Analysis Using MS Excel