Excel for Real Estate Professionals
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9 students enrolled

Excel for Real Estate Professionals

Use Excel to create custom Real Estate Market Reports
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
9 students enrolled
Created by Andy Lanning
Last updated 3/2020
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Students will learn how to calculate common real estate market formulas
  • Must have Microsoft Excel 2010 or later versions; this is a Window's based course, but Mac's can still learn.

This course will teach the Real Estate Professional how to calculate common real estate formulas; how to create a pivot table analysis including Slicers for automation, and how to blend the results into a professional report layout including charts and data. This is an in-depth start-to-finish course and includes a downloadable data file so you can create the same reports along with the video lessons.

*** Course access includes project files, reference handouts, 1-on-1 instructor support, LIFETIME access and a 60 day money-back guarantee!***

Who this course is for:
  • Real Estate professionals
Course content
Expand all 19 lectures 01:23:20
+ Getting Started with Excel for Real Estate Professionals
3 lectures 09:58

It is important to download the correct data fields from your particular MLS program. This video explains which fields are used to get the final report data set up.  Sample data is provided in order to facilitate the class if you do not have access to your own data set.

Preview 03:50

A quick review of mathematical order of operations!

Preview 01:51
+ Base Level Calculations
4 lectures 18:06

Calculate Price per Square Foot, a common statistic used to compare home values in a select area.

Preview 05:18

A Distressed Home is a home that is in short sale, foreclosure, or owned by the bank. This lesson shows how to calculate what percent of an area's homes are distressed.

Calculate Percent of Distressed Homes

The Sold Price divided by Asking Price is commonly referred to as the "Discount". When this amount is calculated in a certain area, a potential home buyer/seller has an idea of the market. i.e. Buyer's Market if deep discounts are present, Seller's Market if narrow or no discounts are present.

Calculate Final Discount on Sold Price

This lesson describes and illustrates the difference between the Average home price of an area compared to the Median prices. Median is by far valued by realtors as more accurate, whereas the average home buyer/seller is more familiar with the Average calculation.

Calculate Average and Median Prices
+ Pivot Intro and Advanced Calculations
3 lectures 14:17

Students will understand a Pivot Table set up process.

Pivot Table Intro

Comparing price movement Qtr-over-Qtr or Year-over-Year is an important way to track an area's home price increases or decreases.

Calculate Qtr over Qtr Percent

Absorption is a common term used in real estate and represents the available home inventory by a number of months. This lesson demonstrates that calculation process.

Calculate Months of Inventory/Absorption
+ Report Structure
3 lectures 11:40

Students will review the theory of good report layout that helps the end-user understand the data.

Sample Report Layouts

A review of the 3 main parts of the full report structure, and the review of linking it all together.

Report Structure

In order to maintain and control the report layout and process, the Name Box is a vital element. This lesson describes how to use it to it's full potential.

Vital Tools: Name Box, Named Range, Name Manager
+ Building the Excel Reports
5 lectures 25:54

Duplicating a Pivot is ideal; especially after spending much time perfecting your pivot. But there is a drawback when adjusting the duplicated pivots. In this lesson we solve it and avoid an unexpected problem.

Duplicate Pivots - Pros & Cons - Solved

When the Pivots are finished, the next step is to embed the results into the report data table.

Link Report to the Pivots (Automation)
Reinforce Formulas in Report Layout

This lesson shows the process of creating the charts to "visualize" the data table in your reports.

Create Charts

Beginning the automation is important, so this lesson describes the full process from start to finish and shows how to set up the amazing Pivot Slicers allowing you to control the changes as needed.

Slicers for Automation
+ Save to PDF and Conclusion
1 lecture 03:25

Students will see the difference in Print vs Save to PDF, and a final Conclusion from the Instructor.

Save to PDF and Conclusion