Ep 2. Analyzing Data by Using PivotTables

In season 4, episode 2 of Microsoft Excel 2016 - Training, viewers will learn about the powerful tool of PivotTables and how they can be used to analyze data. Hosted by a knowledgeable Excel trainer, the episode begins by introducing the concept of PivotTables, explaining that they can be used to quickly summarize large sets of data in a meaningful way.

After demonstrating how to create a PivotTable, the trainer walks viewers through the different ways one can manipulate the data within a PivotTable. For example, viewers will learn how to filter data by specific criteria, how to group data into categories, and how to drill down into the individual data points.

The trainer also covers several key PivotTable functions, including how to use calculated fields and calculated items to perform customized calculations on the data. For those seeking to work more efficiently, the episode shows how to use PivotTable timelines to filter data by date ranges and how to use slicers to quickly and easily drill down into subsets of data.

Throughout the episode, viewers are encouraged to follow along with the trainer and create their own PivotTables using the provided sample data. This hands-on approach helps viewers to understand how to use PivotTables in practical, real-world scenarios. By the end of the episode, viewers should have a solid understanding of how to create, manipulate, and customize PivotTables to analyze data in Excel 2016.

Whether one is a beginner or an experienced Excel user, this episode of Microsoft Excel 2016 - Training provides valuable insights and practical knowledge on how to master PivotTables and use them to make sense of even the most complex sets of data.