Advanced Excel goes beyond basic spreadsheet skills — complex formulas, data analysis with PivotTables, data cleaning, automation with macros/VBA, and professional visualisations and reports.
Advanced Formulas and Functions
-
Complex and nested formulas such as VLOOKUP, INDEX, MATCH, IF, AND and OR.
-
Text functions such as TEXT, LEFT, RIGHT, MID and CONCATENATE.
-
Array formulas for efficient calculations.
Data Analysis with PivotTables
-
Create and customise PivotTables to summarise large datasets.
-
Filters, slicers and calculated fields; Power Pivot for data modelling.
Data Cleaning & Consolidation
-
Remove duplicates, format cells and handle errors.
-
Merge and split cells, columns and rows; consolidate data across sheets and workbooks.
Automation with Macros and VBA
-
Record and run macros for repetitive tasks.
-
Use VBA to automate data entry, formatting and reporting.
Visualisation, Import & Collaboration
-
Professional charts, sparklines and conditional formatting.
-
Import from databases, text files and the web; Power Query for transforming data.
-
Protect sensitive data and collaborate using cloud tools, comments and version control.