Microsoft Excel for Real Estate

Spencer Burton wrote an article for A.CRE (Adventures in Commercial Real Estate) titled The Definitive Guide to Microsoft Excel for Real Estate.

Part I – The Only Excel Functions You’ll Ever Need to Analyze Real Estate

i. ADDITION, SUBTRACTION, MULTIPLICATION, AND DIVISION LOGIC
ii. SUM() AND AVERAGE() FUNCTIONS
iii. TRUE AND FALSE LOGIC
iv. IF() FUNCTION
v. AND() & OR() FUNCTIONS
vi. MAX() and MIN() FUNCTIONS
vii. COUNTIF() and COUNTA() FUNCTIONS
viii. IRR() and NPV() FUNCTIONS
ix. EOMONTH(), EDATE(), XIRR(), AND XNPV() FUNCTIONS
x. SUMIF() and SUMPRODUCT() FUNCTIONS
xi. PMT() and PV() FUNCTIONS
xii. IFERROR() and ISERROR() FUNCTIONS
xiii. ROUND() and ROUNDUP() FUNCTIONS
xiv. INDEX() and MATCH() FUNCTIONS
xv. CONCATENATE LOGIC

Part II – Excel Features to Master for Real Estate Financial Modeling

1. DATA VALIDATION
2. IN-CELL LABELS
3. CONDITIONAL FORMATTING
4. DATA TABLES
5. GOAL SEEK
6. CHARTING TOOLS