ANALYSING / VISUALISING PUPIL ATTAINMENT DATA WITH MICROSOFT® EXCEL® PIVOTTABLES AND PIVOTCHARTS (2-DAY COURSE)

for Schools and LEAs

ANALYSIS OF PUPIL ATTAINMENT DATA WITH MICROSOFT® EXCEL® PIVOTTABLE REPORTS (1-DAY COURSE)

Does your job involve the analysis of pupil attainment data to create reports summarising by Exam Grades / Gender / Subject / Teaching Group etc? Do you regularly use Excel to perform these tasks? Using PivotTables can save you vast amounts of time in your Excel work. Analyses that may take a week to perform manually in Excel can literally take minutes with PivotTables.

The course is extremely hands-on, with delegates following demonstrations and then working through tasks throughout the course, based on sample school attainment data. The course assumes that the delegate has a working knowledge of Excel. No previous PivotTable skills are required.

Delegates from schools and LEAs throughout the country have already benefited from attending previous deliveries of our Excel PivotTable courses and are now applying the skills in the workplace to save days of time in their analysis work.

Course Content

Introduction to PivotTable Reports

Creating a PivotTable

“Pivoting” a PivotTable

Structured Selection

Adding / Removing Fields in a Report

Refreshing PivotTable Data

Customising Fields

PivotTable Formatting

Grand Totals / Totals / Subtotals

Sorting PivotTable Data

Managing the Level of Detail
Custom Grouping
Displaying as Percentages
Summary

Booking Details

Please contact us if you need further information or to book a place on any of the courses we have on offer.

Back to Training

IntrepiData, Gear House, Saltmeadows Road, Gateshead, NE8 3AH, Tel 0191 478 2671, Email info@intrepidata.co.uk