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
