Excel Pivot Tables for HR Professionals
Duration: 60 Minutes
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.
- Why Excel ®?
- What are pivot tables?
- How to create pivot tables
- Data mining using pivot table
- Best practices
- Data normalization
- Conclusion
- 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
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.
- HR professionals at all levels.
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
By Margie Faulk
Date: July 1, 2026
By Edwin Waldbusser
Date: July 3, 2026
By Carolyn Troiano
Validation of FDA-Regulated Medical Device and SaMD Products Using AI, ML, and LLMs, such as ChatGPT
Date: July 3, 2026
By Diane L. Dee
Date: July 6, 2026
By Paul J. Cline
Date: July 7, 2026
By Steven G. Meilleur
Date: July 7, 2026
By Margie Faulk
DOL Reverses Course on Independent Contractor Rule for 2026! How Will Employers Adapt to the Change?
Date: July 8, 2026
By Beverly Beuermann-King
Date: July 8, 2026
By Deb Schaffer
Date: July 9, 2026
By William J. Rothwell
Date: July 9, 2026
By Allen Evitts
Date: July 10, 2026
By Bruce Lee
Date: July 10, 2026
By Bruce Lee
Date: July 13, 2026
By William Mack Copeland
Date: July 14, 2026
By David Nettleton
Date: July 14, 2026
By Mike Thomas
Date: July 15, 2026
By Dev Strischek
Date: July 15, 2026
By Karla Brandau
Date: July 15, 2026
By Dr. Susan Strauss
Date: July 15, 2026
By Mark Schwartz
Date: July 16, 2026
By Mark Gorkin
Date: July 16, 2026
By Sonja Pasquantonio
Date: July 20, 2026
By Ronald L. Adler
Date: July 20, 2026
By Michael Healey
Date: July 21, 2026
By Marcia Zidle
Date: July 30, 2026
By Marcia Zidle
Recorded Session
By Marcia Zidle
Recorded Session
By Audrey Halpern
Recorded Session
By David Nettleton
Recorded Session
By Dev Strischek
Recorded Session
By Diane L. Dee
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Carolyn Troiano
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Marcia Zidle
Recorded Session
By Beverly Beuermann-King
Recorded Session
By Diane L. Dee
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Mark Gorkin
Recorded Session
By Paul Pelletier
Recorded Session
By Cathy Horwitz
Recorded Session
By Pete Tosh
Recorded Session
By Melveen Stevenson
Recorded Session
By Bob Verchota
Recorded Session
By Don Phin
Recorded Session
By Melveen Stevenson
Recorded Session
By Richard E Cascarino
Recorded Session
By Paul J. Cline
Recorded Session
By Mike Thomas
Recorded Session
