0% Complete
0/14 Steps

Preview of Excel for Real Estate Bootcamp | Level One Certification

Lesson
Materials

Overview

In this lesson, you will learn the basics of operating in Excel, as well as advanced techniques, specifically as they relate to real estate analysis.

Passing this lesson’s quiz bestows REFM Excel for Real Estate Level 1 Certification.

Instructions

1. Download the Excel file from the Materials tab
2. Watch Video 1 of 2, and follow along and perform the exercises in the Excel file linked below
3. Do the same for Video 2 of 2
4. Take the Sample Questions quiz first and review the quiz commentary on the correct answers
5. Take the graded quiz in a single timed sitting, noting your score and the group average score.

Keyboard Shortcuts Sheets

Tutorial Videos

Note: the bulleted topic titles below the videos are navigation links that take you directly to that topic when clicked

Video 1 of 2

  • Order of Operations
  • Evaluate Formula Function
  • Rounding
  • ROUND Function
  • ROUNDUP Function
  • ROUNDDOWN Function
  • Alt Hotkeys
  • Statistics
  • MAX Function
  • MIN Function
  • AVERAGE Function
  • MEDIAN Function
  • Relative and Absolute References
  • Relative Reference
  • Absolute Reference
  • Inserting and Deleting Rows
  • Inserting and Deleting Columns
  • Dates,Annual Timeline
  • Monthly Timeline
  • EOMONTH Function
  • EDATE Function
  • SUMIF Function
  • SUMIFS Function
  • COUNTIF Function
  • COUNTIFS Function
  • Paste Special
  • Transpose
  • VLOOKUP Function
  • COLUMNS Function
  • HLOOKUP Function
  • ROWS Function
  • Conditional Statements/IF Function
  • OR Function
  • AND Function
  • Nesting Conditional Statements
  • Nesting and Multiplying by the IF Function
  • Adding the IF Function

Video 2 of 2

  • Conditional Formatting
  • Time Value of Money/Discounted Cash Flow Model Introduction
  • PV Function
  • FV Function
  • NPV Function
  • IRR Function
  • XNPV Function
  • XIRR Function
  • Mortgage Payment Introduction
  • Mortgage Amortization Table Overview
  • Beginning Balance
  • Monthly Payment
  • Principal Portion/PPMT Function
  • Interest Payment Portion/IPMT Function
  • Ending Balance
  • CUMPRINC Function
  • CUMIPMT Function
  • Formula Auditing
  • Trace Dependents
  • Trace Precedents
  • Remove Arrows
  • Data Tables
  • Circular References
  • Best Practices.

REFM_Excel_for_Real_Estate_Level_1_Bootcamp_v_34_0