Contextures

Excel Videos - 03

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

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 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

More Videos

Excel Videos Index

Data Entry Tips

Pivot Tables

Mouse Shortcuts

Pivot Table Tips

Pivot Table Groups and Filters

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 Contextures Sites

 

Free Pivot Table Tools

 

 

 

Last updated: December 29, 2016 4:16 PM
Contextures RSS Feed