Short videos show how to use the GetPivotData function, to pull values from a pivot table, or turn that feature off. Also, how to use Paste Special to increase the value in selected cells

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.

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

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