Course Overview
Learning Options
Target audiences
- This course is intended for users of Microsoft Office Excel who want to learn about the features of Microsoft Office Excel PivotTable 2010.
Schedule Dates
Curriculum
-
Module 2: Making Data Work For You
After completing this module, students will be able to:
-
Module 3: A Quick Tour
This module explains how to use determine the source needed to create its PivotTable report
-
Module 4: Manipulating the PivotTable
This module explains how to rearrange the layout of the PivotTable.
-
Module 5: Manipulating the PivotTable
After completing this module, students will be able to:
-
Module 6: Digging Deeper
This module explains how to group item, display subtotals and grandtotals within the PivotTable.
-
Module 7: Beyond the Basics
This module explains how to create a second data field and changing the summary function with the PivotTable.
- Creating Second Data Field
- Changing the Summary Function
- Displaying Numerical Value as a Percentage of the Total
- Creating a Custom Calculation
- More Function in Custom Calculation
- Lab 1: Beyond the Basics
- Create a Second Data Field within the PivotTable
- Changing Summary Function
- Displaying Numerical Value as a Percentage of the Total
- Creating a Custom Calculation
- More Function in Custom Calculation
-
Module 8: More PivotTable Calculations
This module explains how to insert formula within the PivotTable.
-
Module 9: Optional Topics
This module how to create a PivotChart, Publishing PivotTable to the Web and using multiple source range for the PivotTable.
-
Module 10: Optional Topics
After completing this module, students will be able to:
-
Module 1: Making Data Work For You
This module how to make use of Excel data and maximize it through the use of PivotTable.