Microsoft Excel Pivot Tables – Online Excel Training Course

Book this course

Course description

Microsoft Excel’s pivot table function is an essential tool that allows you see the ‘bigger picture’ – quickly and easily summarising, analysing, and presenting large amounts of data.

We show you all the basics of the pivot table function, showing you how it works and how it can help you. Learners are encouraged to participate in the session by asking questions, and we’ll be here to give you support via telephone, email or Twitter for 90 days after the programme finishes.

Is it right for me?

If you’re an Excel user who wants to learn how to use the pivot table function to organise data, or you want to refresh your existing knowledge, this online Excel training course will enable you to achieve that.

What will I get out of it?

By the end of the course you will be able to:


  • How pivot tables work
  • How to create and modify your pivot table structures
  • How to change the summary calculation used to analyse your data
  • How to use report filters
  • How to group data
  • How to sort data
  • How to create a pivot chart

Excellent trainer delivering the course in a friendly and professional manner. Good explanations and excellent knowledge of product.

Team Manager, Scotia Gas Networks

What does it cover?

  • How pivot tables work
  • Working with the pivot cache
  • Building the structure to your pivot table
  • Modifying the structure
  • Creating report filters
  • Refreshing data
  • Single VS multiple pivot caches
  • Changing the summary calculation method
  • Adding subtotals
  • Simple sorting
  • Advanced sorting
  • Grouping data in a pivot table
  • Grouping dates
  • Grouping numbers
  • Creating a pivot chart
  • Modifying a pivot chart

Book this course

Course leader

Richard Harker

Technical & Digital Learning Consultant

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Recent blog posts

Developing Strategic Leadership

It doesn’t matter how long you’ve been in a leadership role, there is always something new to learn...

Tweets
Press Coverage

Supporting the agents of change

Change is scary, at least for a lot of people it is. It creates uncertainty and a sense of unease, especially when it’s sudden or not handled correctly...

Enhance Magazine