Skip Navigation LinksHome > Education > Seminar Description
 Decrease font   Enlarge font
Appraisal Institute Education

Using Spreadsheet Programs in Real Estate Appraisals - The Basics | Program Details

The technological advances of the last ten years have caused a significant change in the real estate appraisal profession. For example, today nearly all databases are computerized; it is imperative that appraisers can easily retrieve, list, and analyze large quantities of data. Participants must bring their laptops to this hands-on seminar where they will use Microsoft Excel to develop a spreadsheet skill set that includes the use of thousands of the program’s applications.

Additionally, residential appraisers are searching for diversified client bases. A more diversified client base requires diverse services and higher professionalism. The material presented in this seminar will help appraisers develop skills used to report statistical analysis and graphic illustrations to meet clients' needs.

At the end of this seminar participants will be able to

  • Recognize the many advantages of using spreadsheet programs

  • Illustrate the many uses of spreadsheet programs

  • Copy, cut, and paste data from one location to another

  • Identify common applications in spreadsheet programs that apply to real estate appraisal

  • Identify basic statistical tools that can be used in appraisal development

  • Recognize the applications of spreadsheet programs in the sales comparison approach

  • Illustrate the use of spreadsheets to support units of comparison analysis

  • Demonstrate the use of spreadsheets in a cost approach summary

  • Identify various editing tools available for use in spreadsheets

  • Illustrate use of basic spreadsheet procedures to perform basic mathematical functions

  • Estimate the depreciation rates in a market utilizing spreadsheet tools

Prerequisites
Ability to perform basic mathematical calculations, cell formatting navigation, and file management in MICROSOFT® EXCEL

Downloads
Table of Contents and Overview [PDF]

Type
General/Residential

Equipment Required
All students are expected to have a laptop computer with MICROSOFT Excel loaded on it. Also, students must bring the CD included with the seminar materials. If you do not currently own MICROSOFT EXCEL, you can download a free copy for 60 days at http://office.microsoft.com/en-us/excel/default.aspx.

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

Classroom Hours
7.0

Level
Basic

For Further Reading
None Specified.

Registration Information
Schedule

Click here for state approvals


Class Schedule & Locations

02/03/2010 - 02/03/2010
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


02/10/2010 - 02/10/2010
Location: Louisville, KY
Click here for location details
Sponsor: Bluegrass
Contact: Susan Katz, (502) 727-9181
Instructor: Smeltzer, Mark V., SRA


02/12/2010 - 02/12/2010
Location: Wichita, KS
Click here for location details
Sponsor: Greater Kansas State
Contact: Trecia A. McDowell, (316) 265-7695
Instructor: Rattermann, Mark R., MAI, SRA
Register


02/16/2010 - 02/16/2010
Location: Greensboro, NC
Click here for location details
Sponsor: North Carolina
Contact: Nancy Toombs, (336) 297-9511
Instructor: Urso, Jeffrey, SRA


02/19/2010 - 02/19/2010
Location: Woodbridge, VA
Click here for location details
Sponsor: Stonewall Jackson
Contact: Craig Sewell, (540) 868-2751
Instructor: Smeltzer, Mark V., SRA
Register


02/25/2010 - 02/25/2010
Location: Orlando, FL
Click here for location details
Sponsor: East Florida
Contact: Lauren Dowling, (407) 888-9480
Instructor: Smeltzer, Mark V., SRA
Register


03/05/2010 - 03/05/2010
Location: Greenville, SC
Click here for location details
Sponsor: South Carolina
Contact: Caroline Stephenson, (803) 782-2922
Instructor: Urso, Jeffrey, SRA


04/14/2010 - 04/14/2010
Location: South Bend, IN
Click here for location details
Sponsor: Northern Indiana-SW Michigan
Contact: Nancy Toombs, (336) 297-9511
Instructor: Rattermann, Mark R., MAI, SRA


04/29/2010 - 04/29/2010
Location: Bozeman, MT
Click here for location details
Sponsor: Montana
Contact: Jerry Mitchke, (406) 495-1608
Instructor: Smeltzer, Mark V., SRA


04/30/2010 - 04/30/2010
Location: Las Vegas, NV
Click here for location details
Sponsor: Las Vegas
Contact: Tina Anderson, (702) 838-8489
Instructor: Wright, Larry T., MAI, SRA
Register


05/13/2010 - 05/13/2010
Location: Tigard, OR
Click here for location details
Sponsor: Greater Oregon
Contact: Vicki Champ, (503) 316-1979
Instructor: Smeltzer, Mark V., SRA
Register


05/24/2010 - 05/24/2010
Location: St. Louis, MO
Click here for location details
Sponsor: Greater St. Louis
Contact: Cathy Mifflin, (314) 355-8890
Instructor: Rattermann, Mark R., MAI, SRA


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


06/23/2010 - 06/23/2010
Location: St. Paul, MN
Click here for location details
Sponsor: North Star
Contact: Maribelle Cushman, (651) 633-0676
Instructor: Rattermann, Mark R., MAI, SRA
Register