Description
This Course Is For You If You Want To
This is a good fit if you want to:
- Learn how to harness the power of Excel for real estate analysis
- Pass an exam to add a known and valued skills Certification to your resume and LinkedIn profile
- Set yourself up for success and make your skill set competitive as a student or employee
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.
Applicable Analysis Types
- Stabilized and Value-add Acquisitions
- Ground-up Development
- All Property Types
Details
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 being taught.
- 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
- 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
This is a hands-on-the-keyboard course. You will watch the video and pause it to complete exercises in the associated Excel; you will repeat this process.
Our approach to help you learn is to isolate individual techniques and tie them to real world applications. Examples are given and then exercises are given for you to complete. Solutions are in the Excel, and are reviewed on the video.
Rest assured that you will work very hard in this course programming dozens of formulas, and you will learn a lot about the real estate business in the process.
The video running time is 3 hours. Watching all the video (replaying parts where desired) and completing the exercises will take approximately 4 to 6 hours, depending on the individual.
The sample questions and 35-question Certification exam will take approximately an additional 2 hours to complete.
Through the direct experience of REFM’s principals in commercial real estate transactions, and REFM’s ongoing consulting to industry practitioners across the U.S. for the last decade, we have developed and have continually refined “The REFM Way” of teaching financial modeling.
To enhance your learning and help you to efficiently build a practical skill set, we:
- Always set the stage by providing the big picture first, and keep it at the fore with graphs and sparklines
- Speak in plain language and define industry terms on an ongoing basis
- Give you highly granular video chapter hyperlinks so you can find what you want quickly and easily.
This course will prepare you to pass the associated 35-question Certification exam, which is available online 24/7/365, and is open book. The exam has questions similar to these sample questions.
Passing the exam requires a score of 70% or better, and passing With Distinction requires a score of 85% or better. You can retake the exam if you are unsatisfied with your score.
Upon passing, you will be listed automatically on the Certification Holders page.
You are allowed one re-take of the test if you wish to take it again.
Upon successful completion of this course, you will:
- Have built confidence in your ability to apply the most commonly-used set of formulas, functions and techniques for CRE Excel-based modeling
- Be able to understand how outputs are generated on any spreadsheet you come across
- Be ready to build upon the technical foundations you have put in place
What You Get
- Lifetime online access to:
- An easily-navigated 3-hour video tutorial, with captions available and playback controls up to 2x speed. Videos are playable on any device including PC, Mac, phones and tablets.
- Accompanying fully-unlocked, annotated Excel file, compatible with Excel on both PC and Mac, which you can re-purpose for future analyses.
- Access to the Certification exam, as well as to 35 practice questions with answer explanations to help you prepare.
- Ability to upgrade to the Level 1, 2, 3 Certification Bundle by just paying the difference in price.
Meet Your Instructor
Since 2009, top companies and educational institutions have trusted REFM to train thousands of their employees and students.
New to REFM training?
Clients Include
Clients Include
Amherst
ASB Capital Management
Barings
BentallGreenOak
BrightSpire
Brixmor
Brookfield
CapitalOne
CBRE Global Investors
CCRE
Centennial Bank
Citibank
ColonyNorthstar
Conrex
CPPIB
CRC Companies
CreditSuisse
Crescent Communities
Crow Holdings
DDG
DLA Piper
Greystar
GTIS Partners
Hodes Weill & Associates
Houlihan Lokey
Howard Hughes
Jamestown
JBG Smith
JPMorganChase
Kennedy Wilson
Link Logistics
LivCor
Lubert-Adler
Macys
Oxford Properties
Park Hill
Peterson Companies
PGIM
PN Hoffman
Prometheus
QuadReal
Related
Revantage
SEO
Skanska USA
Square Mile Capital
USAA Real Estate
Asset Living
CBRE Global Investors
Clark Enterprises
Comstock Homes
Conor Commercial
Crescent Communities
Federal City Property
Flournoy
Four Seasons
Grosvenor
GTIS Partners
Hines
Hoffman
Howard Hughes
HPET
Hunt Companies
Insight Property Group
Kettler
LaSalle Investment
MadisonMarquette
Markwood
Mesa Capital
Midway
Miller Valentine
Panoramic Interests
PEG Development
Renaissance Downtowns
Rockefeller Group
Skanska USA
Snavely Group
Trammell Crow Residential
Trion Properties
Vornado
Excel File Tabs
- 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
