Excel Advanced Half Day (Office 2013 up to 365)
Overview:
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.
Expanding your functions toolbox
Recap on the basic IF function
Recap on creating & using range names
Nesting formulas
Using AND & OR
IFERROR
VLOOKUP & HLOOKUP
Effectively analysing your data
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:
- A laptop/computer with relevant software loaded
- Excel from version 2013 to O365 on a Windows PC/Laptop (this training doesn’t support Mac users)
- An integrated video camera and microphone/speaker (or external hardware)
- Fast/reliable internet connection
Training includes:
▪ 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