
Description
This course is for highly experienced Excel users who have either completed the Intermediate course or who have sufficient experience to be familiar with the Intermediate topics.
Duration
Classroom: 1 day
Online: 1 day
Course Content
- Revision of basics: basic formulas, using absolute/fixed, basic functions
- Advanced Worksheet Functions
- Left, Right, Mid
- If, And, Or, If Error
- The Lookup Functions
- Vlookup: revision of basics/adding extra levels to it
- Sumif/Sumifs/Countif/Countifs
- Conditional Formatting – revision of basics
- Conditional Formatting - beyond the basics
- Data Entry Validation – creating dropdown lists
- Working with named ranges
- Pivot Tables – revision of basics
- Further Work With Pivot Tables including Show Values As, adding a pivot chart, using the slicer
- Using Tables
- Macros and the VBA Project Window
- Introduction to Dashboards – putting it all together
This training will be delivered by Clare Commins - Study Focus