This 2-day programme equips participants with advanced Excel skills for complex data manipulation, analysis, automation, and professional reporting using real-world datasets.
Module 1 — Calculating With Advanced Formulas
Quick Analysis Tools, mixed references, range names, text and financial functions, logical and lookup functions.
Module 2 — Auditing a Worksheet
Finding errors, Watch Window, evaluating and troubleshooting formulas.
Module 3 — Mastering Excel Tables
Creating, managing and analysing data with advanced table tools.
Module 4 — Organising Worksheet Data
Advanced sorting, filtering, subtotals and outlines.
Module 5 — Charting and Visualisation
Creating and formatting charts, and using Sparklines.
Module 6 — Working with Templates and Comments
Hyperlinks, comments and productivity templates.
Module 7 — Analysing Selected Data
Advanced filters, database functions and outlines.
Module 8 — Applying Conditional Formatting
Custom conditional formatting and colour-based sorting and filtering.
Module 9 — PivotTables and PivotCharts
Creating, customising and analysing large datasets.
Module 10 — Introduction to Macros
Creating, running and editing macros (relative and absolute).
Module 11 — Collaborating with Others
Workbook protection, tracking changes and merging.
Module 12 — Advanced Lookup and Reference Functions
VLOOKUP, MATCH, INDEX, GETPIVOTDATA and array formulas.
Module 13 — Data Validation and Import/Export
Data validation, importing and exporting data, and external connections.
Duration 2 Days
Training Mode Physical Classroom
Target Audience Data analysts, business analysts, BI developers, data scientists, statisticians, managers, team leaders, academic researchers, fresh graduates and self-employed professionals
