You are here
Home > Finance > Training Financial Modeling Using Excel & Vba – From Zero To Master

Training Financial Modeling Using Excel & Vba – From Zero To Master

Training Financial Modeling Using Excel & Vba – From Zero To Master

Training Pemodelan Finansial Menggunakan Excel Dan Vba

Training Konsep Financial Modeling

Pelatihan Financial Modeling Using Excel & Vba – From Zero To Master Di Jogja

Pembicara / Fasilitator
Tri Gunawan Bayu Aji SE, Ak MM
is a practitioner in Management Accounting, Business Planning and Budgeting with 10 years solid experience in various industries such as manufacturing, Distribution, Financial Institution, Shipping Line and Port Operator. He graduated from Accounting Department of UNPAD and obtain MM Degree from LPPM Jakarta. He has extensive experiences in giving public workshop; in-house training and lectures specialized in Financial Analysis and Financial Modeling. His team members are also practitioners from the biggest Beverages Company and Telecommunication Company, and having many experience in giving Financial Modeling Workshop.

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

Jadwal pelatihan Pemodelan Finansial menggunakan Excel dan VBA di jogja :

· 4 – 6 Maret 2019

· 1 – 4 April 2019

· 27 – 29 Mei 2019

· 19 – 21 Agustus 2019

· 24 – 26 September 2019

· 18 – 20 Desember 2019

Catatan : Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta Training Pengenalan Financial Modeling Pasti Jalan

Invetasi dan Lokasi Pelatihan Konsep Financial Modeling Di Jogja :

· Yogyakarta, Hotel 101 (6.500.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)

· Surabaya, Hotel Amaris, Ibis Style (6.000.000 IDR / participant)

· Lombok, Sentosa Resort (7.500.000 IDR / participant)

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

Fasilitas  pelatihan Pengenalan Financial Modeling di jogja :

  • FREE Airport pickup service (Gratis Antar jemput Hotel/Bandara/Stasiun/Terminal)
  • FREE Akomodasi ke tempat pelatihan bagi peserta training Konsep Financial Modeling jogja pasti running
  • Module / Handout Training Pemodelan Finansial Menggunakan Excel Dan Vba Jogja Fixed Running
  • FREE Flashdisk
  • Sertifikat Training Financial Modeling Using Excel & Vba – From Zero To Master Di Jogja Murah
  • FREE Bag or bagpackers (Tas Training)
  • Training Kit (Dokumentasi photo, Blocknote, ATK, etc)
  • 2xCoffe Break & 1 Lunch, Dinner
  • FREE Souvenir Exclusive
  • Training room full AC and Multimedia