Shopping Cart    
Welcome,   My Account

Residential Applications Part 2: Using Microsoft Excel to Analyze and Support Appraisal Assignments Results Education Schedule (PDF)
Education Catalog (PDF)
Some AI educational programs may not be approved in every state.
Students should check state approvals prior to registering for any Appraisal Institute program.

ClassroomOn-Demand Online EducationLive Online (Synchronous)

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, market analysis using the Fannie Mae 1004 MC.  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!

At the end of this seminar you should be able to:

    • Apply spreadsheets, PivotTables, 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 stigma
    • Support external obsolescence
    • Support liquidation value
    • Find and support data to complete the Fannie Mae 1004MC form

This seminar is for participants with a basic level of knowledge of spreadsheets, especially Excel, such as those obtained from

Note. This seminar will be taught from Windows using Excel 2010. If you are taking the seminar and plan to use an Apple laptop, you will need to have the latest version of Excel (2011) in order to perform some of the exercises.

Recommended Texts

Program Overview
• Table of Contents and Overview (PDF)
• Schedule (PDF)


Ordering Information
To order books and other materials go to
our store

Please contact the sponsoring chapter for information on fees applicable to chapter programs.

AI strongly recommends, but does not require, that participants bring a laptop computer to class. All participants with a laptop MUST HAVE Microsoft Excel 2007, 2010, or 2013 loaded and operational. No version prior to Excel 2007 will be taught in the seminar.

AI CE Credit for Designated Members, Candidates for Designation, and Practicing Affiliates
• Attend Only = 75 points


Click Here for State Approvals

Class Schedule & Locations

03/14/2015 - 03/14/2015
Location: Orlando, FL
Click here for location details
Sponsor: East Florida
Contact: Lauren Dowling, (813) 651-5904
Instructor: Smeltzer, Mark V., SRA

06/04/2015 - 06/04/2015
Location: Des Moines, IA
Click here for location details
Sponsor: Iowa
Contact: Wayne J. Hennessey, MAI, SRA, (515) 971-5285
Instructor: Atwood, James B., SRA

06/05/2015 - 06/05/2015
Location: Davenport, IA
Click here for location details
Sponsor: Iowa
Contact: Wayne J. Hennessey, MAI, SRA, (515) 971-5285
Instructor: Atwood, James B., SRA

09/25/2015 - 09/25/2015
Location: Bloomington, IL
Click here for location details
Sponsor: Chicago
Contact: L.A. Anderson, (312) 616-9406
Instructor: Smeltzer, Mark V., SRA

Pop up content here.

Agree Disagree