Courses
  1. Undergraduate
  2. Postgraduate
  3. Research Degrees
  4. CPD
  5. Short Courses
Courses

Financial Modelling in Excel Short Courses

Choose a start date

Key information

Duration:
TBC
Time:
TBC
Fees:
TBC
Course code:
TBC

This Financial Modelling in Excel course covers all the important aspects of financial modelling, essential in the workplace or for those starting their own business.

Why choose this course?

This Financial Modelling in Excel short course is an introduction to financial modelling for those who are new to the subject.

You will learn the practical skills needed to construct robust financial models that can be used for business planning and evaluation.

You will understand 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.

Delivered by expert tutors, you will achieve a sound understanding of financial planning and evaluation through a variety of Excel techniques.

Course overview

Learn the practical skills needed to construct robust financial models that can be used for business planning and evaluation. You will 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.

This is a beginner’s course in financial modelling for those who are new to the subject. This 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 short course you 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.
  • Arjun Bains

    “ Very enjoyable course and the tutor was very enthusiastic with his delivery of the course, and happy to answer questions and provide help as expected. Very interesting and helpful course. ”

    Anon

    Former student

  • “ Even if you use MS Excel on a daily basis this course is an eye opener on additional features that will add value to your work. ”

    Frank Odozi

    Former student

  • “ Even if you use MS Excel on a daily basis this course is an eye opener on additional features that will add value to your work. ”

    Frank Odozi

    Former student

What will I learn?

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

It should be noted that the purpose of the short 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.

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 Financial Modelling in Excel short 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 short 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: 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

Eligibility

Eligibility

Prerequisite knowledge

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 you 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.

Teaching & assessment

Teaching & assessment

Informal assessment will take place through group discussion, class room activities and questions and answers session as guided by the tutor.

Recommended reading

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)

Tutor information

  • Tony Pamphilon

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

    Tony has managed large departments and taught learners of all abilities from beginners up to undergraduates and postgraduates.

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

Next steps

This Accounts for the Small Business Owner Short Evening Course gives you a practical focus on understanding financial management and accounting requirements for small businesses.…