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

Related Courses

 

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.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA Affiliate of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

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 165 £165 2020-01-03
Midlands Birmingham1 165 £165 2020-02-07