This 2-day practical programme equips professionals with essential Excel skills from beginner to intermediate level. Learn to manage, analyse, and present data confidently with real-world hands-on exercises.
HRD Corp SBL-Khas Claimable
Excel Essentials
Interface navigation, workbook management, cell referencing, formatting, and basic formulas — SUM, AVERAGE, COUNT, MIN, MAX.
Data Management & Organisation
Excel Tables, sorting, filtering, removing duplicates, and data validation including drop-downs and input alerts.
Intermediate Formulas & Functions
Text functions, logical functions (IF, AND, OR), and lookup functions (VLOOKUP, INDEX & MATCH).
Visualisation & Charting
Creating charts, using Sparklines, and applying conditional formatting to communicate data clearly.
PivotTables & PivotCharts
Creating, grouping, filtering, and summarising data with PivotTables and interactive charts.
Formula Auditing & Error Checking
Tracing precedents and dependents, evaluating formulas, and troubleshooting common errors.
Reporting & Practical Exercises
Designing professional reports with conditional formatting and chart integration using real-world datasets.
Duration 2 Days
Training Mode Physical Classroom
Who Should Attend Professionals, data analysts, business analysts, team leaders, managers, researchers, administrative & operational staff
Certificate Certificate of Completion awarded upon full attendance
