This preview shows page 1. Sign up to view the full content.
Unformatted text preview: a. Click the EmpCounts tab. Click in the list. b. Click the Insert tab. Click the PivotTable button. c. Verify that the range is A3:F35 d. Click OK. e. In the Choose fields to add to report, click to select State . f. Click to select City. g. Click to select Students . It is placed as a Values field. h. Click cell B3. Click the Field Settings button. Change the Custom Name to Employees Who Are Students . i. Click cell A4. Click the PivotTable Tools Options tab. Click the Field Headers button to turn off field captions. j. Click the Field Settings button. On the Layout & Print tab, click to deselect Display subtotals at the top of each group . Click OK . k. Use Pivot Style Medium 15 . l. Click in the PivotTable Name box in the PivotTable group. Key StudentCount and press enter. 6. Copy the label in cell A1 on the PivotTable sheet to this sheet. Center the sheet horizontally. 7. Prepare and submit your work....
View Full Document
This note was uploaded on 12/03/2011 for the course INFS 3380 taught by Professor Ahmed during the Fall '11 term at Toledo.
- Fall '11