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.
1 day
€250.00
 

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

ExcelExcel 2016Microsoft ExcelMicrosoft Excel 2016MS ExcelExcel 365Excel 2019xlookupOffice 365Excel 2021LAMBDA