Excel Applications for Valuation
Register
- Date
- On Demand
- Location
- Sponsor
- Appraisal Institute
- Instructor
- Matthew Larrabee, MAI
- Class Time
- 8 hours
- Full Price
- $145.00
- AI Price
- $120.00
Course 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 seminar will increase your skill level in using Microsoft Excel. It also will sharpen the Excel skills you’ll need for AI’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.
Read More
Who Should Enroll
- Appraisers planning to take advanced courses towards the MAI designation.
- Appraisers who want to sharpen their Excel skills.
State Approvals
| State | QE/CE | Course & Exam | Course Only | Exam Only | Delivery Format | Approval Format | Start Date | Expire Date | State Code |
|---|---|---|---|---|---|---|---|---|---|
| AK | CE | 8 | 8 | Online | Online | 01/26/2021 | 12/20/2023 | 18263 | |
| AK | CE | 8 | 8 | Online | Online | 11/06/2023 | 11/06/2026 | 19683 | |
| AL | CE | 8 | 8 | Online | Online | 10/01/2022 | 09/30/2024 | C02620 | |
| AR | CE | 8 | 8 | Online | Online | 03/15/2021 | 03/11/2025 | ||
| AZ | CE | 8 | 8 | Online | Online | 01/01/2022 | 12/20/2023 | 76614 | |
| CA | CE | 8 | 8 | Online | Online | 01/15/2021 | 01/14/2025 | 21CP754601456 | |
| CO | CE | 8 | 8 | Online | Online | 01/08/2021 | 12/20/2023 | ||
| CO | CE | 8 | 8 | Online | Online | 11/03/2023 | 12/16/2026 | 2507 | |
| CT | CE | 8 | 8 | Online | Online | 01/29/2021 | 12/20/2023 | AAL.000749 | |
| CT | CE | 8 | 8 | Online | Online | 12/21/2023 | 12/16/2026 | AAL.001148 | |
| DE | CE | 8 | 8 | Online | Online | 01/01/2022 | 12/20/2023 | 76614 | |
| FL | CE | 8 | 8 | Online | Online | 03/15/2023 | 03/14/2025 | 0010259 | |
| GA | CE | 8 | 8 | Online | Online | 01/15/2021 | 12/20/2023 | 72799 | |
| GA | CE | 8 | 8 | Online | Online | 12/21/2023 | 12/16/2026 | ||
| HI | CE | 8 | 8 | Online | Online | 11/07/2023 | 12/31/2024 | 23-416 | |
| IA | CE | 8 | 8 | Online | Online | 01/08/2021 | 12/20/2023 | A518-1147 | |
| IA | CE | 8 | 8 | Online | Online | 12/21/2023 | 12/16/2026 | A518-1147 | |
| ID | CE | 8 | 8 | Online | Online | 01/28/2021 | 12/20/2023 | ||
| ID | CE | 8 | 8 | Online | Online | 11/17/2023 | 12/16/2026 | ||
| IL | CE | 8 | 8 | Online | Online | 01/01/2023 | 12/31/2024 | 575.010478 | |
| IN | CE | 8 | 8 | Online | Online | 01/01/2022 | 12/20/2023 | 76614 | |
| KS | CE | 8 | 8 | Online | Online | 01/01/2023 | 12/31/2023 | 353.C22.N | |
| KY | CE | 8 | 8 | Online | Online | 07/01/2023 | 06/30/2024 | ||
| LA | CE | 8 | 8 | Online | Online | 01/20/2021 | 12/20/2023 | A0038 | |
| MA | CE | 8 | 8 | Online | Online | 01/11/2021 | 12/20/2023 | 00120119-RA-CA | |
| MD | CE | 8 | 8 | Online | Online | 01/01/2022 | 12/20/2023 | 76614 | |
| ME | CE | 8 | 8 | Online | Online | 01/01/2022 | 12/20/2023 | 76614 | |
| MI | CE | 8 | 8 | Online | Online | 03/08/2021 | 01/06/2024 | 3490 | |
| MN | CE | 8 | 8 | Online | Online | 03/01/2023 | 02/28/2025 | 1030959 | |
| MO | CE | 8 | 8 | Online | Online | 02/17/2021 | 01/06/2024 | ||
| MO | CE | 8 | 8 | Online | Online | 01/07/2024 | 01/06/2027 | ||
| MS | CE | 8 | 8 | Online | Online | 03/31/2023 | 12/20/2023 | MAB #50288 | |
| MS | CE | 8 | 8 | Online | Online | 12/21/2023 | 12/20/2025 | MAB #50288 | |
| MT | CE | 8 | 8 | Online | Online | 02/01/2021 | 12/20/2023 | REA-CEC-REC-13355 | |
| MT | CE | 8 | 8 | Online | Online | 11/01/2023 | 11/01/2026 | REA-CEC-REC-17114 | |
| NC | CE | 8 | 8 | Online | Online | 01/01/2023 | 12/31/2023 | 4407 | |
| NC | CE | 8 | 8 | Online | Online | 01/01/2023 | 12/31/2023 | 4407 | |
| ND | CE | 8 | 8 | Online | Online | 01/21/2021 | 12/20/2023 | CE-221009S | |
| ND | CE | 8 | 8 | Online | Online | 01/20/2021 | 12/20/2023 | CE-221009S | |
| NE | CE | 8 | 8 | Online | Online | 01/29/2021 | 01/29/2026 | 2212404.02 | |
| NH | CE | 8 | 8 | Online | Online | 03/05/2021 | 12/20/2023 | ||
| NJ | CE | 8 | 8 | Online | Online | 02/18/2021 | 12/20/2023 | 2021-3423 | |
| NJ | CE | 8 | 8 | Online | Online | 12/21/2023 | 12/16/2026 | 2023-3442 | |
| NM | CE | 8 | 8 | Online | Online | 03/02/2021 | 12/20/2023 | 3168 | |
| NV | CE | 8 | 8 | Online | Online | 02/01/2023 | 01/31/2024 | CE.0009413-A | |
| NV | CE | 8 | 8 | Online | Online | 11/13/2023 | 01/31/2025 | CE.0009413-A | |
| NY | CE | 8 | 8 | Online | Online | 01/01/2023 | 12/31/2023 | A5261-08 | |
| NY | CE | 8 | 8 | Online | Online | 01/01/2024 | 12/31/2024 | A5261-08 | |
| OH | CE | 8 | 8 | Online | Online | 01/01/2023 | 12/31/2023 | 923302403A 22 | |
| OH | CE | 8 | 8 | Online | Online | 01/01/2023 | 12/20/2023 | 923302403A 22 | |
| OH | CE | 8 | 8 | Online | Online | 01/01/2024 | 12/31/2024 | 923404211A 24 | |
| OK | CE | 8 | 8 | Online | Online | 01/23/2021 | 12/20/2023 | 919 | |
| OK | CE | 8 | 8 | Online | Online | 12/21/2023 | 12/16/2026 | 919 | |
| OR | CE | 8 | 8 | Online | Online | 07/14/2021 | 12/20/2023 | APIN-C-0721-8885 | |
| OR | CE | 8 | 8 | Online | Online | 12/21/2023 | 09/15/2026 | APIN-C-0721-8885 | |
| PA | CE | 8 | 8 | Online | Online | 02/15/2021 | 01/08/2024 | ||
| PR | CE | 8 | 8 | Online | Online | 01/01/2022 | 12/20/2023 | 76614 | |
| RI | CE | 8 | 8 | Online | Online | 01/20/2021 | 01/06/2024 | REA.0001650-CE | |
| RI | CE | 8 | 8 | Online | Online | 01/07/2024 | 12/16/2026 | RREA.0002114-CE | |
| SC | CE | 8 | 8 | Online | Online | 09/01/2022 | 08/31/2024 | DE 1932 | |
| SD | CE | 8 | 8 | Online | Online | 02/17/2021 | 02/17/2024 | SD 1440 | |
| TN | CE | 8 | 8 | Online | Online | 07/01/2023 | 06/30/2025 | 2473 | |
| TX | CE | 8 | 8 | Online | Online | 04/01/2023 | 12/20/2023 | TX Provider #:10 Course #: 45612 | |
| TX | CE | 8 | 8 | Online | Online | 12/21/2023 | 12/16/2025 | TX Provider #:10 Course #: 45612 | |
| UT | CE | 8 | 8 | Online | Online | 04/01/2023 | 03/31/2025 | AC230309 | |
| VA | CE | 8 | 8 | Online | Online | 01/01/2022 | 12/20/2023 | 76614 | |
| VT | CE | 8 | 8 | Online | Online | 01/11/2021 | 01/11/2025 | CA-14769 | |
| WA | CE | 8 | 8 | Online | Online | 09/12/2023 | 01/06/2024 | A23025756 | |
| WI | CE | 8 | 8 | Online | Online | 01/01/2022 | 12/20/2023 | 76614 | |
| WV | CE | 8 | 8 | Online | Online | 01/29/2021 | 12/20/2023 | ||
| WV | CE | 8 | 8 | Online | Online | 12/21/2023 | 12/16/2026 | ||
| WY | CE | 8 | 8 | Online | Online | 04/22/2021 | 04/22/2024 |
Course 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 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
Course Details
Prerequisites
Pricing Options
| Rate | Full Price | AI Price |
|---|---|---|
| Standard
Today thru 12/31/2050 |
$145.00 | $120.00 |