For the beginner to advanced user, this seminar will move attendees from basic spreadsheet concepts to advanced analytical techniques. Everyone will pick up 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. This course qualifies for 8 hours of Professional Continuing Education Credits.
Laptop and thumb drive 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 Analyses
Instructor: Ann M. Roehm
Cannon, Lechtenberg & Associates, Inc., Hutchison, KS
Fees: $225.00 for ASFMRA Members, $300.00 for non-Members (Does NOT include lunch) (Add $35 for registration received after August 4.)