Excel & Data Analysis
Jelajahi materi pembelajaran terbaik untuk topik Excel & Data Analysis. Disusun oleh instruktur handal dengan contoh kasus riil.
Filter
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