OUTLINE MATERI
HARI PERTAMA
Sesi 1 (09.00 – 12.00)
- Data Table and Advanced Pivot
- Created and design worksheet with dashboard view using slicer & Timeliner
- Pengenalan VBA Macro Programming
- Recording Macro.
- Using Command Button for execute a macro
- Data Table and Advanced Pivot
- Created and design worksheet with dashboard view using slicer & Timeliner
- Pengenalan VBA Macro Programming
- Recording Macro.
- Using Command Button for execute a macro
Sesi 2 (13:30 – 13:00)
- Macro Automation for Conditional Formatting .
- Macro Automation for Data Validation.
- Conditional Formatting with formula
- Data Validation with formula
HARI KEDUA
Sesi 1 (09:00 – 12:00)
- Create VBA Code, Variable and Function.
- Pengenalan Modul dan Aplikasinya
- Desain Userform
- Using User Form to Control Worksheet
- Execute Userform from Workshet
- Statement and Syntax for Conditional (using IF and Else)
- Statement and Syntax for Looping (using For Next)
- Exercise
Sesi 2 (13:30 – 16:00)
- Power Query Introduction
- Data Transformation
- Create Data Model from multiple source
- Create Pivot from data model
- Add custom function on Data Model
