Categories
data analysis quantitative data

Excel Pivot Tables and Charts

In an effort to explore and better understand different sets of data from several evaluation projects, I finally was moved to learn about the functionality of PivotTables and PivotCharts inside of Microsoft Excel.

Having reviewed many comments for a number of YouTube videos, I selected and watched the following four. Their combined 60 minutes provided a great overview, basic understanding of structuring and using pivot tables, creating pivot charts, and assembling various pivot charts to create a dynamic dashboard able to provide insightful observations of your Excel data. I hope you find them useful and look forward to your feedback.

After viewing these and working with your own project data, use the “Discuss on Twitter” button below to share any other resources you’ve found helpful in your path to learning and using pilot tables, pivot charts, and data slicers.

In this first video, you’ll get a great overview of pivot tables by Kevin Stratvert.
In this second video, you’ll engage in the first of a series of 3 videos by Jon Acampora.
In this third video, you’ll engage in the second of a series of 3 videos by Jon Acampora.
In this fourth video, you’ll engage in the third of a series of 3 videos by Jon Acampora.