Introduction to Real Estate in Excel

A Real Estate financial model is the abstract representation of an investment scenario. Building a Real Estate Financial Model requires theory, maths and excel.

Introduction to Real Estate in Excel

This one day course has been developed to teach essential Real Estate financial modelling theory, functions and formulas to individuals working in the Real Estate sector. The training aims to give delegates a grasp of MS Excel and its usage in Real Estate cash flow modelling. You will be able to set up a financial modelling cash flow from a blank spreadsheet by using the most common shortcuts, formulas and functions. We will also cover the use of pivot tables to clean and organise your data.

This is an excellent starter/refresher course, whether you’re a recent graduate or a mid/senior professional.

On this course, you will…
  • Learn spreadsheet modelling best practice
  • Look over excel tips for general day to day use in MS Excel
  • Recognise spreadsheet navigation and presentation tricks
  • Understand financial mathematics & conventional valuations
  • Identify Real Estate cash flow model single-let common functions and formulas
  • Inspect Pivot tables, V-look ups and many other topics
Who will benefit from this course?
  • Graduate Real Estate professionals
  • Real Estate professionals at any level with exposure to Real Estate financial models on a frequent basis
  • APC candidates
  • Mid-Senior professionals looking for a refresher on core model building skills and best practice
  • Any professionals looking to learn how to build a Real Estate focused model from scratch.
Included in the Course
  • A Bayfield Training Certificate
  • Virtual Copy Course Manual (A hard copy course manual can be bought for an additional fee)
  • Course Files
  • Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
  • Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee

If you would like to request a course outline for further details about the Introduction to Real Estate in Excel, please use the contact details in the blue box on the right or visit the Bayfield Training Website.

Looking for something specific?