Excel spreadsheet of raw data table examples, restructuring of data, summarizing tables, and charts.
Exercise #1: Splitting column table, wrangling data, pivot tables, creating a groupings bar chart, and pie charts for each column grouping.
Exercise #2: Merging two tables using vlookup function.
Exercise #3: Descriptive analysis and creating and formatting a chart.
Excercise 4: Sorting a data table, use subtotals grouping by a variable, copying and pasting subtotals to a new sheet, produce a chart with a primary and secondary vertical axis.