Microsoft Excel Pivot Tables Made Easy

Watch Microsoft Excel Pivot Tables Made Easy

  • 1969
  • 1 Season

These videos will show you how to create and manage Pivot Tables in Microsoft Excel. They are very step-by-step and easy to follow. These tutorials can be used in Microsoft Excel 2007, Excel 2010, Excel 2013, and Excel 2016.

Filter by Source
No sources available
Seasons
Adding a Filter at the top level and creating summary sheets on your Microsoft Excel Pivot Table
9. Adding a Filter at the top level and creating summary sheets on your Microsoft Excel Pivot Table
 
This video will show you how to add a Filter at the top level and create summary sheets on your Microsoft Excel Pivot Table. You can have more than field in your filter section . Its another way to filter the pivot table at the higher level. Then you can break out those filters into summary sheets in a few quick steps. This works in Microsoft Excel 2007, 2010, 2013, and 2016. video tutorial.
Adding Slicers, Timelines to your Excel Pivot Table to create a dashboard.
8. Adding Slicers, Timelines to your Excel Pivot Table to create a dashboard.
 
This video will show you to add Slicers, Timelines to your Excel Pivot Table to create a dashboard. A dashboard can be any combination of the Pivot Table, the Pivot Chart, the slicer and the timeline. The slicer and the timeline are new ways to do a filter on your Pivot Table , but they are more visual than the normal filter. This is a tutorial for Microsoft Excel 2007 2010, 2013, and 2016.
Adding a Chart to your Microsfoft Excel Pivot Table - Pivot Charts
7. Adding a Chart to your Microsfoft Excel Pivot Table - Pivot Charts
 
This video will show you to add a chart to your Pivot table . It is called a Pivot Chart. It has features of the Pivot Table and of a chart at the same time. It is a visual interpretation of the Pivot Table. It will also show you how to manage the Pivot Chart.This is an excellent tutorial for Microsoft Excel 2007, Excel 2010, Excel 2013, Excel 2016. Excel Pivot table tutorial for beginners.
Sorting and Filtering your Microsoft Excel Pivot Table
6. Sorting and Filtering your Microsoft Excel Pivot Table
 
This video will show you how to sort and filter the pivot table. It will show that you can either sort the columns or the rows. You can filter the fields that are on the pivot table, to display different combinations of data. This is an excellent tutorial for Microsoft Excel 2007, Excel 2010, Excel 2013, Excel 2016. Excel Pivot table tutorial for beginners.
Making a Daily, Monthly, Quarterly, or Annual summary report from your Excel Pivot Table
5. Making a Daily, Monthly, Quarterly, or Annual summary report from your Excel Pivot Table
 
This video will show you how to make a Daily, Monthly, Quarterly, or Annual summary report from your Excel Pivot Table. It will also show you how to add a date range into your pivot table. You can summarize the report by second, minute, hour, day, month, quarter, and year or any combination of one or more than one of these. This is a tutorial for Microsoft Excel 2007 2010, 2013, and 2016.
Adding levels of detail to your Pivot Table
4. Adding levels of detail to your Pivot Table
 
This video will show you how to add multiple layers of detail to your Excel Pivot table. You add multiple fields to the row section or to the column section. It will also show you how to adjust how the resulting subtotals appear, either at the top of the section or at the bottom of the section, or not at all.This is a tutorial for Microsoft Excel 2007, Excel 2010, Excel 2013, and Excel 2016.
How to Change the calculation type in your Pivot table
3. How to Change the calculation type in your Pivot table
 
This video will show you how to to change the calculation type in your pivot table. It will also show you how to have multiple calculations in your Pivot Table. Your choice include: Sun, Count, Average, Minimum, maximum, standard deviation, variance, percent of total, running total, ranking and more.This is a tutorial for Microsoft Excel 2007, Excel 2010, Excel 2013, and Excel 2016.
Getting a Drill Down from your Pivot Table
2. Getting a Drill Down from your Pivot Table
 
This video will show you how to create a drill down report from your Excel Pivot Tables. A drill down is where you can show the detail transactions that comprise a number that is on the Pivot table. This is an excellent tutorial for Microsoft Excel 2007, Excel 2010, Excel 2013, Excel 2016. Excel Pivot table tutorial for beginners.
Getting started with Pivot Tables
1. Getting started with Pivot Tables
 
This video will show you how to create Excel Pivot Tables. It will start with raw data , and in a few steps you will be well on your way to making your pivot table. It will also show you how to move your fields back and forth to create different Pivot Table reports. It will also show a great Pivot table feature called a Drill Down, and it will also show you how to show or hide the field list.
Description