Advance Excel Skills

Description

This Advanced Excel Skills course provides Excel users with advance spreadsheet solutions to common data analysis challenges. Providing users with hands-on practise analysing and automating useful spreadsheet tasks. Nesting functions is a significant part of this training day where you will get significant practise in nesting Excel functions.

What you will learn

  • Performing spreadsheet calculations using Date & Time
  • Using Data Validation to control the input of data
  • Finding data using VLOOKUP and INDEX & MATCH
  • Nesting Logical Functions – IF, AND, OR, ISERROR
  • Analysing data with advance use of Pivot Tables
  • Automating repetitive tasks with macros – VBA

Further information

We Are Excel
Provider:
We Are Excel
Duration:
1 Day
Locations:
Birmingham, London

Contact Information

We Are Excel

Longcroft House
2-8 Victoria Avenue
London
EC2M 4YJ

Locations