|
Excel Applications for Valuation
|
|
|
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 develop and review the Excel skills needed for the
Appraisal Institute’s advanced coursework leading to the MAI designation. The examples
and templates in the course mostly relate to general appraisers, but the Excel
skills covered may also be beneficial to residential appraisers.
A wide range of material is covered in this
course, starting with the very basics, then progressing to more advanced Excel
functionality including financial math, discounted cash flow analysis, simple
statistics, and generating charts and graphs. The course materials include some
basic Excel templates that are used for in-class examples and can also be used outside
of class in a general valuation practice.
|
|
Sponsor |
Date |
Location |
Delivery Format |
Check State Approvals |
|
Appraisal Institute |
On Demand |
|
Online |
Check |
Register |
|
|
Program State Approval & Hours
Some AI educational programs may not be approved in every state and every delivery format. To see a list of all state approvals across all formats for this course, please use the link below.
View all approvals for this course
|
|
- Appraisers planning to take advanced courses towards the MAI designation.
- Appraisers who want to sharpen their Excel skills.
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 and calculations.
- Use Excel functions and formulas to calculate the following:
- Adjusted price in adjustment grids
- Net and gross adjustment
- Market conditions adjustment
- Economic life
- Depreciation
- Loan constant
- Financial functions (PMT, PV, FV, RATE, NPER)
- Discount rate
- Present value and internal rate of return
|
|
Appraisal Institute CE Points
|
|
|
|
|
Required and/or Recommended Equipment
Software
required: Microsoft Excel 2010 or higher. Note: The course is designed
for students to work along in an Excel workbook as they view the video
instruction. Therefore, recommended equipment includes a computer with dual
monitors, or at least a single large monitor that can be divided into two
separate windows. The need to flip back and forth between video and the Excel
templates on a small laptop monitor will increase the amount of time required
to complete the course.
|
|
|
Online Course AccessGo 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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|