The Definitive Guide to Microsoft Excel for Real Estate by A.CRE (Updated for 2022)

For students and professionals just starting with real estate financial modeling in Excel, this is the most comprehensive guide to Excel for Real Estate available. This guide was developed by the team at AdventuresinCRE.com, and is a pre-cursor to their real estate financial modeling Accelerator training program. To download the source file used in this guide, or to find more Excel for Real Estate resources, go to: https://www.adventuresincre.com/guide...

Definitive Guide Chapters
00:00 - Introduction to the Definitive Guide to Microsoft Excel for Real Estate
00:42 - The Only Functions You'll Ever Need for Real Estate Financial Modeling
01:49 - Addition, Subtraction, Multiplication, and Division
03:34 - SUM() and AVERAGE() Functions
06:07 - TRUE and FALSE Logic
10:38 - IF() and Nested IF() Statements
15:52 - AND() and OR() Functions
22:45 - MAX() and MIN() Functions
24:43 - COUNTIF() and COUNTA() Functions
28:57 - IRR() and NPV() Functions
33:16 - EOMONTH(), EDATE(), XIRR(), and XNPV() Functions
42:15 - SUMIF() and SUMPRODUCT() Functions
46:37 - PMT() and PV() Functions
52:26 - IFERROR() and ISERROR() Functions
57:56 - ROUND() and ROUNDUP() Functions
1:03:08 - INDEX() and MATCH() Functions
1:13:34 - Concatenate Logic
1:19:05 - The Key Excel Features for Real Estate Financial Modeling
1:19:53 - Data Validation
1:25:47 - In-Cell Labels
1:29:45 - Conditional Formatting
1:33:57 - Data Tables
1:37:33 - Goal Seek
1:39:26 - Charting Tools
1:42:53 - Conclusion

Become a real estate financial modeling pro; https://www.adventuresincre.com/accel...

SUBSCRIBE: https://www.youtube.com/user/sburtonh...