Loading...

Course Description

A common challenge in real estate financial modeling is creating succinct formulas that efficiently and elegantly accomplish clients’ dynamic objectives. If you were to limit yourself to only using IF statements and LOOKUP functions in your formulas, over time your models would grow cumbersome in terms of file size and usability, and would therefore fail to meet industry best practices. In order to adhere to Professor Lebret’s principles of real estate financial modeling, in this lesson you will strategically apply Boolean expressions (TRUE/FALSE), INDEX/MATCH, and OFFSET functions to optimize your models and gain the desired outcome for your audience. For the best experience, complete "Modeling Essentials and Introduction to Discounted Cash Flow: Discounted Cash Flows in Real Estate" and "Modeling Essentials and Introduction to Discounted Cash Flow: Strategically Apply IF Statements and LOOKUP Functions" prior to taking this lesson.

Benefits to the Learner

  • Perform TRUE/FALSE, INDEX/MATCH, and OFFSET functions in Excel
  • Identify when to strategically use TRUE/FALSE, INDEX/MATCH, and OFFSET functions in your model to gain the desired outcome for your audience        
Loading...
Enroll Now - Select a section to enroll in
Type
self-paced (non-instructor led)
Dates
Jun 02, 2023 to Dec 31, 2030
Total Number of Hours
1.0
Course Fee(s)
Regular Price $0.00
Required fields are indicated by .