TRAINING FINANCIAL MODELING USING EXCEL & VBA – FROM ZERO TO MASTER

Training Pemodelan Finansial Menggunakan Excel Dan Vba

Training Konsep Financial Modeling

Workshop outline:

Day One
Principle of Financial Modeling
* Basic Design
* Objective of Financial Modeling
* User Interface
* Key Variables and Rules
* Layout of good financial modeling
* Management Reporting
* Testing
* Protection and Documentation

Excel Fundamental
* Learn how to use function If
* offset, match and index
* Linking data
* Formatting
* Data Validation
* Built simple macro using recording
* Using range names

Capital Budgeting
* Basic Understanding
* Tools ( ROI, Payback period, Net Present Value and IRR)

Performance Management
* Financial Ratio understanding
* Profitability Ratio
* Liquidity Ratio
* Operating Ratio
* Modeling

Advance Financial Modeling
* Formatting and Layout
* Build intuitive model: Font, Formatting, Color and Input
* Advanced Menu: Combo Box, Scroll Bar, List Box and other Menu
* Building summary and documentation in your model
* Using Comment and Data Validation
* Build Graph, creating interactive graph

Day two
Advanced Financial Modeling…continue
* Build Dynamic Chart using advanced menu, and use menu as inputs
* Put Sensitivity on your financial modeling
* Build Sensitivity Chart
* Build Scenario using Advanced Menu and VBA to automatically query
* Build Goalseek using Advanced Menu and VBA to automatically target
* Build Interactive Chart
* Using Solver

Workshop Simulation and Group Discussion, Building inancial modeling
* You will learn how to add combo box, list box and other menu
* You will build a simple menu
* You will add input/ output to your model by using menu, validation and comment •You will learn how to use macro and vba to automatically input or result
* You will build sensitivity, scenario and Simulation into your model

Tips and Tricks in building a good and interactive financial modeling
* Using Pivot Table
* Advanced Data Validation
* Using YTD function
* Building Advanced Interactive Chart
* Using sumproduct, sumif and building mega formula into your financial modeling
* Use advanced features to link into your model to a database (local or web database)
* Build Waterfall Chart
* Forecasting
* Linear regression, Moving Average and seasonality
* Building Function using Visual Basic Application for Excel
* Monte Carlo analysis
* Reporting and Dashboard
* And other advanced tip and trick

Financial Modeling Sample
* Budgeting
* Financial Analysis and Dashboard
* Investment Analysis
* Business Valuation

Wajib diikuti oleh

* Analyst and Finance Manager
* Strategic Planner and General Managers
* Project Financiers and Lenders
* Budget Analyst and Financial Planners
* Engineer and System Managers
* Risk Manager
* Corporate Finance and M&A Professionals

Metode :

Kelas interaktif (ceramah dan studi kasus), metode penyelenggaraan dapat dilakukan melalui training online, training zoom ataupun training tatap muka

Jadwal Informasi Training Tahun 2024 :

16 -17 Januari 2024
13 – 14 Februari 2024
5 – 6 Maret 2024
24 – 25 April 2024
21 – 22 Mei 2024
11 – 12 Juni 2024
16 – 17 Juli 2024
20 – 21 Agustus 2024
17 – 18 September 2024
8 – 9 Oktober 2024
12 – 13 November 2024
17 – 18 Desember 2024

Jadwal training diatas dapat berubah sewaktu-waktu. Untuk memastikan jadwal pelatihan fix running di tahun ini silahkan konfirmasi jadwal dan lokasinya melalui whatsapp marketing kami

LOKASI DAN INVESTASI

Lokasi Pelatihan Info Training Indonesia:

• Yogyakarta, Hotel Dafam Fortuna Grande Malioboro (6.000.000 IDR / participant)
• Jakarta, Hotel Amaris Kemang (6.500.000 IDR / participant)
• Bandung, Hotel Neo Dipatiukur(6.500.000 IDR / participant)
• Bali, Hotel Ibis Kuta (7.500.000 IDR / participant)
• Lombok, Hotel Jayakarta (7.500.000 IDR / participant)

LOKASI DAN INVESTASI

Investasi Pelatihan tahun 2024 ini :

Investasi pelatihan selama tiga hari tersebut menyesuaikan dengan jumlah peserta (on call). *Please feel free to contact us.

Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan.

Fasilitas Pelatihan :

• Airport pickup service (Gratis Antar jemput Hotel/Bandara Khusus Bali dan Bandung)
• Akomodasi Peserta ke tempat pelatihan .
• Module / Handout Softcopy ataupun Hardcopy
• Flashdisk atau Link Download Material
• Sertifikat dan dokumentasi
• Bag or bagpackers (Tas Training)
• Training Kit (Blocknote, ATK, etc)
• 2x Coffee Break & 1 Lunch, Dinner
• Souvenir Exclusive

Jadwal Pelatihan masih dapat berubah, mohon untuk tidak booking transportasi dan akomodasi sebelum mendapat konfirmasi dari Marketing kami. Segala kerugian yang disebabkan oleh miskomunikasi jadwal tidak mendapatkan kompensasi apapun dari kami.