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
  • Formatting 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 audience Those who have a good understanding of spreadsheets who want to learn how to analyse and present data from large lists
Prior knowledge You must be familiar with the material covered in "Excel: Functions and cell referencing" first
Resources A course book must be purchased when you attend the course (included in the Cost below)
Software Excel 2010
Format Presentation with practical exercises
Where next? Excel: Analysing spreadsheet lists, external data and what-if analysis, "Excel: 3D formulae, charts and sharing data" and "Excel: Working with arrays, macros and VBA"
Taught using:
Windows XP

Course provider: IT Learning Programme


Frequency: Every term. Express an interest in future dates for this course.