Microsoft Excel Pivot Tables Training

Enquire today we have face to face and live online training available

What you will learn

This course looks at creating professional Excel reports.
Incorporating percentage analyses.
Difference from analyses and field calculations.
Add additional totals by grouping data, then finishes off with Pivot Charts and Slicers to build a user-friendly dashboard.

Skills you will gain

Microsoft Excel Tables Friendly

Shareable Certificate Earn a Cerfiticate upon completion
Face to Face or Live Online Start instantly and learn at your own schedule
Flexible Schedule Set and maintain flexible deadlines
Intermediate For those with working experience or likely to have completed foundation level training

This course consists of 11 lessons

Create a Pivot Table report and manage the report’s layout.

Extract data using Label, Value and report filters.

Insert and manage Slicers to filter data.

Generate additional subtotals by grouping both dates and numbers.

Output statistics using COUNT, MAX and AVERAGE functions.

Control Pivot Table number formatting.

Summarise numbers with percentage analyses.

Create a Difference From analyses to compare different sets of data.

Output tailored formula results using Calculated Fields.

Insert a Pivot Chart to visually represent report data.

Finish off with a user-friendly front-end dashboard control.

Enquire today

Download course details as a PDF

Frequently asked questions

“I came over especially for the training with Go Courses. It was tailored perfectly – lots of hands on training in a great London facility just off Leadenhall Court. Thank you.”

Qamar Rathore, Hoffman La Roche

“Great course, with some great content. Lots to take away and review, as well as some interesting insights from a very knowledgeable trainer. Will definitely look to attend further AWS training in the future.”

Mark Conabeare, Landmark Property

“We’ve purchased a range of cloud-based training courses from Go Courses – very accommodating in terms of price and scheduling classes.”

Graham Riddall, Home Office

Shareable on LinkedIn

You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.

Are you ready to begin learning exceptional new skills?

Call:
01225 308979

Email:
info@go.courses

Registered Office:
Go Courses Ltd.
10 Laura Place
Bath
United Kingdom
BA2 4BL

View on a map

Registered office: Go Courses Limited, 10 Laura Place, Bath, United Kingdom, BA2 4BL