Brief Session Description
Many assessors use Excel on a daily basis, but may not use its full potential. This presentation highlights some of Excel’s most useful, yet underutilized, features. This fast–paced session highlights how assessors/appraisers can quickly analyze data using data models, PivotTables and PivotCharts, autofill appraisal grids using the VLOOKUP function, and how to design custom dashboards to track their key performance indicators.
Presentation Category
Assessment Technology
Audience Expertise
General Interest (Appropriate for all experience levels.)
Start Date
8-31-2016 1:00 PM
End Date
8-31-2016 2:30 PM
Excel Can Do That? From Pivot Tables to Dashboards
Many assessors use Excel on a daily basis, but may not use its full potential. This presentation highlights some of Excel’s most useful, yet underutilized, features. This fast–paced session highlights how assessors/appraisers can quickly analyze data using data models, PivotTables and PivotCharts, autofill appraisal grids using the VLOOKUP function, and how to design custom dashboards to track their key performance indicators.
