Residential Applications Part 2: Using Microsoft Excel to Analyze and Support Appraisal Assignments Results

Some AI educational programs may not be approved in every state.

Students should check state approvals prior to registering for any Appraisal Institute program.

To register for this program, go to the bottom of the page.



Who should enroll Residential real property appraisers
Description Building on the skills and techniques highlighted in Residential Applications Part 1: Using Technology to Measure and Support Assignment Results, this practical, hands-on seminar provides residential appraisers with an additional set of technological tools to measure and support work results that will increase client satisfaction.

Learn how to create charts, graphs, and tables to provide market-derived support for the following appraisal issues: neighborhood age and sale price, neighborhood predominant age and sale price, exposure time, gross living area adjustments, site value and site adjustments, stigma, external obsolescence, liquidation value, and market analysis using the Fannie Mae 1004MC. Immediately use your seminar handbook full of examples and step-by-step instructions for later reference. This could be one of the most valuable residential seminars you have ever taken!
Objectives
  • Apply spreadsheets, pivot tables, simple regression, charts, and graphs to everyday appraisal problems.
  • Support a neighborhood age range and predominant age.
  • Support a neighborhood price range and predominant sale price.
  • Support an opinion of exposure time.
  • Support a gross living area adjustment.
  • Support a site value and site adjustments.
  • Support a conclusion related to stigma.
  • Support a conclusion related to external obsolescence.
  • Support a conclusion related to liquidation value.
  • Find and support data to complete the Fannie Mae 1004MC form.
Prerequisites


Refer to this page for details of state approval hours for this course.

  • Attended Only:

    75
  • Attended Only:

    75
  • Attended Only:

    75
7 hours
Yes. After you register for this class, please go to your Education and Events page for
details on what you must complete BEFORE class begins.
 
To access your Education and Events page, log on to the Appraisal Institute website at https://ai.appraisalinstitute.org/eweb (click on the three horizontal lines to the left of the AI logo and select “My
AI Account” from the drop-down menu).
 
No
N/A
Intermediate
  • A laptop computer is required.
  • Microsoft Excel 2007 or 2010 with Solver Add-in and Analysis Tool Pak Add-in must be installed prior to class. Download a trial copy of Excel by clicking here.
  • Note to Mac users: Microsoft does not support the Data Analysis Tool Pack in Mac Office Excel 2008 or Mac Office Excel 2011. However, they do suggest free third-party add-ins with similar functionality. For more information, click here for 2008 or click here for 2011.
  • You must be familiar with basic Excel operation when the seminar begins. Do not enroll expecting to be taught how to use Excel.
  • The registration email confirmation will provide a secure link to download Excel files for in-class exercises.

 
N/A
  • A laptop computer is required.
  • Microsoft Excel 2007 or 2010 with Solver Add-in and Analysis Tool Pak Add-in must be installed prior to class. Download a trial copy of Excel by clicking here.
  • Note to Mac users: Microsoft does not support the Data Analysis Tool Pack in Mac Office Excel 2008 or Mac Office Excel 2011. However, they do suggest free third-party add-ins with similar functionality. For more information, click here for 2008 or click here for 2011.
  • You must be familiar with basic Excel operation when the seminar begins. Do not enroll expecting to be taught how to use Excel.
  • The registration email confirmation will provide a secure link to download Excel files for in-class exercises.

 
None specified Online Requirements Synchronous Requirements
Fannie Mae’s Collateral Underwriter (CU) requirement obligates residential appraisers to prove their adjustments. This seminar provides the knowledge needed to do just that!

“The seminar is exactly what residential appraisers need today to understand how CU works, since it explains linear regression using their own MLS data combined with Excel. It gives them the tools to use regression in their own markets to understand what Fannie Mae's CU will be generating for typical adjustments.”
Craig Steinley, SRA, AI-RRS


Classroom Offerings

No offerings at this time

Synchronous Offerings

No offerings at this time