ACCT 300: Charts
ACCT 300 – Pivot Table and Pivot Charts step by step instructions
A pivot table is a special type of summary table that’s unique to Excel. Pivot tables are great for summarizing values in a table because they do their magic without making you create formulas to perform the calculations. Pivot tables also let you play around with the arrangement of the summarized data. It’s this capability of changing the arrangement of the summarized data on the fly simply by rotating row and column headings that gives the pivot table its name.
Create a pivot table in general
1)Open the worksheet that contains the table you want summarized by pivot table and select any cell in the table. Ensure that the table has no blank rows or columns and that each column has a header.
2)Click the “Insert” tab from the main menu and choose the very left “pivot table”