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