Advanced Financial Analysis and Modeling using Excel

Date/Time: Date(s) - 17/06/2019 - 21/06/2019( 8:00 am - 1:00 pm )
Location: Indonesia, Jakarta

Advanced Financial Analysis and Modeling using Excel


This training will help you build more powerful and more accurate financial models to better analyze financial data, predict revenues and costs, assess risks and be better equipped to justify critical business decisions made during uncertain economic times.

Benefits of Attending

  • Understand modeling “best practices”
  • Choose Various options within Excel© that allow you to build robust models
  • Use the templates provided to build out sophisticated, practical & usable analysis tools
  • Explore the total capability of Excel© as a modeling tool
  • Understand how to apply some of the more advanced features in Excel®, like Data Tables
  • Develop optimal results using Solver
  • Build an effective business case, using Excel©, to support decisions
  • Compare investments of different useful lives the Right way

Who Should Attend

  • CFOs, Treasurers, Controllers and accounting staff
  • Financial Directors, Managers, Analysts and their staff
  • Mergers & Acquisitions Specialists; Valuation Analysts
  • Financial and Corporate Planners; Strategic Planning Managers
  • Budget Directors, Managers and Analysts
  • Operations Analysts and Business Development Directors

Training Plan

  • 35% Lectures & Theories
  • 40% Workshops, Assessments, Group Work & Exercises
  • 20% Role Play & Case Studies
  • 05% Videos
  • Pre-Test and Post Test
  • Test Results Sheet
  • Trainee Performance Analysis Reports

Training Methodology

  • Case Studies
  • Group Discussions
  • Group & Individual exercise
  • Intensive Workshop by using templates, Diagrams & Charts
  • Planning Activities
  • Presentations
  • Self Assessments
  • Assignments
  • Combine case studies, and analysis of real world examples
  • Action plan



Contact you to discuss about this training
Send you the invitation letter
Contact you to customize this training time
Contact you to customize a new training