Location
Capital University Center Auditorium
Start Date
12-10-2017 3:00 PM
Description
This session will use the spreadsheet that contains the 2015 Small Area Health Insurance Estimates for all counties and states of the United States to demonstrate several functions and tools in EXCEL for data tabulation, analysis, and presentation. The functions and tools include advanced sorting, filtering, and pivot table. The session will also include a demonstration of using graphic tools in EXCEL to present the data. Data visualization is a simple tool for sharing a dataset's story with an audience, no matter what their background. Trends and population percentages are just two items that can be creatively displayed in EXCEL. We'll learn how to create the visualizations that can help take presentations to the next level.
Data Visualization Handout
Vina_EXCEL Pivot Table.zip (10797 kB)
Zip file containing Pivot Table Materials
Shuang Li_EXCEL Sort.zip (18364 kB)
Zip file containing SAHIE materials
Included in
EXCEL Advanced Tips and Tricks: Filter, Data Sort, Pivot Table, and Graphics
Capital University Center Auditorium
This session will use the spreadsheet that contains the 2015 Small Area Health Insurance Estimates for all counties and states of the United States to demonstrate several functions and tools in EXCEL for data tabulation, analysis, and presentation. The functions and tools include advanced sorting, filtering, and pivot table. The session will also include a demonstration of using graphic tools in EXCEL to present the data. Data visualization is a simple tool for sharing a dataset's story with an audience, no matter what their background. Trends and population percentages are just two items that can be creatively displayed in EXCEL. We'll learn how to create the visualizations that can help take presentations to the next level.