Excel Pivot Tables for HR Professionals

Learn valuable insights and strategies from industry experts.

  • Expert-led Training
  • Industry Best Practices
  • Practical Implementation
  • Real-world Scenarios
Jay Carlson

Speaker: Jay Carlson

Download Brochure Set Reminder
HR Compliance Webinar Image
Date
13 July, 2026 (Monday)
Time
10:00 AM PDT | 01:00 PM EDT
Duration
60 Minutes

Overview

In this presentation, you'll learn how pivot tables fit into the world of analytics, earn what pivot tables are and how to create them, and even get an introduction to the next generation of pivot tables in Power BI.

Area Covered

  • An Introduction to Data Analysis
    •     A brief history
  • Why Pivot tables?
    • How pivot tables are used in data analysis
  • Pivot table basics
    • Creating a pivot table on a worksheet
    • Manipulating the data
  • Advanced pivot tables
    • Getting and transforming data
  • Meet the Power family
    • PowerPivot
    • PowerQuery
    • Power BI
  • Visualizations (aka Charts and graphs)
  • Pivot tables
  • Transforming and shaping data

Why Should You Attend

Excel is a powerful tool for analyzing data, including data mining. In this presentation, you’ll discover how to use pivot tables to see data in new and exciting ways. And data mining in Excel is not just for accountants. The tools in Excel can benefit HR professionals as well.

Who Will Benefit?

  • HR professionals at all levels.

Speaker

Jay Carlson More than 25 years of experience in the IT industry and 20 years as a technical writer, including working as the technical lead at a top software company supporting their financial software
•    Co-author of OfficeFest 2007, a self-published series of training modules that includes Using Microsoft® Excel® for Financial Analysis, Microsoft® Excel® Pivot Tables and Charts, as well as Visual Basic for Applications in Microsoft® Excel® 2007
•    SQL and iPhone® developer
•    Google Data Analytics, Six Sigma, MCSE, MCDBA, ITIL, and SCRUM certified
•    Southern Illinois University B.S. Administration of Justice
•    University of Montana M.S. Public Administration with an emphasis in finance
•    Grays Harbor College A.A. Journalism

•    Excel
•    SQL
•    Statistics
•    Technical Writer

Upcoming Webinars

View All Webinars