Ch.6 exam 3 - C hapter 6: Using PivotTables to Support...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 6: Using PivotTables to Support Decisions Chapter Skills Recognize the type of data that benefits from PivotTable (& PivotChart) analysis. Understand how to set up a pivot table to view the desired dimensions of the data summary. Group PivotTable summary data. Filter PivotTable summary data. Apply appropriate formats to PivotTable cells. Customize the way PivotTable values are displayed. Update PivotTable data manually, and set PivotTable data to update automatically. Design two PivotTables that use the same data such that the two tables can group values independently by using the PivotTable Wizard. Use various aggregate functions to customize the way PivotTable data is displayed. Apply the appropriate chart type for a specific PivotChart report. Chapter Vocabulary detailed data summary data multi-dimensional data PivotTable report o refreshing data o grouping data o filtering summary data column filter row filter page filter PivotChart report Chapter Demonstrations: 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
1. Create a pivot table that shows the number of employees hired each year in each department. a. Open the file “Emplyee_ch6.xlsx. Rename the file “Employees_ch6_pivot.xlsx”. b. Select a cell within the employee list. c. Select Insert Tables (group) PivotTable . The Create PivotTable dialog box will appear. d. Verify that the list range selected is correct, click OK. e. Check the fields in the Pivot Table Field List that you wish to add to the PivotTable. i. Check Department field only. Be sure the Department field displays in the Row Label section of the field list window. ii. Drag the Department field from the field list to the Value section of the field list. (Be sure the Department field appears in both the Value section and the Row Labels section of the field list window.) f. Verify that the value field summary operation is Count of Department . The pivot table will show the number of employees employed each department and the total employees in the list (total of 100 employees). g. Name the worksheet Pivot1 . Save the workbook. 2. PivotChart Reports: Create a PivotChart report of the data in the previous PivotTable report. a. With the cursor inside the pivot table list, Insert(tab) Chart Pie (any type of pie chart) b. What should you do to make the largest pie slice begin in the 12:00 position? c. Edit the chart as you would any other chart object in Excel to change title, data labels, legend, etc. 2
Background image of page 2
a. Title: Number of Employees by Department b. Delete the legend: Right-click on the legend and select Delete c. Add and format data labels: i. Right-click on the chart data. Select Add Data Labels ii. Right-click on the chart data and select Format Data Labels 1. Of the Label Options , uncheck Value and check Category Name , Percentage , Show Leader Lines. 2.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/15/2011 for the course ACIS 2504 at Virginia Tech.

Page1 / 9

Ch.6 exam 3 - C hapter 6: Using PivotTables to Support...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online