Excel Advanced

Description

This Excel advanced 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
Price:
£240 (ex VAT)
Availability:
Scheduled dates
Course type:
Classroom
Locations:
London (Aldgate)

Contact Information

We Are Excel

WeWork Offices
2 Leman Street
London
E1 8FA

Locations