Webinar Details / Industries / Human Resources

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

  • Speaker: Tom Fragale
  • Duration: 60 Minutes
  • Available All Day

Training Options

Note: 20% discount applies to both options if selected.

$
= $

Mastering Pivot Tables and Charts in Excel

Overview

In this webinar, you will learn how to transform raw data into flexible, easy-to-use summary reports using Pivot Tables and Charts. We’ll start with the basics and progressively move to more advanced pivot table techniques.

Many people struggle to create Pivot Tables or may not fully understand their potential. This session will demonstrate that Pivot Tables are straightforward and powerful tools that can provide tremendous insights. We’ll then create Pivot Charts to visualize data, and add sorts, filters, slicers, and timelines to build a dynamic, interactive dashboard.

These techniques work across industries with any type of data, allowing you and your staff to become instantly more productive in Excel. You will be able to apply these skills immediately after the session.


Why You Should Attend

  • Process large amounts of data efficiently from multiple sources

  • Summarize data into meaningful reports quickly

  • Gain independence from IT staff for data analysis and reporting

  • Learn techniques that improve productivity and decision-making


Areas Covered in the Session

  • Creating and managing Pivot Tables

  • Changing calculation types and adding additional calculations

  • Creating custom calculations and multilayer reports

  • Generating daily, monthly, quarterly, and yearly summaries

  • Adding Pivot Charts for visual representation

  • Adding Slicers and timelines for interactive dashboards


Who Will Benefit

  • Banking Professionals

  • Finance Teams

  • Manufacturing Staff

  • Insurance Professionals

  • Pharmaceutical Industry Staff

  • Construction Industry Professionals

  • Entertainment Industry Professionals

  • Service and Hospitality Staff


Tom Fragale

Microsoft Certified Trainer,


Top-Watched Webinars



HIPAA 2024 Training for the Compliance Officer | Duration: 90 Minutes | Speaker: Brian L Tuttle | Rec. Price: $269 | Register Now

MASTER CMS MEDICARE PECOS 2.0: NEW ENROLLMENT & VALIDATION PORTAL | Duration: 60 Minutes | Speaker: Yesenia Servin | Rec. Price: $229 | Register Now

2024 SAMHSA (42 CFR Part 2) Updates and Changes | Duration: 60 Minutes | Speaker: Brian L Tuttle | Rec. Price: $229 | Register Now

Medicare Advance Beneficiary Notice (ABN): CMS Updated Rules and Guidelines | Duration: 60 Minutes | Speaker: DAVID VAUGHN | Rec. Price: $229 | Register Now

What will you get?

In Recording
  • Access of Recording
  • Additional Handout
  • Available on Desktop, Mobile & Tablet
In Digital Download
  • Access of Recording (Lifetime Access)
  • Additional Handout
  • Available on Desktop, Mobile & Tablet


100% Trusted

Trendy and up-to-date webinars.

Subscribe now to receive updates on upcomming webinars

High-End security, GDPR & HIPAA guidelines followed.