The use of Microsoft Excel is widespread in the appraisal industry. Looking for new ways to leverage Excel tools in your appraisal business? Here are four excellent Microsoft Excel resources offered by McKissock Learning—including a Pro-Series webinar on Wednesday, January 27, 2021, “Using Excel for Pairing Data to Extract GLA Adjustments.”
Webinar: 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.
Join us for a Pro-Series webinar on Wednesday, January 27, 2021 from 11am-12pm EST, “Using Excel for Pairing Data to Extract GLA Adjustments.” In this one-hour, non-credit webinar, presenters Rob Frazier and Cathy Horwitz will 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.
Take your appraisal skills to the next level with our Pro-Series webinars. View the schedule.
More Microsoft Excel Resources (Free for Members)
Unlimited Learning Members enjoy 24/7 access to previously recorded Pro-Series webinars via our resource library. Some recent Excel related pro-series webinars include:
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 webinar 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.
Using Microsoft Excel PivotTables: Tips for Appraisers
In just one fast-paced and informative 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.
In this one-hour recorded webinar, Horwitz teaches 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.
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 these three Microsoft Excel webinar training sessions for free under the “Resources” tab in your membership dashboard. Not yet a member? Join here.