Productivity and Soft Skills

How to Create and Leverage Pivot Tables (Recorded Webinar) (W-CPE71)

Objective: This webinar demonstrates the power of pivot tables and the benefits of using them and then dives into how to create them, modify them and produce detailed information with little to no effort.

Pivot tables are a fantastic way of taking large data sets, such as client data, customer sales, staff information or stock type data and analyzing it meaningfully. This makes it easy to interpret what is happening and make decisions with confidence and ease.

Mention Pivot tables to those uncomfortable with Excel, and eyes glaze over. Establish knowledge of what pivot tables are and how to leverage them to produce professional reports in Excel without the need for complicated formulas or functions. This is a serious time saver!

Jump onboard and learn how to analyse large data sets. Great for those wanting to minimise the need for complex formulas or just make their data analysis less stressful!

What you will learn in this webinar:

- What is a pivot table?
- What are the benefits of using them?
- Easy ways to leverage Excel to create pivot tables
- Arranging and formatting pivot tables
- How to leverage pivot tables to produce a variety of reports quickly and easily
- How to add on elements such as slicers and pivot tables for further analysis
- What you need to do and know to automate the creation of common reports
- Workbook to practice what you have learnt.

User-friendly and jargon-free, this webinar is a MUST for anyone working with large amounts of data who are aiming to make sense of data without the need for complex or complicated formulas or functions.

Accreditation: TPB Compliant CPE Details/Format: Recorded Webinar Outcome/Learning: Master Pivot Tables to Increase Producti... Type: Structured Evidence of Completi...: Certificate CPE Hours: 1

  • Webinar Recording - How to Create and Leverage Pivot Tables
  • W-CPE71 - Pivot Tables Webinar Manual
Completion rules
  • All units must be completed
  • Leads to a certificate with a duration: Forever