5 Day Masterclass in Financial and Business Modelling | Terrapinn Training
5 day Masterclass

Financial Modelling

BOOST EFFICIENCY & ACCURACY BEST PRACTICES REAL WORLD CASE STUDIES

Learn how to design world-class models.

A hands-on programme specifically designed to strengthen your model structuring skills. Learn how to adopt a structured design strategy to develop better models, in less time and with greater accuracy.

Learn bulb

develop new skills

Develop your skills in the design, structure and validation of financial models

Learn bulb

get practical

Learn fast, accurate methods for data analysis, forecasting and presentation

Learn bulb

share the knowledge

Take away a comprehensive set of course materials, models and templates for immediate use in your own workplace

STRENGTHEN YOUR FINANCIAL MODELLING SKILLS.

This intensive five-day training course is packed with cutting-edge spreadsheet design ideas and simulation exercises to bring your modelling skills to the next level.

By the end of this course, you will be able to design sophisticated workbooks that will help boost your organisation’s productivity. 



In just 5 days you will:

  • The most effective way to design a spreadsheet
  • New optimisation tools for solving complex business problems
  • How to audit & debug your spreadsheet
  • Goal-seeking, linear programming and decision analysis functions
  • How to use presentation features to improve reports and graphs
  • How models can be used in the strategic planning process
  • How to formulate and develop a model for financial planning
  • To build the different models available for handling risk and uncertainty

Organisations that will benefit:

  • All Forward Thinking Companies
  • Big Corporations
  • Banks
  • Financial Services
  • Financial Consultants
  • Private Equity & Hedge Funds
  • Energy Companies
  • Telecom, Media & Technology Companies
  • Retail Companies
  • Holding Companies

Who will attend:

  • C-Level Executives: CFO, COO
  • Financial Managers
  • Financial Analyst
  • Fund Managers
  • Project Managers
  • Business Heads
  • Portfolio Managers
  • Accountants
  • Business, Equity & Credit Analysts
  • Corporate Finance

Course Agenda

  • Big Picture
  • Speed Networking
  • What is financial modelling?
  • Developing and managing spreadsheets using Excel 2007/2010/2013
  • Importing and exporting data
  • ActiveX spreadsheet tools
  • Function for managing data
  • Automating spreadsheet operations
  • Effective charting
  • Dynamic charts
  • Handling large data sets
  • Grouping and cross tabulating data
  • Generating scenarios with data table
  • Trend analysis and forecasting
  • Forecasting with regression
  • Static models
  • Dynamic models using simulation
  • Single variable model evaluation – Goal Seek
  • Multi variable model evaluation – Solver
  • Solver applications
  • This work will be based on developing a complete business model to meet a specific problem or challenge from within the client’s workplace.
  • Calculation tool
  • Forecasting system
  • Analysis tool
  • Optimisation method
  • Dashboard to collect and display business results
  • Summing it up
  • A review of course concepts, tying the work covered to concepts introduced in Day 1.
  • Wrap Up

For further information please call: +44 (0)207 092 1045

  • “The trainer was amazing – he made the training fun and easy to follow”

    - Investment Officer, Ministry of Finance Brune

  • “An excellent course that demonstrates the power of Excel and macros to build powerful models”

    - Management Accountant, ActewAGL

  • “The course content is very useful in my working environment and, most importantly, the trainer is very knowledgeable, well prepared and cooperative.”

    - Senior Internal Auditor, Tanzania Petroleum Development Corporation

IN-HOUSE

We can come to you too! If you have a team of six or more, why not hold a private course? Our experts come to you and the course is tailored to your requirements.

Call +44 (0)20 7092 1045 (United Kingdom)
or +65 6322 2333 (Asia Pacific)
for more details

FIND OUT MORE