This workshop is for users who are familiar with entering data into Excel and have a basic knowledge of mathematical formulas and functions or have successfully completed part 1 of our Excel workshop programme.

Discover how pivot tables can make work tasks easier and more useful in analysing data.

Excel's Pivot Table feature is an incredibly powerful tool that makes it easy to tabulate and summarise data in your spreadsheets, particularly if your data changes a lot.

If you are finding yourself writing lots of formulas to summarise data in Excel (using functions such as Sumif and Countif) then using Pivot Tables would greatly improve your productivity and provide insights into data patterns that are otherwise too difficult to discover.

Pivot tables work best with large amounts of data. So while you might look at the data in the table above and think "I could summarise that quickly by hand or with a few clever formulas", the likelihood is that it would all get too much - and would certainly take too long to do by hand.

Areas Covered

• What is a Pivot Table
• Preparing your data for pivot table analysis
• Designing a Pivot Table
• Creating a Pivot Table in Excel
• Modifying a Pivot Table
• Grouping data
• Expanding and collapsing grouping
• Creating filters
• Creating slicers
• Linking with data and updating
• Creating Pivot Charts
• Manipulating Pivot Charts

The IT Learning Centre team provides a programme of IT related workshops to help you develop essential computing skills which will be invaluable during your time at the University and in the workplace.  Each semester we publish a new programme of workshops which are free of charge for students and staff, they range from introductions for users with very little experience to more advanced topics.  If you are not sure which IT workshops you would like to attend, why not check out the workshops overview