The course covers a number of techniques for analysing data using filters to narrow down the data and sorting to arrange it. The course provides and opportunity to learn about presenting data visually using charts. The examples are all created in Excel 2013 but the concepts can be applied in other spreadsheets.
Subtotals and grouping data
Charting non-adjacent areas and filtered data
Advanced chart formatting
Creating histograms and using sparklines