0% Complete
0/4 Steps

Preview of Excel for Real Estate Certification Level 1 Bootcamp | Excel for Real Estate Course

Lesson
Materials

REFM’s Certification in Excel for Real Estate program has existed since 2011, and thousands of certifications have been granted. Certification holders use their REFM credentials to prove their skills and to support their career moves.

A note from instructor Bruce Kirsch, REFAI

This course includes:

  • Chaptered video totaling 3 hours
  • Fully-unlocked Excel file with solution set
  • Lifetime access, even on mobile devices
  • Access to the online Certification exam, which bestows Level 1 Excel for Real Estate Certification upon passing

Overview

In this 3-hour course, you will learn the basics of operating in Excel, as well as advanced techniques, specifically as they relate to real estate analysis. You will follow along in Excel in real time and perform exercises to ensure you are grasping the lesson and are mastering the technical skills bein

Topics Covered Include:

  • Arithmetic and Rounding
  • Statistics
  • Relative vs. Absolute Cell References
  • Inserting and Deleting Rows and Columns
  • Dates and Timelines
  • Conditional Statements
  • Function Wizard
  • Creating Summary Tables
  • Formatting Numbers
  • Conditional Cell Formatting
  • Data Table Lookup Functions
  • Custom Formatting
  • Format Painting
  • Paste Special
  • Transpose
  • Financial Functions for Compounding and Discounting
  • Internal Rate of Return (IRR)
  • Mortgage Payment Calculation
  • Formula Auditing
  • Data Tables for Sensitivity Analysis
  • Circular References
  • Keyboard Shortcuts
  • Best Practices

Excel Formulas and Functions Taught:

  • SUM
  • ROUND, ROUNDUP, ROUNDDOWN
  • MAX, MIN, AVERAGE, MEDIAN
  • Cell Anchoring using Dollar Signs
  • EOMONTH, EDATE, DATEVALUE
  • IF, AND, OR, and combinations thereof
  • SUMIF, SUMIFS
  • COUNTIF, COUNTIFS
  • VLOOKUP, HLOOKUP
  • COLUMNS, ROWS
  • IFERROR
  • RATE
  • PV, FV
  • NPV and XNPV
  • IRR and XIRR
  • PMT, PPMT, IPMT
  • CUMPRINC, CUMIPMT.

Instructions

Download the Excel from the Materials tab above. Then watch the videos, and follow along and perform the exercises in the Excel.

Video Sample

Excel File Tabs

The Excel file is 100% unlocked, and you can re-purpose the tabs and comprising code as you desire.

  1. Keyboard Shortcuts
  2. Spreadsheet and Formula Basics
  3. Cell Formatting
  4. Arithmetic
  5. Statistics
  6. Relative vs. Absolute References
  7. Insert and Delete Rows and Columns
  8. Dates
  9. SUMIF and COUNTIF
  10. Paste Special, Transpose
  11. VLOOKUP and HLOOKUP
  12. Conditional Statements
  13. Conditional Statements Solution
  14. Conditional Formatting
  15. TVM and Financial Functions
  16. Financial Functions Exercise
  17. Mortgage Payment
  18. Mortgage Payment Exercise
  19. Mortgage Payment Exercise Solution
  20. CUMPRINC and CUMIPMT
  21. Formula Auditing
  22. Data Source
  23. Data Tables
  24. Circular References
  25. Best Practices

REFM_Level_1_Bootcamp_Excel_v34.0

Excel File Tabs

The Excel file is 100% unlocked, and you can re-purpose the tabs and comprising code as you desire.

  1. Keyboard Shortcuts
  2. Spreadsheet and Formula Basics
  3. Cell Formatting
  4. Arithmetic
  5. Statistics
  6. Relative vs. Absolute References
  7. Insert and Delete Rows and Columns
  8. Dates
  9. SUMIF and COUNTIF
  10. Paste Special, Transpose
  11. VLOOKUP and HLOOKUP
  12. Conditional Statements
  13. Conditional Statements Solution
  14. Conditional Formatting
  15. TVM and Financial Functions
  16. Financial Functions Exercise
  17. Mortgage Payment
  18. Mortgage Payment Exercise
  19. Mortgage Payment Exercise Solution
  20. CUMPRINC and CUMIPMT
  21. Formula Auditing
  22. Data Source
  23. Data Tables
  24. Circular References
  25. Best Practices