Microsoft Office Excel Intermediate

Course Description

This Microsoft Excel course focuses on the need to produce real time reports using Charts and Pivot Tables and introduces new functions and data tools to help participants be more productive. Areas covered include If Statements, VLookup, data analysis functions, sorting and filtering data in tables, data validation and cleaning data . This is our most popular Microsoft Excel course and is a very comprehensive day for Excel users to really get to grips with the key functions they need.


Experienced MS Excel users who have completed a foundation course or have a similar level of knowledge.

Learning Outcomes

Having completed the training the attendees will be able to: Use the new features in MS Excel Identify new charts to communicate the key message Use a variety of functions to analyse business data Sort and Filter Data in predefined Tables Use data validation to control data entry Use the key functions of Pivot tables Use Get and Transform Data to clean and prepare data

New features in Excel

Flash fill, Quick Analysis & Tell me About

Working With Charts

Creating charts
Selecting charts from the Add-ins Store
Identifying and using the correct chart for your data
Creating Sparklines
Insert 3D map

Working with Functions and Formulas

Using Functions in Excel: IF Statements, VLookup and XLookup, CountIf, SumIf Working with Names and Ranges Using names to simplify formulas

New functions in Excel

Ifs, Switch, TextJoin, ConCat

Advanced Formatting

AutoFormat (Table Format)
Visualising Data using Conditional Formatting
Data Validation
Using Multiple Worksheets & Workbooks

Pivot Tables

Introduction to Pivot Tables
Manipulating data in the Pivot Table
Creating Pivot Charts
Using Slicers

Get and Transform Data

Introduction to Power Query


Microsoft Office Excel Intermediate 2024-03-12 Online
Microsoft Office Excel Intermediate 2024-04-25 Online
Microsoft Office Excel Intermediate 2024-06-13 Online