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