How to Excel for Appraisers – Episode 2

Market Change: Learn how to use Excel to develop a market change adjustment, Episode 2

Date/Time: Wednesday, Feburary 22nd | 10AM – 11:30AM Central Time

**Registration for Episode 2 (the live webinar) closes at 945AM CT on 02/22/2023**
**Episode 2 recording will be available for purchase within 24 once live webinar ends**

Live webinar registration is closed; Recording will be available for sale this evening. Please check back!
*KNOW YOUR TIME ZONE: We’re on CENTRAL TIME, and Webinar starts at 10AM CT sharp!
If you are on Pacific Time, Webinar is from 8am-9:30am (doors open at 7am)
If you are on Mountain Time, Webinar is from 9am-10:30am (doors open at 8am)
If you are on Central Time, Webinar is from 10am-11:30am (doors open at 9am)
If you are on Eastern Time, Webinar is from 11am-12:30pm (doors open at 10am)

90 Minutes

$49.95 (NON-CE Webinar)

*Registration Includes:

  • access to the LIVE WEBINAR and RECORDING;
  • the Market Change Excel Template (ready to use);
  • the Market Change User Manual (with instructions); and
  • 1-on-1 instructor support and Q&A during the live webinar and by appointment/email.

*NOTE – We will email the free Market Change Excel template (Version 2) and user manual to all registered attendees on the day before and the morning of the webinar.

Webinar Description

This is our second episode of this webinar, which will be covering the same topic – How to make Market Change Adjustments using Excel. Feedback from our first episode has been used to refine the presentation.

Changing markets with few current sales may warrant time adjustments. A time adjustment to a similar sale from several months ago may be more credible than several adjustments to a recent sale.

The goal of this webinar is to teach appraisers the basics of Excel and how to make a market change adjustment. All attendees will receive a Market Change Excel Template. Using this template, participants learn how to analyze and report market change immediately. Specifically, this webinar will teach participants:

  • What USPAP & the GSEs say about selecting properties for a market change adjustment;
  • How to export data from their MLS and import it into Excel;
  • How to accelerate their analyses by using Excel Tables;
  • How to import table data into the Market Change Template
  • How to interpret the resulting chart to calculate market change adjustments
  • How to communicate market changes to the client clearly and persuasively

Included in the class is a pdf with complete instructions to build your own template from scratch. You will be able to edit the template to fit your style preferences. You will also learn Excel skills that are transferable to solve other problems.

  • How to master the Excel slope function to calculate an adjustment rate;
  • How to subtract dates for critical intervals;
  • How to apply an adjustment rate to an interval in days using absolute references;
  • How to calculate a market-to-market adjustment using relative references;
  • How to lock formula fields and save your Excel template for future use;

Webinar System Requirements

  • This webinar is offered via Zoom meeting. Computer Audio, Video and a reliable internet connection are recommended.
  • If you’re new to zoom, click the following link to launch a test meeting: https://zoom.us/test.
  • Older versions of Excel should work, but instructors will be using Excel 365 to build the Market Change Template
  • The free Market Change Excel template, with instructions and class notes, will be emailed to all registered attendees on the day before and the morning of the webinar.

Course Instructor

Tim Andersen

Tim Andersen is an AQB Certified USPAP Instructor, consultant, and reviewer.  He also does commercial real estate appraisal and Florida tax appeal work. He travels throughout the US teaching USPAP, and is an Approved Instructor for the Appraisal Institute. Have PowerPoint, Will Travel. Besides all facets of commercial real estate appraisal, other areas of expertise include writing, producing, and presenting webinars on all areas of real estate appraisal.

Specialties: Appraisal Institute member, designated as an MAI, Master of Science degree in Real Estate Appraisal , AQB Certified, USPAP Instructor, State Certified General Real Estate Appraiser, Instructor with the Appraisal Institute, Experienced Public Speaker

Course Author

Scott Cullen

Scott Cullen is a boots-on-the-ground Certified Residential appraiser from Minneapolis / St Paul with over 20 years of experience.  He is a cofounder of Solomon, a suite of cloud-based calculators that help over 500 appraisers daily to quickly support their adjustments using the recognized technique of depreciated cost analysis.

His calculators come with licensed cost data built-in, making it easy and economical to support your sales grid adjustments.  Beyond grid adjustments, Solomon supports other assignment results such as effective age, remaining economic life and site value.

Related products

Subscribe to
Appraiser eLearning!

Sign up to get free webinars, podcasts, blogs, discounts and more.

*We value your privacy. We never send you any spam or pass your information to 3rd parties.

Advanced Appraisal Review | Live Virtual Class | Tuesday & Wednesday January...Elimination of Bias and Introduction of Cultural Competency for Appraisers –...