Summarising and displaying data using: pivot tables, pivot charts, subtotals, groups

Using skills, knowledge and understanding described in sections 8 Spreadsheets, 9 Modelling and 10 Database and file concepts of the AS Level subject content to analyse, interpret and display data to visually communicate information to users in a clear and efficient manner.

rotate data from columns to rows or vice versa, for example: TRANSPOSE