Financial Modelling in Excel  Short Courses

Course Information

Start DateStart TimeDurationCostCourse CodeApply
Monday 2 October 2017 18:30 - 20:30 10 weekly classes £560.00 CS2564 Course Full
Wednesday 4 October 2017 18:30 - 20:30 10 weekly classes £560.00 CS2564 Course Full
Wednesday 17 January 2018 18:30 - 20:30 10 weekly classes £560.00 CS2564 Course Full
Tuesday 1 May 2018 18:30 - 20:30 10 classes twice a week,
on Tuesday and Thursday evenings
£560.00 CS2564 Apply Now

Course Content

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 the Financial Modelling in Excel 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.

Tutor Info

Tony Pamphilon has many years' experience of teaching and managing in colleges and universities, in the UK and overseas.

His particular interest is in developing and delivering computer-based accounting courses. He has managed large departments and taught both undergraduate and postgraduate programmes.

He currently works as a freelance lecturer and consultant and teaches a wide range of accounting subjects at City, University of London, London Metropolitan University and Birkbeck, University of London.

Eligibility

This evening course assumes a sound understanding of the structure and composition of financial statements, specifically the Income Statement, Balance Sheet and Cash Flow Statements.

In addition, a good working knowledge of Excel up to using Excel functions is required. At commencement of the course students are expected to be able to:

  • Create and move between worksheets
  • Improve and modify general layout using different fonts and colours
  • Delete, clear, copy and paste cells
  • Build formulas with and without Autosum
  • Understand the difference between relative, absolute and mixed cell references
  • Build IF statements
  • Construct graphs

Please note that the software and operating system used is Excel for Windows and is not suitable for Excel for Mac.

English Requirements

Applicants must be proficient in spoken and written English.

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

A major objective of the course is to be able to build flexible and robust financial models based upon best practice design principles.

The first four weeks of the course cover the necessary groundwork, design principles and functions required to acheive this.

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.

It should be noted that the purpose of the course isn’t to cover a wide range of functions but to use the functions covered efficiently to build robust and professionally presented financial models.

Scheme of Work

Week 1Presentational styles, custom formatting and the use of use shortcut keys.

In the first 4 weeks of the course these principles are covered along with a thorough knowledge of how to use the required excel functions.
Week 2

Financial modelling best practice.

How to build formulas and the use of relative, absolute and mixed cell referencing. This needs to be fully embedded to enable the building of models to a professional standard. VLOOKUPs are also covered.

Week 3Modelling techniques including summing across sheets, "IF" and nested "IF" statements, VLOOKUPs, INDEX & MATCH, custom validation, and conditional formatting
Week 4Applying the techniques learned so far in a variety of modelling situations.
Key items which drive financial models.
Week 5Start case study: Income Statement – annual projections

In weeks 5 to 9 students construct a more detailed financial model based upon a fictitious case study building projected income statements, balance sheets and statements of cash flow on an annual and monthly basis.
Week 6Case study continued: Income Statement – monthly projections
Week 7Case study continued: Income Statement – finalise and complete
Week 8Case study continued: Balance Sheet
Week 9Case study continued: Cash Flow Statement and complete the model plus a brief look at Macros
Week 10Advanced Techniques and course round up

Recommended Reading

Currently there are no books available that cover the entire syllabus  or could be categorized as ‘strongly recommended’. However, the following may provide useful background reading:

*The Economist Guide to Business Modelling (John Tennent & Graham Friend)
*Practical Financial Modelling (Jonathan Swan)
*Accounting and Finance for Non-Specialists (Peter Atrill & Eddie McLaney)

Application Deadline: