This course provides students with the knowledge and skills to examine and manipulate raw data through the use of Microsoft Office Excel PivotTables and PivotCharts.
Audience:
This course is aimed at information workers who need to learn more in-depth techniques of using PivotTables.
Prerequisites:
Before attending this course, students must have:
•Taken the Windows XP Level 1 course or have the basic skills and knowledge of Windows applications
•Be an intermediate user of Microsoft Excel
Objectives:
•Understand the benefits of PivotTable Reports
•Convert raw data in an Excel worksheet into meaningful PivotTables and PivotCharts
•Manipulate the PivotTable layout
•Use Grouping
•Create Custom Calculations
•Use Formulas and create formulas outside of a report
•Create a PivotChart and publish it to a Web site
Course Outline:
Lesson 1: Make Your Data Work for You
•Maximize the Power of PivotTable
•Ask the Questions
•Get the Answers
Lesson 2: A Quick Tour
•Determine What You Need to Know
•The Source is Important
•Ready, Set, Go
•The PivotTable Layout
•What Goes Where
•Result of our PivotTable
•Viewing Our Data Differently
Lesson 3: Manipulating the PivotTable
•Rearrange the Layout
•What We Get
•Add a New Field
•Remove a Field
•Rename a Field
•Format Numbers
•Change the Sort Order and Top 10 AutoShow
•Refresh Data
Lesson 4: Digging Deeper
•Create a Quarterly Group
•Group Data Manually
•Display Subtotals
•Hide/Display Grand total
•Format a PivotTable Report
•Use a Slicer
•Format a Slicer
Lesson 5: Beyond the Basics
•Creating a Second Data Field
•Use Count to Summarize Data
•Display Numerical Data as a Percentage of the Total
•Create a Custom Calculation
•More Functions in Custom Calculation
Lesson 6: Move PivotTable Calculations
•Using Formulas
•Create a Calculated Field
•Create a Calculated Item
•Use PivotTable Data Outside the Report
•Use GETPIIVOTDATA Function
•Turn off GetPivotData Function
Lesson 7: Optional Topics
•Create a PivotChart Report
•Publish PivotTable Reports to the Web
•Use Multiple Ranges as Source Data
Length of Class:
One Day
Instructor-led or Online:
Instructor-Led