Excel Pivot Table Webinar

What you will learn

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.

Prerequisite

No previous experience of using Pivot Tables is required before attending this webinar.

Date and time: Once you have completed purchasing a booking, we will send an email to arrange a suitable time and date for this online course, including your booking confirmation and joining instructions.

You are asked to join the meeting 5 minutes before start time to ensure a prompt start.

Can't find the course you're looking for? Please enquire about our range of virtual classroom courses.

If booking 2 people, please add the quantity in your cart.

If booking 3 or more people, get in touch for a quote.

Price: £82


If you have any questions, please complete our enquiry form.

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 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 differences in 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