Shopping Cart
Search
Login
Welcome,   My Account


   
Advanced Spreadsheet Modeling for Valuation Applications 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.

ClassroomOnlineLive Online (Synchronous)

Course Description

This two-day course will teach appraisers to prepare advanced analyses in a simpler manner and with less error. 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 make an analysis stronger 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.

 

Important note. 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,click here.


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

·          Identify key inputs in feasibility rent analysis

·          Recognize complex highest and best use analysis

·          Recognize the basic concepts in sorting

·          Analyze the outlining function in Excel

·          Demonstrate skills in filtering data

Note. When you receive your registration e-mail confirmation, a secure link will be available to download Excel files to use for in-class exercises. Be sure to download these files prior to coming to class.

 

 

Program Overview
Course Schedule [PDF]
Table of Contents and Overview [PDF]

Recommended Text
None Specified.

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

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

Required

  •        Laptop
  •        A four-function calculator is required for the exam. You may use a financial calculator if you prefer. Note: 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 copy for 69 days at http://office.microsoft.com/en-us/try/.
  •       Solver Add-in and Analysis Tool Pak. Add-in must be installed prior to class.
Note to Mac users: The course will be taught from 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, see:
2011:
http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/what-happened-to-the-data-analysis-toolpak-or/740ff33a-6ed9-4553-bc09-5cef06ce5f23

Hours
15 (14 classroom +1 hour exam)

AI CE Credit for Designated Members, Candidates for Designation, and Practicing Affiliates

  1. Attend Only = 145 points
  2. Attend and Pass= 200 points
  3. <

Prerequisites
• Basic knowledge of spreadsheets, especially in Excel • Experience in market analysis, highest and best use, and inferred market analysis Recommended: •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.

Who Should Enroll
MAIs or SRAs who want to further their statistics knowledge and skill base, residential or general certified appraisers, reviewers, real estate brokers, underwriters

Click Here for State Approvals


  
Class Schedule & Locations

06/19/2014 - 06/20/2014
Location: Indianapolis, IN
Click here for location details
Sponsor: Hoosier State
Contact: Shannon O'Keefe, (317) 815-1340
Instructor: Rattermann, Mark R., MAI, SRA
Register


09/24/2014 - 09/25/2014
Location: Louisville, KY
Click here for location details
Sponsor: Bluegrass
Contact: Susan Katz, (502) 727-9181
Instructor: Smeltzer, Mark V., SRA
Register






Pop up content here.

Agree Disagree
close (X)