Using Spreadsheet Programs in Real Estate Appraisals - The Basics

Some AI educational programs may not be approved in every state.

Students should check state approvals prior to registering for any Appraisal Institute program.

To register for this program, go to the bottom of the page.



Who should enroll
  • Beginning real property appraisers
  • Real estate professionals
  • Users of appraisal services
  • College students
  • Accountants
Description The technological advances of the last 10 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. Developing spreadsheet skills to report statistical analysis and provide graphic illustrations will help appraisers meet the needs of a more diversified client base.

 

Objectives
  • 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 using spreadsheet tools.

 

 

Prerequisites Ability to perform basic mathematical calculations, cell formatting and navigation, and file management in Microsoft Excel


Refer to this page for details of state approval hours for this course.

  • Attended Only:

    35
  • Attended Only:

    35
  • Attended Only:

    35
7 hours
No
 
No
N/A
Intermediate
  • A laptop computer is required.
  • Microsoft Excel 2007 or later must be loaded and operational. If you do not currently have Excel, you can download a trial copy.
N/A
  • A laptop computer is required.
  • Microsoft Excel 2007 or later must be loaded and operational. If you do not currently have Excel, you can download a trial copy.
Classroom Requirements Online Requirements

Live Online FAQ

None specified

Each live online synchronous session runs for 3.5 hours each day with at least 2 breaks during that time. The course runs for 2 half-days.

Connection Information

Several minutes after you register, you will receive second e-mail which includes instructions in how to connect to the synchronous sessions. If you did not receive the connection information, please check your junk, spam, or quarantine folder. Connection e-mail reminders are sent 1 week, 1 day, and 1 hour prior to synchronous session start time.
 
Disclaimer

I agree to the terms and policies set forth under the Appraisal Institute Online Education Policy. I also certify that I am the person identified above under Personal Data and that I will personally complete each assigned module of instruction and any examination(s). I understand and agree that if I misrepresent my identity or arrange for someone else to represent himself or herself as me at any time during the Appraisal Institute online course or seminar, I will be immediately removed from the course or seminar and I will not be entitled to any refund. I further understand that if I am a Designated member, Candidate for Designation, Practicing Affiliate, or Affiliate of the Appraisal Institute and participated in any misrepresentation of identity, by affirmative act or failure to act, I will be the subject of a peer review proceeding under Regulation No. 6 for violation of the Code of Professional Ethics and Standards of Professional Practice of the Appraisal Institute, and such peer review proceeding may result in termination of my Appraisal Institute membership, candidacy, and/or affiliation.

 


 



Classroom Offerings

No offerings at this time

Synchronous Offerings

Sponsor Date Location Instructor(s)