Preview of Excel for Real Estate Certification Level 1 Bootcamp | Excel for Real Estate Course
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 4+ hours, with searchable audio transcript
- Fully-unlocked Excel file with solution set
- Lifetime access
- Access to the online Certification exam, which bestows Level 1 Excel for Real Estate Certification upon passing, as well as to 35 practice questions with answer explanations to get you ready
Overview
In this 4+ 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, SUMPRODUCT
- COUNTIF, COUNTIFS
- XLOOKUP, INDEX/MATCH
- 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.
- Keyboard Shortcuts
- Spreadsheet and Formula Basics
- Cell Formatting
- Arithmetic
- Statistics
- Relative vs. Absolute References
- Insert and Delete Rows and Columns
- Dates
- SUMIF and COUNTIF
- Paste Special, Transpose
- VLOOKUP and HLOOKUP
- Conditional Statements
- Conditional Statements Solution
- Conditional Formatting
- TVM and Financial Functions
- Financial Functions Exercise
- Mortgage Payment
- Mortgage Payment Exercise
- Mortgage Payment Exercise Solution
- CUMPRINC and CUMIPMT
- Formula Auditing
- Data Source
- Data Tables
- Circular References
- Best Practices
Appendix: VLOOKUP and HLOOKUP
REFM_Level_1_Bootcamp_Excel_v34.0 (Note: this is a dead link on purpose; if you are trying to access the file to use in the course, please proceed to the actual lesson page)
Excel File Tabs
The Excel file is 100% unlocked, and you can re-purpose the tabs and comprising code as you desire.
- Keyboard Shortcuts
- Spreadsheet and Formula Basics
- Cell Formatting
- Arithmetic
- Statistics
- Relative vs. Absolute References
- Insert and Delete Rows and Columns
- Dates
- SUMIF and COUNTIF
- Paste Special, Transpose
- VLOOKUP and HLOOKUP
- Conditional Statements
- Conditional Statements Solution
- Conditional Formatting
- TVM and Financial Functions
- Financial Functions Exercise
- Mortgage Payment
- Mortgage Payment Exercise
- Mortgage Payment Exercise Solution
- CUMPRINC and CUMIPMT
- Formula Auditing
- Data Source
- Data Tables
- Circular References
- Best Practices