This half day course is designed for those who require a greater knowledge of the more advanced features of Excel.
This is a 'power-user' half day course packed full of tips and tricks and where you will learn advanced functions. You will learn about how pivot tables are used to analyse data and best practice on how to effectively set out raw data to create pivot tables.
Recap on the basic IF function
Recap on creating & using range names
Nesting formulas
Using AND & OR
IFERROR
VLOOKUP & HLOOKUP
Creating Pivot Tables
Changing the look of your Pivot Table
Grouping your data
Updating Pivot Tables with new data
Filtering your data with a Slicer
Using a timeline
Creating a Pivot chart
During the training each delegate should have access to:
▪ Between 2-8 delegates
▪ Exclusive sessions for your business
▪ Online training from a highly experienced trainer
▪ Comprehensive course materials
▪ Certificate of course completion
▪ Flexible training at a date/time suitable for you
For more information contact Carol Watson 07787528287