Webinar Details / Industries / Information Technology

Excel Pivot Tables

  • Speaker: Tom Fragale
  • Duration: 60 Minutes
  • Available All Day
Recommend to Colleague

Registration Fee for Training Options

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

Sub Total:
Discount:
0.00
Total ($):

Webinar Overview

In this session, you will learn how to transform raw data into flexible, easy-to-use summary reports with PivotTables and PivotCharts. We will start with the basics and progress to more advanced applications.

Many professionals either struggle to create PivotTables, don't fully understand their capabilities, or assume they are too difficult to master. In this webinar, I will demystify PivotTables—showing you what they are, how to use them, and how they can deliver powerful insights with ease. We'll then build PivotCharts to visualize the data, and incorporate sorting, filtering, slicers, and timelines to design an interactive, powerful dashboard. This dashboard will provide instant clarity and allow you to explore your data from every angle.

You and your team will immediately increase productivity in Excel. These skills are applicable across all industries and data types. The training is clear, concise, and actionable—you'll be able to apply what you learn directly to your own data right after the session.

Why You Should Attend

Today’s organizations manage vast amounts of data from numerous sources. The ability to quickly process and summarize this data into meaningful information is more critical than ever.

With many companies operating with leaner IT support, individuals are increasingly responsible for handling data themselves. This webinar will equip you with the skills to consolidate large datasets from multiple sources and turn them into insightful, professional reports.

Key Topics Covered

  • Creating and managing PivotTables

  • Changing calculation types

  • Adding built-in and custom calculations

  • Designing multi-layer reports

  • Creating daily, monthly, quarterly, and yearly summaries

  • Building PivotCharts

  • Implementing slicers and timelines for interactive dashboards

Who Will Benefit
Professionals in:

  • Banking

  • Finance

  • Manufacturing

  • Insurance

  • Pharmaceuticals

  • Construction

  • Entertainment

  • Service Industries

  • Hospitality


Tom Fragale

Microsoft Certified Trainer, and a Microsoft Certified Expert in Excel,


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: $97 | Register Now

Mastering Medicare ABNs: Updated CMS Rules and Compliance Strategies | Duration: 60 Minutes | Speaker: DAVID VAUGHN | Rec. Price: $99 | 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