Build your first model

Summary

This advanced course by Kubicle will teach you how to build models in Excel so as to solve difficult business problems. The course examines a fictional company, Zippy Airways, that wants to create an overbooking policy on a number of European flights. Your task in this course will be to design the optimal policy for the airline using a model build in Microsoft Excel.  C reated & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €75.00  (€75.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00
CPD hours:  
3.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This course is suitable for advanced learners who are very familiar with writing formulas and performing analysis in Microsoft Excel. It is best suited to accountants, management consultants, analysts and other business professionals

Course Overview

This Kubicle course contains 18 lessons, 4 exercises and 1 Exam. It covers the following topics:

  • Introduction to modelling
  • Framing the problem
  • Diagram the problem
  • Lay out model in Excel
  • Build simplified model
  • Sensitivity analysis
  • Prepare your dataset for modelling
  • Estimating market demand
  • Complex model formulas
  • Perform checks on model
  • Calculate model outputs
  • Analyze risks in our model
  • Goalseek & Solver
  • Run scenarios using Pivot Tables
  • Charts for sensitivity tables
  • Limitations of the model

Key Outcomes

Once you have completed this course you will know how to frame a business problem, diagram the problem, build a model in Excel and analyse the results of the model so as to make an informed decision. This ability is hugely valuable to organisations who methods for making better decisions that lead ultimately, to better financial results.