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
Please note:
Our training programmes are designed to support individuals who are currently employed and participating through their organisations. For this reason, places on our courses are available to employees who are nominated by their companies.
Unfortunately, we are not able to offer places on these programmes to individuals who are not currently in employment.
If you are currently unemployed and interested in developing your skills, we encourage you to explore our Skills Connect programme, which is specifically designed to support people who are seeking employment.
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
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
