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 Ronald L. Adler
Date: Aug. 20, 2026
By Dr. B. Lynn Ware
Date: Aug. 21, 2026
By Beverly Beuermann-King
Date: Aug. 24, 2026
By Deb Schaffer
Date: Aug. 24, 2026
By Ritu Arora
Date: Aug. 27, 2026
By Margie Faulk
Date: Sept. 1, 2026
By Ritu Arora
Date: Sept. 1, 2026
By Edwin Waldbusser
Date: Sept. 2, 2026
By Pete Tosh
Date: Sept. 3, 2026
By Carolyn Troiano
Date: Sept. 3, 2026
By Steven G. Meilleur
Date: Sept. 8, 2026
By William Mack Copeland
Date: Sept. 8, 2026
By Diane L. Dee
Date: Sept. 8, 2026
By Mark Schwartz
Date: Sept. 8, 2026
By Dev Strischek
Date: Sept. 10, 2026
By Dr. Sean Stein Smith
Date: Sept. 10, 2026
By Bruce Lee
Date: Sept. 11, 2026
By Allen Evitts
Date: Sept. 11, 2026
By Marcia Zidle
Recorded Session
By Marcia Zidle
Recorded Session
By Steven G. Meilleur
Recorded Session
By Mark Gorkin
Recorded Session
By Diane L. Dee
Recorded Session
By Diane L. Dee
Recorded Session
By Bruce Lee
Recorded Session
By Bruce Lee
Recorded Session
By Dr. Susan Strauss
Recorded Session
By William J. Rothwell
Recorded Session
By Erica Chisolm & Vanessa Hardiman
Recorded Session
By Paul Pelletier
Recorded Session
By Michael Healey
Recorded Session
By Ronald L. Adler
Recorded Session
By David Nettleton
Recorded Session
By Paul J. Cline
Recorded Session
By Audrey Halpern
Recorded Session
By David Nettleton
Recorded Session
By Carolyn Troiano
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Diane L. Dee
Recorded Session
