Courses & Seminars

ASFMRA is an internationally recognized leader in appraisal training. We are a not-for-profit appraisal society and sponsoring member of the Appraisal Foundation providing education since 1929 and serving all jurisdictions in the United States. We provide Appraisal Qualifications Board (AQB) and state approved appraisal training for certified general licensure and for continuing education.

The ASFMRA offers specialized seminars such as Yellow Book, Valuation of Conservation Easements, Timber Property, Mineral Rights, Dairy Appraisal and a lot of other topics. Take a look at the seminars to see what we offer, then take a look at our education schedule to see what is being offered near you! If you have any questions you can contact Deanna Ilk at 303-692-1222 or dilk@asfmra.org

Using Excel in Specific Appraisal Applications

Target audience: Appraisers, Farm Managers

For the beginner to advanced user, this seminar will move attendees from basic spreadsheet concepts to advanced analytical techniques. Everyone will pickup hints and techniques for adding graphics, formatting and debugging. Participants will be able to use Excel appropriately in each of the approaches and gain objective mathematical tools for adjustments. Appraisers and managers will learn to compare sales using soils data land-use mix and building mix through automated scoring. LAPTOP REQUIRED 
Beginner concepts include vocabulary, user interface, and generating functions and formulas.

Intermediate concepts will cover absolute and relative references, filtering, named range references, importing from outside sources and exporting data to other programs.

Advanced concepts will examine grouping and outlining, pivot tables and What-If Analysis.

Contact hours: 8 hours