ReCh Management Centre - Building Financial Models with Excel - Building Financial Models with Excel - View courses templates

Search Courses

Tel: +44 207 148 7680
Email: enquiries@rechmc.com

Building Financial Models with Excel

Print Page


Start DateVenue1 Week2 Weeks

Request a dateLondon 2,600 3,600

To arrange an alternative date for this course, please select the following:

Course Overview

When looking at any financial opportunity the ability to perform accurate and realistic analysis is imperative. In today's ever-changing business environment the capability to write simple spreadsheets is not enough. You have to be able to incorporate all the "what if" scenarios and stress any proposal to its limits. A well-structured financial model can facilitate and improve the reliability and quality of your decision-making.

 Course Objectives

At the end of the course delegates will be able to:

Understand the different types of financial models and when each should be applied
Construct financial models making use of a broad range of Excel methods and techniques
Incorporate elements such as risk, sensitivity, optimisation and forecasting into financial models
Produce meaningful management reports and charts for communication

Course Outline

Opening and closing Excel files
Excel screen menu and standard toolbar
Auto fill
Moving around a worksheet
Moving around the sheets in a workbook
Creating files
Deleting files and individual sheets
Changing column width and row height
Entering simple formulas
Entering labels
Cell referencing
Centring titles and merging cells
Simple cell formatting
Number formats
Changing font sizes and colours
Copy, cut and pasting cell contents
Inserting graphic objects
Custom views
Previewing worksheets
Printing documents and ranges

E-Reader Not Included

*Course fee is not inclusive of VAT

Accreditation & Downloads