[100% Free] Using pivot tables in Excel: HR Analytics in Practice

Perform data analysis by using pivot tables in MS-Excel and design data summaries for quick presentation.

What you'll learn

Understand basic pivot table elements
Prepare a simple dataset to get it ready for pivot tables
Create a simple pivot tables using the dataset
Run data analysis on pivot tables
Learn about additional features like nested fields and filters to create more complex summaries
Use these summaries to derive insights for decision making, HR analysis etc
Use formatting and layout options to make your tables presentable and easy to interpret