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-microsoft-excel-for-real-estate/ 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/accelerator/ SUBSCRIBE: https://www.youtube.com/user/sburtonhome?sub_confirmation=1