Mastering Pivot Tables in Excel: A Quick Guide

If you want to streamline your data analysis and reporting process, Pivot Tables are a must-have skill for any Excel user. In this tutorial, you'll learn everything you need to know about Pivot Tables, from creating and customizing them to using them to summarize and analyze large data sets. By the end of this tutorial, you'll be a Pivot Table pro and ready to tackle even the most complex data analysis projects.

2. Timestamps:

0:00 - 0:11- Intro
0:11- 1:32 - How to make a Pivot Table
1:32 - 2:57 - Experimenting with Rows, Columns, and Values
2:57 - 4:08 - Hiding Rows in a Pivot Table
4:08 - 5:18 - Comparing two Columns in a Pivot Table
5:18 - 5:40 - Outro

3. Related Links:

4. Acknowledgement:

This video was prepared by the Center for Customer Insights and Digital Marketing at the College of Business Administration at California State Polytechnic University, Pomona.