Excel Functions For Real Estate Analysts

Learn the must-know Excel functions for property professionals working with data, leases, and financial models.

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