Advanced Spreadsheet Modeling for Valuation Applications
If you have experience in market analysis and highest and best use or in applying inferred market analysis, this two-day course will appeal to you! It shows you how to prepare advanced analyses in a simpler manner and with less error. The focus is on problem solving and efficiency while uncovering some of the tools of the spreadsheet program that will make an analysis stronger and increase productivity. You’ll find the applications especially helpful in the areas of market analysis, feasibility analysis, and highest and best use, and you’ll gain techniques to solve real-world problems and develop best practices in modeling that can be applied in other situations.
This course is in the Analytics for Valuation Professional Development Program. View this list of FAQs, which includes information regarding the courses you’ll need to complete the program successfully.
Who Should Enroll
- MAIs or SRAs who want to further their statistics knowledge and skill base
- Certified residential or general real property appraisers
- Reviewers
- Real estate brokers
- Underwriters
AI CE Points
Attend:
150
Attend & Pass Exam:
200
Pass Only:
150
Course Offerings
We are not currently offering this course, but please contact us for additional options and more information.
Course Objectives
- Recognize best practices and what to consider in developing a financial model.
- Demonstrate how and when to use defined names in cells and ranges.
- Identify key inputs in maximum building-size calculations.
- Describe how to use key features of a spreadsheet program to make complex calculations easily.
- Identify key inputs in land residual analysis.
Course Materials & Recommended Books
State Approvals
| State | QE/CE | Course & Exam | Course Only | Exam Only | Delivery Format | Start Date | Expire Date | State Code |
|---|---|---|---|---|---|---|---|---|
| AR | CE | 14 | 14 | Classroom | 09/24/2025 | 09/07/2027 | AI098 | |
| AR | CE | 14 | 14 | Synchronous | 09/24/2025 | 09/07/2027 | AI098 | |
| CO | CE | 14 | 14 | Classroom | 12/01/2023 | 09/14/2026 | 2483 | |
| CO | CE | 14 | 14 | Synchronous | 12/01/2023 | 09/14/2026 | 2483 | |
| CT | CE | 14 | 14 | Classroom | 04/09/2025 | 04/09/2028 | AAL.001387 | |
| CT | CE | 14 | 14 | Synchronous | 04/09/2025 | 04/09/2028 | AAL.001387 | |
| DC | CE | 15 | 14 | 1 | Classroom | 02/29/2024 | 02/28/2026 | 3431 |
| DC | CE | 15 | 14 | 1 | Synchronous | 02/29/2024 | 02/28/2026 | 3431 |
| FL | CE | 14 | 14 | Classroom | 11/02/2024 | 11/01/2026 | 0008817 | |
| GA | CE | 14 | 14 | Classroom | 01/02/2014 | 60353 | ||
| GA | CE | 15 | 14 | 1 | Classroom | 01/01/2014 | 64735 | |
| GA | CE | 14 | 14 | Synchronous | 01/02/2024 | 60353 | ||
| GA | CE | 15 | 14 | 1 | Synchronous | 01/02/2014 | 64735 | |
| IN | CE | 15 | 14 | 1 | Classroom | 04/10/2015 | ||
| KY | CE | 15 | 14 | 1 | Classroom | 05/31/2025 | 06/30/2026 | |
| KY | CE | 15 | 14 | 1 | Synchronous | 05/31/2025 | 06/30/2026 | |
| MA | CE | 15 | 14 | 1 | Classroom | 12/05/2025 | 11/13/2027 | 00120241 |
| MA | CE | 15 | 14 | 1 | Synchronous | 12/05/2025 | 11/13/2027 | 00120241 |
| MD | CE | 15 | 14 | 1 | Classroom | 01/01/2023 | 12/31/2026 | |
| MO | CE | 14 | 14 | Classroom | 07/01/2024 | 06/30/2026 | ||
| MO | CE | 14 | 14 | Synchronous | 07/01/2024 | 06/30/2026 | ||
| MS | CE | 7 | 7 | Classroom | 05/27/2024 | 05/26/2026 | MAB# 49648 | |
| MS | CE | 7 | 7 | Synchronous | 05/27/2024 | 05/26/2026 | MAB#: 49648 | |
| MT | CE | 15 | 14 | 1 | Classroom | 06/19/2023 | 04/28/2026 | REA-CEC-REC-16714 |
| MT | CE | 15 | 14 | 1 | Synchronous | 06/19/2023 | 04/28/2026 | REA-CEC-REC-16714 |
| NC | CE | 14 | 14 | Classroom | 01/01/2026 | 12/31/2026 | 3005 | |
| NC | CE | 14 | 14 | Synchronous | 01/01/2026 | 12/31/2026 | 3005 | |
| ND | CE | 15 | 14 | 1 | Classroom | 03/02/2022 | 03/02/2026 | CE-222023 |
| ND | CE | 15 | 14 | 1 | Synchronous | 03/02/2022 | 03/02/2026 | CE-222023 |
| NJ | CE | 15 | 14 | 1 | Classroom | 07/16/2025 | 07/16/2030 | 2025-3033 |
| NJ | CE | 15 | 14 | 1 | Synchronous | 07/16/2025 | 07/16/2030 | 2025-3033 |
| NM | CE | 14 | 14 | Synchronous | 07/19/2023 | 05/26/2026 | 4274 | |
| NM | CE | 14 | 14 | Classroom | 07/19/2023 | 05/26/2026 | 4274 | |
| OK | CE | 14 | 14 | Classroom | 06/06/2023 | 06/02/2026 | 855 | |
| OK | CE | 15 | 14 | 1 | Classroom | 06/06/2023 | 06/02/2026 | 667 |
| OK | CE | 14 | 14 | Synchronous | 06/06/2023 | 06/02/2026 | 855 | |
| OK | CE | 15 | 14 | 1 | Synchronous | 06/06/2023 | 06/02/2026 | 667 |
| RI | CE | 14 | 14 | Classroom | 06/04/2025 | 06/04/2026 | REA.0002383-CE | |
| RI | CE | 14 | 14 | Synchronous | 06/04/2025 | 06/04/2026 | REA.0002383-CE | |
| SC | CE | 14 | 14 | Classroom | 09/01/2024 | 08/31/2026 | AC . 1103 | |
| SD | CE | 15 | 15 | Classroom | 02/21/2023 | 02/21/2026 | SD 1009 CE | |
| SD | CE | 15 | 15 | Synchronous | 02/21/2023 | 02/21/2026 | SD 1009 CE | |
| TX | CE | 14 | 14 | Classroom | 10/06/2025 | 09/30/2027 | 03067-ACE | |
| TX | CE | 14 | 14 | Synchronous | 10/06/2025 | 09/30/2027 | 03067-ACE | |
| VA | CE | 15 | 14 | 1 | Classroom | 11/19/2025 | 11/19/2027 | |
| VA | CE | 15 | 14 | 1 | Synchronous | 11/19/2025 | 11/19/2027 | |
| VT | CE | 14 | 14 | Classroom | 11/03/2025 | 11/03/2029 | CA-331778 | |
| VT | CE | 14 | 14 | Synchronous | 11/03/2025 | 11/03/2029 | CA-331778 | |
| WA | CE | 14 | 14 | Classroom | 03/26/2021 | 07/07/2026 | A23019778 | |
| WI | CE | 15 | 14 | 1 | Classroom | 05/12/2014 | 3950 | |
| WV | CE | 15 | 14 | 1 | Classroom | 04/22/2023 | 04/26/2026 | |
| WV | CE | 15 | 14 | 1 | Synchronous | 04/22/2023 | 04/26/2026 | |
| WY | CE | 15 | 14 | 1 | Classroom | 04/02/2022 | 04/01/2026 | 71 |
| WY | CE | 15 | 14 | 1 | Synchronous | 04/02/2022 | 04/01/2026 | 71 |