Learn from REFM (Real Estate Financial Modeling), the trainer to executives at Prudential, Vornado, The JBG Companies and more! A 3 to 4 hour self-study session guided by a 56-minute video tutorial, specific to real estate analysis. Used by top real estate students and professionals since 2009 to get up to speed and stay sharp. Unlocked Excel file with solutions included. Over 20 hands-on exercises throughout to make sure you are learning what is being taught, and an additional 7 Quiz questions. Ability to apply what you learn towards REFM's Certification In Excel For Real Estate (this tutorial is the preparatory material for the FREE Level 1 Certification Test).
Steps to Certification: 1. Do this self-study course, including the Quiz questions within it 2. Create an account at the REFM testing center to take the REFM Level 1 Certification Exam for Excel in Real Estate. This exam is available online 24/7/365, and is free! 3. Pass your exam, and instantly receive a Certificate via email. REFM will contact you to provide you with your email signature Certification Badge and will request your permission to include you on the Certification Holders page, where employers can verify your achievement.
Topics Covered (All topics include Exercises): - 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 - IFERROR - RATE - PV, FV - NPV and XNPV - IRR and XIRR - PMT, PPMT, IPMT