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