Microsoft Excel – Working with PivotTables

Training Course

This tutor-led course will show you the tools and techniques to effectively work with PivotTables in Microsoft Excel.

We'll start by looking at basic PivotTable features, and then show you how to quickly create PivotTables and PivotCharts from scratch. You'll learn various useful tools that you'll be able to put into practice in your job. We'll end the workshop showing you how to insert user-friendly buttons and create a basic interactive dashboard!

Learn online or face-to-face

1-to-1 training can be delivered remotely using Microsoft Teams, or face-to-face at our Aberdeen Training Centre. We can also provide onsite training at business premises, subject to location – please contact us for a quote.

Customised training

Training sessions can be customised to cover specific topics – learn what you need to know!

Flexible training times

Training times are flexible – training can be delivered all in 1 morning or afternoon, or over a period of time (eg 1 hour a week).

User-friendly notes

If you attend a face-to-face course you’ll receive a printed training manual. For remote courses we’ll send you a PDF manual.

Requirements

You’ll need some existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Basic User course.

What did others think of this course…

"I only knew old school way. Kelvin taught me new and easier ways to do things. He also showed me functions that I did not know existed. Was very interesting and I learned a lot."

Deborah Anne Dennis

"The course was excellent, I have learned a lot. I enjoyed the pace of the course and Kelvin was good at answering any questions or repeating anything that needed."

Paula Lovie

"Good course. Good teacher. V enjoyable."

Craig Gillon

Microsoft Excel – Working with PivotTables

Training Course

This tutor-led course will show you the tools and techniques to effectively work with PivotTables in Microsoft Excel.

Related products

Microsoft Excel Intermediate User

EC-PC Digital Skills for Work

Microsoft Excel – Working With Data

Microsoft Word Intermediate User

"I only knew old school way. Kelvin taught me new and easier ways to do things. He also showed me functions that I did not know existed. Was very interesting and I learned a lot."

"The course was excellent, I have learned a lot. I enjoyed the pace of the course and Kelvin was good at answering any questions or repeating anything that needed."

"Good course. Good teacher. V enjoyable."