The Excel Advanced level covers the following 2 modules.
Module 5 - Conditional Logic & Conditional Formatting
Understanding Conditional Logic, i.e. IF statements
Creating formulas using Basic Conditional Logic
Creating formulas using Nested IF Statements
Creating formulas using Nested AND & OR statements
Using the =Countif feature to count data meeting specified criteria
Using the =Sumif feature to total data meeting specified criteria
Using the =Averageif feature to find the average of data meeting specified criteria
Apply Conditional Formatting
Module 6 - Lookups, Pivot Tables, Text functions
Applying Data Validation to ensure the correct information is entered
Circling invalid data
Copying validation settings
Creation and use of VLOOKUP tables
XLOOKUP the new lookup tool (365 version only)
Creation and working with Excel Tables
Creation of Pivot Tables to display data in varying formats
Converting Text Strings to seperate columns
Combining cells from multiple cells into one cell
Using Flash Fill to quickly split or join data
Duration: 1 day
Date: Thursday 6th August 2026
Cost: Free to attend - Digital & Employment skills bitesize training fully funded
Venue: Online
Course Delivery: This course will be delivered by Pat Jones, PS Training.
Delegates should join the training in a quiet space, with minimal risk of disruption, and not to be called away during the session.
Book online using the booking form below, call 01686 628778 or email sam@mwmg.org
If there are no spots available and you wish to be added to the reserve list in case of cancellation please email sam@mwmg.org