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

Business Modelling


Learn how to design world-class models.

This intensive five-day training course is all about turning your organisation’s data into better business decisions.

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.

The course is packed with leading-edge spreadsheet design ideas and presentation ideas to bring your modelling skills to the next level.  And the hands-on exercises will reinforce your ability to design workbooks and data presentation methods that boost your organisation’s productivity.

In just 5 days you will:

  • Efficiently collect, manage and analyse business data (financial and operational)
  • Competently develop flexible business and financial models to identify and understand change drivers
  • Confidently forecast business futures based on available data
  • Effectively communicate information to colleagues, clients and external stakeholders.

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
  • The concepts behind modelling and opportunities offered by using Excel
  • A framework for building and using models within an organisation, and the characteristics of effective financial and business models
  • Developing and managing spreadsheets using Excel
  • 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
  • Static models
  • Dynamic models using simulation
  • Single variable model evaluation – Goal Seek
  • Multi variable model evaluation – Solver
  • Typical Solver application areas
  • Solver applications
  • This work will be based on developing a complete business model to meet a specific problem or challenge from within a typical workplace. It involves group work on developing components of tools for:
  • Data collection
  • Calculation
  • Forecasting
  • Analysis
  • Optimisation
  • A review of course concepts, tying the work covered to concepts introduced in Day 1
  • Wrap

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