Microsoft Office Tutorials and References
In Depth Information
12. On the Quick Access Toolbar, click the Undo button.
Excel reverses the last change.
13. On the Design tab, in the Layout group, click Subtotals , and then click Show All
Subtotals at Bottom of Group .
Excel displays subtotals in the workbook.
14. Click the Package Summary sheet tab.
The Package Summary worksheet appears.
15. In cell C4 , type = , but do not press Enter.
16. Click the PivotTable sheet tab.
The PivotTable worksheet appears.
17. Click cell K32 , and then press Enter.
Excel creates the formula =GETPIVOTDATA(“Volume”,PivotTable!$A$3,”Year”,2010)
in cell C4.
Search JabSto ::

Custom Search