Excel Applications for Valuation

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

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



Who should enroll
  • Appraisers who want to sharpen their Excel skills.
  • Appraisers planning to take advanced courses towards the MAI designation.
Description
More and more, appraisers are using spreadsheets rather than financial calculators in their day-to-day work to solve complex appraisal problems. The use of Microsoft Excel and Excel templates provide efficiencies that assist appraisers in meeting modern appraisal market demands.
 
Featuring several hours of video instruction, the focus of Excel Applications for Valuation is to increase the participant’s level of ability in using Microsoft Excel. The program also provides the opportunity to sharpen the Excel skills needed for the Appraisal Institute’s advanced coursework.
 
A wide range of material is covered in this course, starting with the very basics, then progressing to more advanced Excel functionality and the templates that can be used in valuation.

Objectives After satisfactorily completing the program, students will be able to:
  • Create Excel worksheets and demonstrate basic formatting, math, and reporting functionalities.
  • Solve problems using financial math functionality.
  • Demonstrate how the Excel copy functionality is used with formulas, tests, and calculations.
  • Use Excel functions and formulas to calculate the following:
    • Adjusted price
    • Net adjustment
    • Gross adjustment
    • Market condition adjustment
    • Economic life
    • Depreciation loan constant
    • PMT function
    • Discount rate
    • Internal rate of return
Prerequisites None.


Click below for details of state approval hours for this program

Program State Approvals
  • Attended Only:

    40
  • Attended Only:

    40
  • Attended Only:

    40
8 hours
90
None.
No
N/A
Basic/Intermediate
Classroom Recommendations and Requirements Software required:  Microsoft Excel 2010 or higher Synchronous Recommendations and Requirents
Classroom Requirements Online Education FAQ Synchronous Requirements
Online Course Access
Go to www.appraisalinstitute.org and log in with the username and password you used when you registered. Click on the red “My Account” button if you are not automatically taken to your account page.
1. Click "Education and Events" on the right navigation menu.
2. Find the course under the “Online Courses” heading and click the “Begin” button.
IMPORTANT NOTE: Once this button is clicked, your access length time (e.g. 90 days) will begin. Only click when you intend to start the course. If you are returning, once you have started the course, click the “Continue” button to continue.

Other Details:
For information about how on demand online education programs work, registration and cancellation policies, and other details, see our On Demand Online Education Frequently Asked Questions.


Classroom Offerings

No offerings at this time

Synchronous Offerings

No offerings at this time

Register to take this online course:

Register Now