Microsoft Excel Pivot Tables

Duration: 
1 days

Overview

This 2-hour Pivot Table webinar 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. You connect live with our trainer.

Audience

Each participant will leave with a recognised certificate

Course Outline

  • By the end of this webinar you will know how to:
  • 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

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Midlands
Birmingham1 750 £750 2019-10-04
Edinburgh
Edinburgh1 750 £750 2019-10-04
Bristol
Bristol1 750 £750 2019-10-04
Devon
Exeter1 750 £750 2019-10-04
Midlands
Birmingham1 750 £750 2019-12-06
Edinburgh
Edinburgh1 750 £750 2019-12-06
Bristol
Bristol1 750 £750 2019-12-06
Devon
Exeter1 750 £750 2019-12-06