Financial Modelling in Excel

Short course

In Islington

Price on request

Description

  • Type

    Short course

  • Location

    Islington

This Financial Modelling in Excel short course is an introduction to financial modelling for those who are new to the subject.Learn the practical skills needed to construct robust financial models that can be used for business planning and evaluation. Students learn best practice design principles required for building flexible models using a range of excel techniques and functions which are applied when building a detailed financial model case study from scratch.The Financial Modelling course assumes a sound understanding of the structure and composition of financial statements, specifically income statements, balance sheets and cash flow statements. Additionally, a good working knowledge of Excel up to using Excel functions is required. This course has specific eligibility requirements listed below.Why Choose a City Short Course?The Financial Modelling in Excel short course provides the perfect introduction to anyone looking to develop their skills in constructing robust financial models. Delivered over the course of 10 weekly classes by expert tutors, participants will achieve a sound understanding of financial planning and evaluation through a variety of Excel techniques. Course Information Start DateStart TimeDurationCostCourse CodeApply Monday 3 October 2016 18:30 - 20:30 10 weekly classes £540.00 CS2564 Apply Now Wednesday 5 October 2016 18:30 - 20:30 10 weekly classes £540.00 CS2564 Apply Now Wednesday 18 January 2017 18:30 - 20:30 10 weekly classes £540.00 CS2564 Apply Now Monday 8 May 2017 18:30 - 20:30 10 weekly classes £540.00 CS2564 Apply Now ...

Facilities

Location

Start date

Islington (London)
See map
Northampton Square, EC1V 0HB

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Evaluation
  • Excel
  • Best Practice
  • Cash Flow
  • Financial Modelling
  • IT
  • Design
  • Sound
  • Financial
  • Planning
  • Financial Training
  • MS Excel
  • Skills and Training

Course programme

What will I learn?
  • Excel hints, techniques and tips in a financial context
  • Keyboard shortcuts
  • Best Practice techniques for financial modelling
  • How to establish suitable driver based models for forecasting
  • Modelling Income Statements, Balance Sheets and Statements of Cash flow
  • Sensitivity Analysis
  • Ways to minimize errors
  • Advanced modelling techniques

By the end of the Financial Modelling in Excel course, you will be able to:

Use best practice modelling principles to design and build robust financial models

Course Outline

The first four weeks of the course cover the necessary groundwork, design principles and functions required to build robust models.

In weeks 5 - 9 these design techniques are put into practice by building a detailed financial model from scratch based on a fictitious retail based case study.

The course concludes with a review of further advanced excel techniques including sensitivity analysis.

Scheme of Work Week 1 Keyboard shortcuts, styles and custom formatting Week 2 Financial modelling best practice Week 3 Modelling techniques including summing across sheets, "IF" statements, VLOOKUPs, INDEX & MATCH and conditional formatting Week 4 Drivers; key items which drive financial models Week 5 Start case study: Income Statement – annual projections Week 6 Case study continued: Income Statement – monthly projections Week 7 Case study continued: Income Statement – finalise and complete Week 8 Case study continued: Balance Sheet Week 9 Case study continued: Cash Flow Statement and complete the model plus a brief look at Macros Week 10 Advanced Techniques and course round up

Financial Modelling in Excel

Price on request