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. Cost EUR 95
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
