Spreadsheets: Organising and displaying data

  • Excel Icon course pack | Publicly viewable | v. 2013

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.

Filtering data

Subtotals and grouping data

Charting non-adjacent areas and filtered data

Advanced chart formatting

Creating histograms and using sparklines