Semua Kategori
Jelajahi materi pembelajaran terbaik untuk topik Semua Kategori. Disusun oleh instruktur handal dengan contoh kasus riil.
Filter
Pivot Tables & Analysis
Konsuli Team
Pivot Tables & Analysis
Pivot Table layouts, Calculated Fields, Slicer Timelines, and Pivot Charts
- Menguasai 100+ shortcuts, formula kompleks (VLOOKUP, INDEX-MATCH, XLOOKUP), visualisasi interaktif, dan otomasi spreadsheet.
Pivot Table layouts, Calculated Fields, Slicer Timelines, and Pivot Charts
Data Visualization & Charts
Konsuli Team
Data Visualization & Charts
Chart Selection, Combo Charts, Sparkline Mini cells, and Dashboard Layouts
- Menguasai 100+ shortcuts, formula kompleks (VLOOKUP, INDEX-MATCH, XLOOKUP), visualisasi interaktif, dan otomasi spreadsheet.
Chart Selection, Combo Charts, Sparkline Mini cells, and Dashboard Layouts
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
Dashboard & Reporting
Konsuli Team
Dashboard & Reporting
Dashboard Visual Hierarchy, KPI cards, Sales Finance HR dashboards, and PDF automations
- Menguasai 100+ shortcuts, formula kompleks (VLOOKUP, INDEX-MATCH, XLOOKUP), visualisasi interaktif, dan otomasi spreadsheet.
Dashboard Visual Hierarchy, KPI cards, Sales Finance HR dashboards, and PDF automations
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