Class Schedule
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | syllabus | contact | grades
Spreadsheets can be flat file databases.
The tools in Excel can manipulate such databases to array the data exactly as needed.
A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data.
Pivot tables are summaries of your data based on categories that you select.
We will make a copy of a Worksheet and set up a PivotTable
The 08-Inventory worksheet is a good candidate for a PivotTable.
When you create PivotTables, you do not want the data to be messy, and you would want to first "clean" the data.
Verify that you now have a blank PivotTable report located in the cells area on the left and that you have a Pivot Table Fields pane on the right.
You now have a nice summary of important parts of your data.
week of 13 April labs | sorting | filtering | pivot tables