Excel Advanced Half Day (Office 2013 up to 365)


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

Email c.watson@smeofficesupport.co.uk