Courses and resources

Excel 2007: PivotTables

Description

What is it about?

Pivot Tables allows you to organise and summarise large amounts of data by filtering and rotating headings around your data.

This course also shows you how to create Pivot Charts.

What will I get out of it?

1/ Examples of PivotTables.

2/ Creating a PivotTable.

3/ Rearranging Data in a PivotTable.

4/ Updating a PivotTable.

5/ Summarising Data in different ways.

6/Calculated Fields and Calculated Items.

7/ Formatting Data.

8/ Changing Display Options.

9/ Creating Pivot Charts.

Is there anything I need to do before attending?

Participants should have a good working knowledge of formulae and navigating around Excel.

Learning Provider: This course is administered by Staff Learning & Development, please contact Carol Fal ( C.L.Fal@exeter.ac.uk ) for any queries.

This course occurs on the following dates

Date	Location	Start	Finish	Cost	Trainer(s)	Places
27/02/2013	Streatham: Queen's, Room M (PC Cluster)	13:30	16:00	Free, but on late cancellation your department will be charged up to £50	Carol Fal	3
01/05/2013	Streatham: Queen's, Room M (PC Cluster)	09:30	12:00	Free, but on late cancellation your department will be charged up to £50	Carol Fal	11
13/06/2013	Streatham: Queen's, Room M (PC Cluster)	13:30	16:00	Free, but on late cancellation your department will be charged up to £50	Carol Fal	9
16/07/2013	Streatham: Queen's, Room M (PC Cluster)	09:30	12:00	Free, but on late cancellation your department will be charged up to £50		11

Book