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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s