Learn Excel Pivot Tables in 2 Hours with Dr. John Miko

After watch this video, students should be able to create a basic pivot table, name a pivot table, and gain a basic familiarity with the pivot table interface.

After this video exercise students will be able to create a Pivot Table with multiple dimensions utilizing both the column and rows areas. As well, students will understand the hierarchy inherent with some categories of data.

This lecture walks students through the process of adding multiple measures to a pivot table.

This is brief overview of a case study in which students are asked to apply their learning to date. The results that you arrive at can be utilized to answer the quiz that follows.

After this lecture, student will under that elements of design that go into formatting and presenting data in a pivot table.

In this video, students learn how to clear pivot tables and to move them from worksheet to worksheet. This can be very useful in building dashboards.

In this lecture video, students explore all of the statistical measures that can be applied to fields including: count, sum, average, min, and max.

In this video lecture, students learn how to show values as a percentage of a total.

In this lecture video, students learn how to sort by both measures and dimension and also refresh the contents of a pivot table.

In this lecture video, students learn several different filtering techniques.

In this video lecture, students learn how to implement and utilized the interactive Slicer tool for filtering.

In this video, the instructor reviews a case study assignment that has questions to be answered in the quiz that follows.

This video details various methods used to group both categorical and numerical fields in pivot tables.

This video details how to work with date fields in a pivot table and introduces another filter tool specifically designed for dates, the Timeline tool

This video detail how student can calculate new fields based on existing fields in a pivot table.

This video explores the creation of 4 different Pivot Chart types including the pie chart, the bar chart, the line chart, and the clustered column chart.

In this final video, we see how we can bring together multiple pivot tables and pivot charts to create a dashboard. The video also explains how to connect Slicers to multiple chart and tables.