Choose your path
-- select --
Resources for Accountants
Resources for Bankers
Resources for Homeowners
Resources for Attorneys
Find An Appraiser
0 Registrations in Cart
Select an Offering
Advanced Spreadsheet Modeling for Valuation Applications
May 2 - 3, 2019
Mark V. Smeltzer, MAI, SRA, AI-RRS
Holiday Inn Express/Suites
875 Greentree Road
to check state approvals
Sponsor / Contact
This two-day course will teach appraisers to prepare advanced analyses in a simpler manner and with fewer errors. It will appeal to participants with experience in market analysis and highest and best use and also those with experience in applying inferred market analysis. The focus is on problem solving and efficiency while uncovering some of the tools of the spreadsheet program that will strengthen an analysis and increase productivity. Participants will find the applications especially helpful in the areas of market analysis, feasibility analysis, and highest and best use. Gain techniques to solve real-world problems and develop best practices in modeling that can be applied in other situations.
This course includes the same content as the seminar of the same name. It is now in the
Analytics for Valuation
Professional Development Program and therefore, an exam was added. For more information,
Upon completion of the course, participants should be able to:
• Recognize best practices and what to consider in financial model development
• Demonstrate how and when to use defined names in cells and ranges
• Identify key inputs in maximum building-size calculations
• Describe how to use key features of a spreadsheet program to easily make complex calculations
• Identify key inputs in land residual analysis
Table of Contents and Overview
• MAIs or SRAs who want to further their statistics knowledge and skill base
• Residential or general certified appraisers
• Real estate brokers
• A four-function calculator is required for the exam. You may use a financial calculator if you prefer.
Cellular phones, tablets, iPads, and other devices that connect to the Internet are NOT permitted during the exam.
• Microsoft Excel 2007 loaded and operational. If you do not have Excel, you may download a free trial version at
. Please note that this links to the latest version of Excel. There may be minor differences between versions.
Analysis Tool Pak
. Add-in must be installed prior to class.
Note to Mac users:
The course will be taught in Windows using Excel 2007. You will need the latest version of Excel (2011) in order to perform some of the exercises. Also, Microsoft does not support the Data Analysis Tool Pack in Mac Office Excel 2011. However, they do suggest free third-party add-ins with similar functionality.
For more information,
• Basic knowledge of spreadsheets, especially in Excel
• Experience in market analysis, highest and best use, and inferred market analysis
Using Spreadsheet Programs in Real Estate Appraisals - The Basics
or similar course/seminar
Participants must sign a waiver at the beginning of the course stating that they have the prerequisites. If they do not, they will not hold the Appraisal Institute responsible and will not expect to receive special attention during the course.
Up To 15 days prior to program start date, refund in full.
7 - 14 days prior to program start date, $50.00 cancellation fee.
Less than 7 days prior to program start date, forfeit of payment.
Up To 15 days prior to program start date, no transfer fee.
7 - 14 days prior to program start date, $25.00 transfer fee.
Less than 7 days prior to program start date, no transfer allowed.
Program materials can be downloaded by the student.
Holiday Inn Express/Suites - Greentree
875 Greentree Road
Pittsburgh, PA 15220
Tuition includes class materials, coffee, tea and water...no other food included. Students are on their own for lunch.
For room accommodations contact the Holiday Inn Express/Suites [formerly the Best Western), 875 Greentree Road, Pittsburgh PA 15220 (412-922-7070). Room rate of $109 per night, advise that you are with the Appraisal Institute when making your reservation. OR follow the link below.
The Holiday Inn offers a continental breakfast, free Wi-Fi, fitness room and pool. As well as complimentary airport (PIT), in town and local shuttle service to their quests.
Certificates of Completion
will be e-mailed from the National office in Chicago within fifteen (15) business days after the completion of the course.
Any questions contact Kari Ballenger at 412-563-1900 or firstname.lastname@example.org
Holiday Inn Express/Suites
200 W. Madison, Suite 1500, Chicago, IL 60606
888-7JOINAI (756-4624) |
Terms & Conditions
Copyright © 2017 Appraisal Institute. All rights reserved.