Course Details and Schedule

As a data analysis tool it is hard to see past pivot tables. Come and see how easy it is to create multiple views, calculated fields and items just by dragging and dropping. Want to create a pivot chart from an external data source or filter data with Slicers? Easy.

See below for course schedule

Key topics
  • Structuring your data
  • Creating a pivot table
  • Formating a pivot table
  • Creating a pivot chart
  • Grouping data
  • Adding calculated fields
  • Adding calculated items
  • Filtering data with Slicers
  • Using external data
Course information
Intended audienceThose who have a good understanding of spreadsheets who want to learn how to analyse and present data from large lists
Prior knowledgeYou must be familiar with the material covered in "Excel: Functions and cell referencing" first
ResourcesA course book and text book must be purchased when you attend the course (see the Cost below)
SoftwareExcel 2010
FormatPresentation with practical exercises
Where next?Excel: Lists and querying data, "Excel: 3D formulas, charts, histograms and securing your data" and "Excel: Arrays, macros and VBA"
Taught using: 
Windows XP

 Course provider: IT Learning Programme

Schedule
Booking normally opens 30 days before the course begins.
Commences Dates Time Sessions Cost Location Status
7th week Monday 3 June 14:00-17:00 1 6.00 IT Services, 13 Banbury Road waiting list Add to basket

Can't make any of these dates? Express an interest in future dates for this course.

Frequency: Every term.