Explore Contact us

What you will learn

  • This 3 hour Pivot Table live online 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

  • Shareable Certificate Earn a Cerfiticate upon completion
  • On Demand or Face to Face 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  
  • English Subtitles: English

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.

Show more

Frequently asked questions

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

Find us at:
Go Courses Ltd.
Kemp House
152 - 160 City Road
London
United Kingdom
EC1V 2NX

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

View on a map

Delighted satisfaction rating