Excel Advanced Level - Advanced Formulas & Database Functions - Welshpool

The Excel Advanced level covers the following 2 modules.

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: Wednesday 17th December 2025

Cost: Free to attend - Digital & Employment skills bitesize training fully funded by Welsh Government

Venue: Welshpool

Course Delivery: This course will be delivered by Pat Jones, PS Training.

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