Microsoft Office Tutorials and References
In Depth Information
Creating a recommended PivotTable
Creating a recommended PivotTable
Excel workbooks enable you to store and summarize large data
collections effectively. As versatile as Excel tables and
formulas are, they are static. After you create a data arrangement
or summary in a standard worksheet, you can change it only
by copying, pasting, or moving your data and altering your
formulas. You can extend those capabilities by creating
PivotTables. PivotTables are powerful and versatile tools that let you
rearrange, sort, and filter your data dynamically, without editing
your data or changing any formulas.
Create a recommended PivotTable
1 Click any cell in the Excel table or data list that you want to
summarize.
2 Click the Insert tab.
3 Click Recommended PivotTables.
4 Click the PivotTable that you want to create.
5
1
3 2
Click OK.
4
5
Search JabSto ::




Custom Search