Need Help? Call 888-7JOINAI (756-4624)
Skip Navigation LinksHome > Education > Seminar Description
 

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 easily retrieve, list, and analyze large quantities of data. During this hands-on seminar, participants will use Microsoft Excel to develop a spreadsheet skill set that includes the use of thousands of the program’s applications. By developing spreadsheet skills that report statistical analysis and provide graphic illustrations, residential appraisers will have additional professional skills to meet the needs of a more diversified client base.






At the end of this seminar participants should 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]
Schedule [PDF]

Type
General/Residential

Equipment Required
All students MUST 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/try/.

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

Classroom Hours
7.0

AI CE Credit for Designated members and Candidates for Designation
This program is approved for 1.25 hours of Appraisal Institute CE credit for every hour taken.

To receive credit, participants must attend 100% of the program.

Level
Basic

For Further Reading
None Specified.

Registration Information
Schedule

Click Here for State Approvals


Class Schedule & Locations

06/07/2013 - 06/07/2013
Location: Memphis, TN
Click here for location details
Sponsor: Memphis-Tennessee
Contact: Susan Evans, (901) 218-0782
Instructor: Klutz III, S. Warren, MAI, SRA
Register