merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

Financial Modelling in Excel

City University London
Course summary
10 weeks
560 GBP
English
Part time
Open / Scheduled
Next available date: 22/01/2020 - London
Course Dates
London
22/01/2020   (English)
560 GBP
23/01/2020   (English)
560 GBP
29/04/2020   (English)
560 GBP
30/04/2020   (English)
560 GBP
Financial Modelling in Excel

Course description

Financial Modelling in Excel

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.

Suitability - Who should attend?

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.

Training Course Content

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

Get Inspired! Watch the Video

A short course is an excellent way to gain new expertise, advance skills or simply follow a passion. With courses in business, computing, writing, creative industries, languages and law there is something for everyone. Glimpse inside our short course community: hear from our industry-expert tutors and listen to students as they reflect on their learning experience.

About provider

City University London

City University London

City, University of London is a special place. With skill and dedication, we have been using education, research and enterprise to transform the lives of our students, our community and the world for a hundred years. We are proud of...


Read more and show all courses with this provider

Contact info

City University London

Northampton Square
EC1V 0HB London

 Show phone number

Reviews

There are no reviews available yet.

U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Be Inspired - watch the videos