Search Contextures Sites
Custom Search

 

More Excel Videos

Excel Videos - Index

Pivot Table Tips

Pivot Table Groups and Filters

GetPivotData

Data Entry Tips

Names, Macros, Numbers

 

 

 

 

 

 

 

 

 

 

Excel Videos - Pivot Tables

Excel videos show how to clear old items from a pivot table, change pivot table layout, add running totals, and more.

Clear Old Items from a Pivot Table in Excel 2007 

Excel 2007 Pivot Table Layout 

Selecting Sections of an Excel Pivot Table

Add Running Totals to an Excel Pivot Table 

More Excel Videos

Clear Old Items from a Pivot Table in Excel 2007

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 2007 Pivot Table Layout

The default setting for pivot tables in Excel 2007 is to show all the row labels in the same column. You might prefer the layout from previous versions, where each row label was in a different column.

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

Selecting Sections of an Excel Pivot Table

You can use the Selection Arrow to highlight specific sections of an Excel 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 for this Excel pivot table tutorial, see: Pivot Table Selection

Add Running Totals to an Excel 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

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 


MVP Logo
Debra Dalgleish

Last updated: May 29, 2016 6:30 PM