Semua Kategori
Jelajahi materi pembelajaran terbaik untuk topik Semua Kategori. Disusun oleh instruktur handal dengan contoh kasus riil.
Filter
Excel Fundamentals & Shortcuts
Konsuli Team
Excel Fundamentals & Shortcuts
Excel Shortcuts, Cell Formattings, Conditional Formattings, and Print setups
- Menguasai 100+ shortcuts, formula kompleks (VLOOKUP, INDEX-MATCH, XLOOKUP), visualisasi interaktif, dan otomasi spreadsheet.
Excel Shortcuts, Cell Formattings, Conditional Formattings, and Print setups
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
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