4 MUST-KNOW Excel Functions and Features For Real Estate Analysts
Break Into CRE Break Into CRE
83.6K subscribers
25,506 views
0

 Published On Sep 15, 2022

4 MUST-KNOW Excel Functions and Features For Real Estate Analysts // If you’re trying to break into commercial real estate, you need to know Excel (and know it well).

But someone just telling you that you need to “know Excel” isn't necessarily helpful, since there are over 500 functions that Excel has to offer, many of which are honestly just not that applicable in real estate financial modeling.

So to help you cut through the noise and focus on the most useful functions that you WILL need to know if you’re targeting real estate analyst roles (or just trying to more efficiently analyze your own deals in Excel), in this video, let’s walk through four of the most commonly used Excel functions, function categories, and general features in the software for real estate investors specifically, and how each of these tend to be used within a real estate investment analysis.

💻 TRAINING & COURSES 💻
Enroll in the FREE Break Into CRE Real Estate Financial Modeling Crash Course here: https://www.breakintocre.com/free-cra...
Enroll in any Break Into CRE course here: https://breakintocre.com/courses/
Get access to all Break Into CRE courses, all models, and additional one-on-one support with a Break Into CRE Academy membership: https://breakintocre.com/the-academy

**💰 MY FAVORITE REAL ESTATE INVESTMENT PLATFORM 💰
Invest directly with top CRE sponsors on Crowdstreet: https://crowdstreet.4cl7.net/c/297573...

🕒 Timestamps 🕒
0:00 Introduction
0:48 The MAIN Focus of a Model
3:51 The Most VERSATILE Function Group
5:52 Debt Metric Calculation Shortcuts
7:33 Lock (and Unlock) References
9:03 How To Master Excel For Real Estate

#excel #realestateanalyst

*Nothing in this video should be construed as tax, legal, accounting, valuation, or financial advice or recommendation. All information in this video is intended solely for educational purposes, and you are advised to consult with your own personal professional advisors regarding your personal investment decisions.

**AFFILIATE DISCLOSURE: Some of the links in this description are affiliate links, meaning, at no additional cost to you, we may earn a commission if you click through and make a purchase and/or create an account.

show more

Share/Embed