Skip to main content

Excel: Data Analysis

Data Analysis

You can sort data, including multiple levels of sorting (state, then city for example), and you can sort by format or color. Filters allow you to quickly look at parts of your data and collect subtotals; they are also an excellent tool for data cleaning and validation. Pivot tables provide automation of higher-level analysis, answer "what-if" questions, and help you to make sense of your data.

Workshop Materials

These materials were used in previous Excel Data Analysis workshops.  With them, you can learn how to use Excel to extract meaning from data, bring in data from webpages, convert and format data in automated ways, look at ways to make data cleaner and more reliable, graph trends, and find meaning in masses of numbers.