The use of Microsoft Excel is widespread in the appraisal industry. In a recent survey, Excel was among the top four software tools on which appraisers said they’d like additional training. Are you looking for new and better ways to leverage Excel tools in your appraisal business? Here are six Microsoft Excel training resources for real estate appraisers—exclusively available to McKissock Unlimited Learning Members.
Already a member? Find the following resources under the “Learning Library” tab in your McKissock Dashboard.
1. Webinar recording: Using Excel for Residential Market Analysis
- Use the features of the Excel software to manage a large amount of data
- Refine data into a format for analysis
- Identify market conditions and trends
- Analyze the effect on the subject property
- Narrow down General Market Data to Specific Data
- Find the universe of potentially comparable offerings and sales
2. Webinar recording: Using Excel for Pairing Data to Extract GLA Adjustments
One of the most common appraisal problems is determining the contributory value for the differences in gross living area (GLA). While appraisers can find and export large amounts of data from the local MLS, they need a way to efficiently manage and analyze this data to determine a credible GLA adjustment factor that is both supported and defensible.
In the recorded webinar, “Using Excel for Pairing Data to Extract GLA Adjustments,” presenters Rob Frazier and Cathy Horwitz walk you through the process of extracting market derived adjustments for the differences in GLA using basic and advanced Excel tools to arrive at a supported and defensible adjustment factor.
3. Webinar recording: Useful Microsoft Excel Tips for Appraisers
Appraisers often import data into Microsoft Excel from the MLS and other sources. Are you harnessing the power of Excel in your appraisal business? In this Microsoft Excel training session, presented by Cathy Horwitz, you’ll learn how to use Excel to sort and filter large amounts of data, calculate mean and median values, highlight duplicate data, and create a scatter chart.
Upcoming live webinars: Take your appraisal skills to the next level with our Pro-Series webinars. View the schedule.
4. Job aid: Excel PivotTables Guide
This Excel training resource provides guidance on how to filter and compile data downloaded by you from MLS or another data source through the use of Excel PivotTables. This document requires that you have a general working knowledge of Excel.
5. Webinar recording: Using Microsoft Excel PivotTables: Tips for Appraisers
In just one fast-paced and informative Excel training session, you’ll learn how to use PivotTables to sort your data more efficiently, create multiple customized reports, see the easiest way to group your data in a few easy steps, and gain a powerful new tool to help you make better business decisions. Horowitz will teach you how to expand PivotTable data, create custom calculations, format a PivotTable, modify subtotal and grand total displays, learn addition tools on the PivotTable tabs, modify the PivotTable task pane, and create PivotCharts.
6. Webinar recording: Taking PivotTables to the Next Level
Learn how to effectively use Excel PivotTables and PivotCharts for sorting and analyzing appraisal data. In this one-hour training session, Horwitz will teach you how to expand PivotTable data, create custom calculations, format a PivotTable, modify subtotal and grand total displays, learn addition tools on the PivotTable tabs, modify the PivotTable task pane, and create PivotCharts.
If you already have an Unlimited Learning Membership, you can access all of these Microsoft Excel training sessions for free under the “Learning Library” tab in your McKissock dashboard. Not yet a member? Join here.