Training ini dirancang untuk meningkatkan kemampuan data processing & reporting menggunakan Microsoft Excel secara efisien, otomatis, dan terstruktur.

Program bersifat full praktek dengan pendekatan studi kasus dan simulasi langsung.

• Otomatisasi pengolahan & reporting data
• Minim kesalahan input & validasi data
• Dashboard & visualisasi dinamis
• One-click automation

1. Addressing & Data Validation
   • Absolute Address & Name Manager
   • Data Validation Control
   • Relational Dependent Drop Down List
2. Data Cleaning
   • Sort, Trim, Clean, Substitute, Replace
   • Remove Duplicates & Text to Column
3. Function & Formula (Intermediate–Advanced)
   • Nested IF, IFs
   • SumIFS, CountIFS, AverageIFS
   • MIN, MAX, SMALL, LARGE, AGGREGATE
   • Date & Working Day Function
4. Advanced Lookup Combination
   • VLOOKUP, HLOOKUP, XLOOKUP
   • INDEX & MATCH
5. Advanced Pivot Table & Chart
6. Macro Automation Processing & Reporting
7. Studi Kasus Peserta

• Rp 3.500.000 – Grup min. 2 peserta (H-5)
• Rp 3.750.000 – 1 peserta
• Rp 3.950.000 – Invoicing
• Diskon 10% – Desember 2025

Include: Modul · Lunch · Coffee Break · Sertifikat · Souvenir