Contextures

Excel Pivot Table Videos

Short videos show how to clear old items from a pivot table, change pivot table layout, and more tips.

Clear Old Items from a Pivot Table

If you change the data in the pivot table source, items that were previously in the source might be no longer included. For example, some employees might leave the company, and the names of their replacements would be entered in the source table.

This video tutorial shows how you can change a pivot table option to prevent the old items from appearing in the pivot table drop down lists, for Excel 2007.

For written instructions for this Excel tutorial, see: Change Retain Items Setting

Excel Pivot Table Layout

The default setting for pivot tables is to show all the row labels in the same column. You might prefer a different layout, with each row label was in a different column.

In this video tutorial, you'll see how to change the pivot table layout, so each Row Label is in a separate column.

Selecting Sections of a Pivot Table

You can use the Selection Arrow to highlight specific sections of a Pivot Table. Before the Selection Arrow can work correctly, you might have to turn on the Enable Selection feature.

In this video tutorial, you'll see how to enable selection and use the Selection Arrow. For written instructions, see: Pivot Table Selection

Add Running Totals to a Pivot Table

With running totals you can show accumulated amounts over time. For example, you could calculate company sales for the year, over all twelve months.

To show running totals, you'll u se the Custom Calculation feature in Excel's pivot tables, as shown in this video tutorial.

For written instructions for this Excel tutorial, see: Pivot Tables -- Running Totals

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search

Search Contextures Sites

More Videos

Excel Videos - Index

Pivot Table Tips

Pivot Table Groups and Filters

GetPivotData

Data Entry Tips

Names, Macros, Numbers

Data Validation Videos

Search Contextures Sites

 

Excel Tools Add-in

 

Free Pivot Table Tools

 

 

Excel Data Entry Popup List

 

 

 

Last updated: February 27, 2017 3:59 PM
Contextures RSS Feed