EXCEL Advanced Tips and Tricks: Filter, Data Sort, Pivot Table, and Graphics
Wei Gu, Shuang Li · Open PRAIRIE (South Dakota State University) · 2017
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.