Semua Kategori
Jelajahi materi pembelajaran terbaik untuk topik Semua Kategori. Disusun oleh instruktur handal dengan contoh kasus riil.
Filter
Power Query & Data Transformation
Konsuli Team
Power Query & Data Transformation
Power Query Imports, Unpivot Transformations, Append Merge Queries, and M Language
- Menguasai 100+ shortcuts, formula kompleks (VLOOKUP, INDEX-MATCH, XLOOKUP), visualisasi interaktif, dan otomasi spreadsheet.
Power Query Imports, Unpivot Transformations, Append Merge Queries, and M Language
Power Pivot & DAX
Konsuli Team
Power Pivot & DAX
Data Models Relationships, DAX Basics, CALCULATE Filters, and Time Intelligence DAX
- Menguasai 100+ shortcuts, formula kompleks (VLOOKUP, INDEX-MATCH, XLOOKUP), visualisasi interaktif, dan otomasi spreadsheet.
Data Models Relationships, DAX Basics, CALCULATE Filters, and Time Intelligence DAX
Financial Modeling
Konsuli Team
Financial Modeling
3-Statement Models, Revenue Build-Up cost structures, DCF valuations WACC, and Sensitivity analysis
- Menguasai 100+ shortcuts, formula kompleks (VLOOKUP, INDEX-MATCH, XLOOKUP), visualisasi interaktif, dan otomasi spreadsheet.
3-Statement Models, Revenue Build-Up cost structures, DCF valuations WACC, and Sensitivity analysis
SQL for Excel Users
Konsuli Team
SQL for Excel Users
SQL SELECT FROM WHERE basics, JOIN Tables, Subquery CTE, and Query Optimization
- Menguasai 100+ shortcuts, formula kompleks (VLOOKUP, INDEX-MATCH, XLOOKUP), visualisasi interaktif, dan otomasi spreadsheet.
SQL SELECT FROM WHERE basics, JOIN Tables, Subquery CTE, and Query Optimization
VBA & Automation
Konsuli Team
VBA & Automation
VBA Macros record, VBA loops variables, UserForms inputs, and Event handlers
- Menguasai 100+ shortcuts, formula kompleks (VLOOKUP, INDEX-MATCH, XLOOKUP), visualisasi interaktif, dan otomasi spreadsheet.
VBA Macros record, VBA loops variables, UserForms inputs, and Event handlers