Semua Kategori
Jelajahi materi pembelajaran terbaik untuk topik Semua Kategori. Disusun oleh instruktur handal dengan contoh kasus riil.
Filter
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
Fundamental Analysis — Laporan Keuangan
Konsuli Team
Fundamental Analysis — Laporan Keuangan
Financial Statement analysis, EBITDA calculations, Valuation models, and IDX Financial Screener
- Menguasai teknik analisis fundamental, teknikal, bandarmologi, dan on-chain data.
- Mampu membuat strategi trading swing/day-trading yang profitabel dan aman.
Financial Statement analysis, EBITDA calculations, Valuation models, and IDX Financial Screener
Fundamental Analysis — Sektor & Industri
Konsuli Team
Fundamental Analysis — Sektor & Industri
BEI sectors mapping, Banking Ratios NIM NPL, Mining Metrics, and Peer Comparison Benchmarks
- Menguasai teknik analisis fundamental, teknikal, bandarmologi, dan on-chain data.
- Mampu membuat strategi trading swing/day-trading yang profitabel dan aman.
BEI sectors mapping, Banking Ratios NIM NPL, Mining Metrics, and Peer Comparison Benchmarks
Technical Analysis — Candlestick & Pattern
Konsuli Team
Technical Analysis — Candlestick & Pattern
BEI Candlestick Patterns, Head & Shoulders, Fibonacci Support Resistance, and Volume Confirmations
- Menguasai teknik analisis fundamental, teknikal, bandarmologi, dan on-chain data.
- Mampu membuat strategi trading swing/day-trading yang profitabel dan aman.
BEI Candlestick Patterns, Head & Shoulders, Fibonacci Support Resistance, and Volume Confirmations
Technical Analysis — Indikator & Oscillator
Konsuli Team
Technical Analysis — Indikator & Oscillator
Moving Averages Golden Cross, RSI MACD Divergences, Bollinger Bands Squeeze, and Indicator Setups
- Menguasai teknik analisis fundamental, teknikal, bandarmologi, dan on-chain data.
- Mampu membuat strategi trading swing/day-trading yang profitabel dan aman.
Moving Averages Golden Cross, RSI MACD Divergences, Bollinger Bands Squeeze, and Indicator Setups