Excel For Real Estate
When : Wednesday, August 25, 2021
Time : 02 : 00 PM EST
Duration : 60 Minutes
Andy Lanning, owner, trainer, and Chief Nerd of Computer Software Training, LLC.
Andy has 25+ years of experience teaching computer software in the corporate and university environments. She teaches basic to advanced levels in most Microsoft Office programs. She is adjunct faculty at Boise State University, since 1994 to present, where she specializes in computer training for the Center for Professional Development. She also travels to teach at company conferences across the U.S.
background includes corporate training, private training, and freelance
data analysis. She has recorded several online training courses for
Udemy.com, GoSkills.com, and in her career has delivered hundreds of
courses and webinars on a variety of Microsoft topics.
This course will demonstrate how to use Excel to perform custom calculations based on the topic of housing data analysis. The attendees will learn the formula language and become comfortable with how to create any calculation.
The attendees will also observe a Pivot Table process using the same housing data and then a final presentation of that data in a publish-worthy report layout.
- Calculate available housing inventory based on 3, 6, or 12 months of data
- Calculate the buyer’s final discount on the sale price
- Calculate the % of distressed homes
- Calculate Price per Square Foot
- Calculate % of price increase Year over Year, Qtr over Qtr
- View a Pivot report process on current real estate data
- View Sample Report Layouts created in Excel
Course Level - Intermediate to Advanced
Who Should Attend
Realtors, RE Brokers, anyone in the real estate capacity.
Why Should You Attend
Do you work in the real estate industry and find yourself stumped by the volumes of data available? You might be asking what can you do with it? This webinar will solve those questions and provide some ideas along with examples using “real” housing data and calculations.
real estate industry has specific calculations that show trends in
housing markets. This course will show how to use Excel to get those