Excel & Data Analysis
Jelajahi materi pembelajaran terbaik untuk topik Excel & Data Analysis. 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
Formulas & Functions
Konsuli Team
Formulas & Functions
Excel Lookup functions (VLOOKUP INDEX-MATCH XLOOKUP), Logical IFs, and Error Handlings
- Menguasai 100+ shortcuts, formula kompleks (VLOOKUP, INDEX-MATCH, XLOOKUP), visualisasi interaktif, dan otomasi spreadsheet.
Excel Lookup functions (VLOOKUP INDEX-MATCH XLOOKUP), Logical IFs, and Error Handlings
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