Insert ->PivotTable 3. Try
This: Choose the data If you selected the entire
Monthly Sales sheet,
Excel will display the Table or Range: 'Monthly Sales'!$A:$H In words,
that means "name of your spreadsheet" ! "all of the data in Column A
through Column H." Try
This, Too: Where
do you want to place the new PivotTable report? The
choices are create a new PivotTable in a new worksheet or place it on an existing worksheet. Select:
New Worksheet. Click
OK. Keep
going...
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.3. Apply and manipulate PivotTables |
|
| |
