Excel Intermediate

For individuals who are already using Excel to an intermediate level. This course will streamline and perfect their Excel skills by teaching the advanced features available in the Excel package.

What you will learn:

Formula

VLookups
IF Statements
SumIf
CountIf(s)
Text Formula – Concatenate Linking Spreadsheets Separating Text Data

Data Analysis

Advanced Sort Options Filters
Subtotals
Updating Pivots

Icons & Data Bars in Conditional Formatting Filter & Sort Using Colour

Utilities

Protecting Data
Hide & Unhide Data Named Ranges
Working With Dates Working With Comments Data Validation Headers & Footers

Linking Data

Linking Spreadsheets Identifying Links
Linking Separate Workbooks

Pivot Tables

Creating Pivot Tables Pivot Charts
Slicers
Refreshing Data Updating Ranges

Duration: 1 Day

We now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 2 half day sessions.