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