Excel Functions For Real Estate Analysts
 

What you'll learn
Understand and apply core Excel functions used in real estate analysis
Use logic functions like IF and AND to build dynamic calculations
Work confidently with date functions for lease and timeline modelling
Combine functions to create robust, transparent formulas
Requirements
Basic Excel skills - you should know how to open, save, and navigate a workbook
No prior modelling experience required
Description
If you're working in real estate and want to build better spreadsheets, this course is for you.Excel Functions for Real Estate Analysts is a focused, practical course that teaches you how to use Excel's most important formulas - the ones that analysts rely on to model leases, timelines, and cashflows accurately.You won't learn every Excel function. Just the ones that matter.We'll cover:Core logic functions like IF, AND, and ORDate and time functions for lease start, rent review, and expiry modellingMath functions to clean up your calculationsLookup functions that help structure more dynamic modelsText functions for cleaning, splitting, and formatting messy dataAlong the way, we'll share real-world examples, formatting shortcuts, and tips for making your formulas easier to audit and debug.Whether you're preparing for an internship, building models in a client-facing role, or just want to feel more confident working in Excel, this course will help you sharpen your skills and speed up your workflow.You'll finish with a solid understanding of how Excel formulas actually work - and how to apply them to common real estate use cases.All functions are demonstrated step-by-step, using practical examples that reflect the kind of data analysts work with every day.
Overview
Section 1: Introduction
Lecture 1 Introduction & Workbook Download
Section 2: Functions
Lecture 2 Function: SUM
Lecture 3 Function: IF
Lecture 4 Function: SUMIF & SUMIFS
Lecture 5 Function: OR
Lecture 6 Function: IF OR
Lecture 7 Function: AND
Lecture 8 Function: IF AND
Lecture 9 Function: MIN
Lecture 10 Function: MAX
Lecture 11 Function: COUNT
Lecture 12 Function: ROUND
Lecture 13 Function: MATCH
Lecture 14 Function: INDEX
Lecture 15 Function: INDEX MATCH
Lecture 16 Function: OFFSET
Lecture 17 Function: OFFSET MATCH
Lecture 18 Function: SUM OFFSET
Lecture 19 Function: IFERROR
Lecture 20 Function: AVERAGE
Lecture 21 Function: AVERAGEIF
Section 3: Date Functions
Lecture 22 Function: TODAY
Lecture 23 Function: YEAR
Lecture 24 Function: MONTH
Lecture 25 Function: DAY
Lecture 26 Function: DATE
Lecture 27 Function: EOMONTH
Lecture 28 Function: EDATE
Section 4: Text Functions
Lecture 29 Function: TEXT
Lecture 30 Function: RIGHT & LEFT
Section 5: Financial Functions
Lecture 31 Function: IRR & XIRR
Lecture 32 Function: NPV & XNPV
Aspiring real estate analysts who want to build confidence in Excel,Students and graduates preparing for internships or junior analyst roles,Professionals in property who need to sharpen their Excel function knowledge,Anyone working with leases, timelines, or cashflows in real estate spreadsheets