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!

1-to-1 instructor-led training

Our 1-to-1 training sessions can be customised to cover core topics - learn what you need to know!

Training times are flexible - training can be delivered all in 1 day, or over shorter sessions (eg lasting 1 or 2 hours).

Remote learning and in-person training

Training can be delivered remotely using Microsoft Teams. We can also provide in-person training sessions at our Aberdeen Training Centre or onsite at client business premises subject to location.

Requirements

You'll need a good working knowledge of using Microsoft Excel. To complete the course online you’ll need a Windows PC installed with Microsoft 365 (if you don’t have Microsoft 365 you can download a free trial for 1 month).

Notes

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

Certification

You’ll receive an eCertificate of Attendance confirming the number of instructor-led training hours.

Funding Opportunities

If you live in Scotland you could be eligible to apply for funding to pay for the course with an SDS Individual Training Account (ITA) from Skills Development Scotland.

You can apply for ITA funding if you are 16 or over and you are:

– unemployed and on benefits

– not working and have no income

– employed with an annual income less than £22,000

– self-employed with an annual income less than £22,000

You will not be eligible to apply for ITA funding if you are in education or involved in any other SDS funded programme.

FAQs

Q: I am currently on benefits, will I be able to apply for ITA funding?

A: Yes

Q: I have no income but my partner/husband/wife works, will I be able to apply for ITA funding?

A: Yes

Q: I am self-employed and earn less than £22,000 per annum, will I be able to apply for ITA funding?

A: Yes

Q: I am employed and earn less than £22,000 per annum, will I be able to apply for ITA funding?

A: Yes

Q: How do I apply for ITA funding?

A: Complete an online application on the My World of Work website.

Online 4 Hour Instructor-led Course – Apply for Funding

Aberdeen 4 Hour Instructor-led Course – Apply for Funding

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

Working with PivotTables

Training Course

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

Our 1-to-1 training sessions can be customised to cover core topics - learn what you need to know!

Training times are flexible - training can be delivered all in 1 day, or over shorter sessions (eg lasting 1 or 2 hours).

Remote learning and in-person training

Training can be delivered remotely using Microsoft Teams. We can also provide in-person training sessions at our Aberdeen Training Centre or onsite at client business premises subject to location.

Requirements

You'll need a good working knowledge of using Microsoft Excel. To complete the course online you’ll need a Windows PC installed with Microsoft 365 (if you don’t have Microsoft 365 you can download a free trial for 1 month).

Notes

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

Certification

You’ll receive an eCertificate of Attendance confirming the number of instructor-led training hours.

Funding Opportunities

If you live in Scotland you could be eligible to apply for funding to pay for the course with an SDS Individual Training Account (ITA) from Skills Development Scotland.

You can apply for ITA funding if you are 16 or over and you are:

– unemployed and on benefits

– not working and have no income

– employed with an annual income less than £22,000

– self-employed with an annual income less than £22,000

You will not be eligible to apply for ITA funding if you are in education or involved in any other SDS funded programme.

FAQs

Q: I am currently on benefits, will I be able to apply for ITA funding?

A: Yes

Q: I have no income but my partner/husband/wife works, will I be able to apply for ITA funding?

A: Yes

Q: I am self-employed and earn less than £22,000 per annum, will I be able to apply for ITA funding?

A: Yes

Q: I am employed and earn less than £22,000 per annum, will I be able to apply for ITA funding?

A: Yes

Q: How do I apply for ITA funding?

A: Complete an online application on the My World of Work website.

Online 4 Hour Instructor-led Course – Apply for Funding

Aberdeen 4 Hour Instructor-led Course – Apply for Funding

Related products

Microsoft Outlook Intermediate User

Microsoft Excel Intermediate User Demo lessons

Microsoft Excel Basic User Demo lessons

Microsoft Excel Basic 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."