Skip to Content (custom)

    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.


    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
    None
    Pricing Options
    Rate Full Price AI Price
    Standard
    Today thru 12/31/2050
    $145.00 $120.00