Microsoft Excel Pivot Tables Training

From £125 per person - businesses only

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

  • 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

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.