Description

Excel is a very powerful tool for quickly and easily manipulating and analysing large amounts of numerical data. It is perfect for analysing class marks, departmental marks, attendance figures, etc.
This guide will take you through the process of using a workbook containing the Maths GCSE results from a department in a secondary school which contains about 200 entries. This size of spreadsheet makes it difficult to summarise data. You will use several techniques to summarise the data: a simple subtotal and group and outline, using a summary worksheet and using a pivot table. Later you will apply the skills learned in a much larger worksheet of about 1500 entries with whole school GCSE results. Although this spreadsheet is much larger, the skills are exactly the same.

Content:

1. Use Subtotals
2. Use Group and Outline
3. Use multiple worksheets
4. Build formulae across worksheets
5. Create a pivot table
6. Amend a pivot table to show different views
7. Copy and paste a pivot table
8. Amend a pivot table to show different measurements
9. Create a pivot chart
10. Use pivot table information in a different context

Level: Intermediate users

Audience: All education staff

Pre Skills:

1. Competence with a recent version of Windows
2. Competence with Excel 2007: Enhancing the appearance of your spreadsheet and Excel 2007: Using charts and graphs

Hardware: Personal computer (PC)

Software: Microsoft Excel 2007