ADVANCED Excel Training - Online
Category
Work Processes
Audience
Anyone interested.
Duration
3 hours
Delegate rate
Approximately £100 per day per delegate. Charges depend on how many delegates book.
This course is designed to take delegates with a reasonable existing knowledge of Excel to the next level. It introduces some of the more frequently used functions, data analysis tools and data management tools.
Common Functions:
- Review of using absolute references
- IF and nested IF
- SUMIF and COUNTIF
Working with Formulas and functions to improve reliability:
- The formula auditing toolset
- Using data validation
- Validating data with IF and ISERROR functions
- Using IFERROR as an alternative to IF and ISERROR
Advanced use of formulas and other tools:
- Review of VLOOKUP
- Using XLOOKUP instead of VLOOKUP
- Using Excel’s new “spill” functions
- Advanced use of Conditional Formatting
Introduction to PivotTables:
- What are PivotTables
- Creating simple PivotTables
- Adding multiple fields to PivotTables
30 June 2026 at 01:30
Delivered online. You must attend all the sessions.
Please note you will be expected to use your camera and display your name on all training. If unable to comply, please ensure the trainer understands why and notes your name and authority for recording attendance.
11 spaces remaining