Advanced Excel Basic Top-Up Program

(Short-Term Skill Upgrade for Working Professionals)

Program Objective

Fast-track your Excel skills from basic to advanced level with job-oriented training in data analysis and business reporting.

What You'll Learn

???? Core Advancements

• Advanced Formulas (XLOOKUP, INDEX-MATCH, Array Formulas)

• Data Validation & Conditional Formatting Pro Techniques

• PivotTables Deep Dive (Slicers, Calculated Fields)

???? Business Analytics

• What-If Analysis (Goal Seek, Data Tables)

• Power Query for Data Cleaning

• Introduction to Dashboard Creation

⚡ Productivity Boosters

• Macro Recording Basics

• Custom Keyboard Shortcuts

• Excel + Power BI Integration Basics