5 Day Masterclass in Business Modelling & Presentation | Terrapinn Training
5 day Masterclass

Business Modelling


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


The aim is to provide participants with the competency to get more strategic value from their organisation’s business data.

They will leave the session with new hands-on skills to work with business and financial data, and with the most effective techniques for presenting numerate business data to their peers and business stakeholders.

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:

  • Professionals working in business development, strategy and planning
  • Financial and business analysts, managers, operations staff and information management staff
  • Executives and key staff who need to have well-developed skills in collecting, analysing and reporting on data and presenting information to their clients and stakeholders.

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


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