Microsoft Office Excel Intermediate

Prerequisites

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