# Excel Tutorial Videos 03

## Generate GetPivotData

If you are trying to link to a pivot table cell, you might have problems. For example, when you type an equal sign, then click on a cell in a pivot table, you may see a GETPIVOTDATA formula, instead of a cell reference. In this pivot table tutorial video, you'll see how to work around that problem, and learn how to prevent the problem from occurring.

You'll add the Generate GetPivotData button to a toolbar, to turn this feature off. By customizing the toolbar, you can turn the feature on again, if you need it, or leave the Generate GetPivotData feature turned off.

For written instructions for this Excel tutorial, see: Generate GetPivotData

## Increase Numbers by a Set Amount with Paste Special (Excel 2003)

In Excel 2003, you can increase or decrease all the numbers in a range by a specific amount. For example, in a price list, all the prices could be increased by \$1.50, or the prices could be decreased by 5%.

The technique shown in the following video makes it easy to increase the prices on the worksheet, all at once, by using the Paste Special command on the Excel menu bar. You'll type a value into a cell, then copy that cell, and apply its value to other cells.

For written instructions for this Excel tutorial, see: Increase Numbers

## Increase Numbers by a Set Amount with Paste Special (Excel 2007)

In Excel 2007, you can increase or decrease all the numbers in a range by a specific amount. For example, in a price list, all the prices could be increased by \$1.50, or the prices could be decreased by 5%.

The technique shown in the following video makes it easy to increase the prices on the worksheet, all at once, by using the Paste Special command on the Excel Ribbon. The technique is similar to the steps in the previous video, for Excel 2003, but the command is in a different location. You'll type a value into a cell, then copy that cell, and apply its value to other cells.

For written instructions for this Excel tutorial, see: Increase Numbers

 Excel Tutorial Videos 01 Excel Tutorial Videos 02 Excel Tutorial Videos 03 Excel Tutorial Videos 04 Excel Tutorial Videos 05 Excel Tutorial Videos 06 Excel Tutorial Videos 07 Excel Tutorial Videos 08  Excel Tutorial Videos 09  Excel Tutorial Videos 10     Excel Tutorial Videos 11     Excel Tutorial Videos 12