Microsoft Office Tutorials and References
In Depth Information
Tip 80: Creating a Quick Frequency Tabulation
2. If Excel doesn’t correctly identify the range, change the Table/Range setting.
3. Specify a location for the PivotTable.
4. Click OK.
Excel creates an empty pivot table and displays the PivotTable Fields task pane.
5. Drag the State field into the Rows section.
6. Drag the State field into the Values section.
Excel creates the pivot table, which shows the frequency of each state (see Figure 80-2).
Figure 80-2: A quick pivot table shows the frequency of each state abbreviation.
Search JabSto ::




Custom Search