Msft Partner gold blk v2

Maximizing PivotTable (Microsoft Excel 2010)

This in-depth one-day course introduces ways to create and work with Pivot Tables to look, organize and summarizes, your data in a variety of ways. Discover how to perform a variety of calculations...

Read More
$295 USD
Course Code 50448
Duration 1 day
Available Formats Classroom
6119 Reviews star_rate star_rate star_rate star_rate star_half
Course Image

This in-depth one-day course introduces ways to create and work with Pivot Tables to look, organize and summarizes, your data in a variety of ways. Discover how to perform a variety of calculations with Pivot Table Data. Pivot Table a great analysis tool!

Skills Gained

  • Making Data Work For You
  • A Quick Tour
  • Manipulating the PivotTable
  • Digging Deeper
  • Beyond the Basics
  • More PivotTable Calculations
  • Optional Topics

Who Can Benefit

This course is intended for users of Microsoft Office Excel who want to learn about the features of Microsoft Office Excel PivotTable 2010.

Prerequisites

  • This course assumes that students have basic working knowledge of Microsoft Office Excel.

Course Details

Outline


Module 1: Making Data Work For You
This module how to make use of Excel data and maximize it through the use of PivotTable.
Lessons

  • Maximize the Power of PivotTable
  • Ask the Questions
  • Get the Answer

Lab 1: Making Data Work For You
  • Maximize the Power of PivotTable

Module 2: Making Data Work For You
After completing this module, students will be able to:
  • Maximize the Power of PivotTable

Module 3: A Quick Tour
This module explains how to use determine the source needed to create its PivotTable report
Lessons
  • Determine What You Need to Know
  • Identify the Source
  • Creating the Pivot Table
  • Working with Pivot Table Layout

Lab 1: Creating the PivotTable
  • Determine the source needed for its PivotTable
  • Create the PivotTable
  • Working with the PivotTable
After completing this module, students will be able to:
  • Determine the source needed for its PivotTable
  • Create the PivotTable
  • Working with the PivotTable

Module 4: Manipulating the PivotTable
This module explains how to rearrange the layout of the PivotTable.
Lessons
  • Rearranging the Layout
  • Adding New Field
  • Renaming a Field
  • Formatting Numbers
  • Changing Sorting Order
  • Showing Top 10
  • Refreshing Data

Lab 1: Manipulating the PivotTable
  • Rearranging the Layout
  • Adding New Field
  • Renaming a Field
  • Formatting Numbers
  • Changing Sorting Order

Module 5: Manipulating the PivotTable
After completing this module, students will be able to:
  • Rearrange the layout of the PivotTable
  • Adding, renaming New Field within the PivotTable
  • Formatting Number in the PivotTable reports
  • Changing Sorting Order
  • Refreshing Source data within the PivotTable

Module 6: Digging Deeper
This module explains how to group item, display subtotals and grandtotals within the PivotTable.
Lessons
  • Grouping Items
  • Displaying Subtotals
  • Hiding/Showing Grand Totals
  • Formatting PivotTable
  • Using Slicer
  • Formatting Slicer

Lab 1: Digging Deeper
  • Grouping Items
  • Displaying Subtotals
  • Hiding/Showing Grand Totals
  • Formatting PivotTable
After completing this module, students will be able to:
  • Display grouping and subtotals for PivotTable
  • Formatting PivotTable
  • Organize PivotTable through the use of Slicer

Module 7: Beyond the Basics
This module explains how to create a second data field and changing the summary function with the PivotTable.
Lessons
  • 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
After completing this module, students will be able to:
  • Create a Second Data Field within the PivotTable
  • Changing Summary Function
  • Displaying Numerical Value as a Percentage of the Total
  • Create custom calculation within the PivotTable

Module 8: More PivotTable Calculations
This module explains how to insert formula within the PivotTable.
Lessons
  • Using Formulas
  • Creating a Calculated Field
  • Creating a Calculated Item
  • Using GetPivotData Function
  • Turn off GetPivotData Function

Lab 1: More PivotTable Calculations
  • Use Formulas with the PivotTable
  • Create a calculated field and item
  • Using GetPivotData Function
  • Turn off GetPivotData Function
After completing this module, students will be able to:
  • Use Formulas with the PivotTable
  • Create a calculated field and item
  • Using GetPivotData Function
  • Turn off GetPivotData Function

Module 9: Optional Topics
This module how to create a PivotChart, Publishing PivotTable to the Web and using multiple source range for the PivotTable.
Lessons
  • Creating PivotChart
  • Publishing PivotTable to the Web
  • Using Multiple Source Ranges

Lab 1: Optional Topics
  • Creating PivotChart
  • Publishing PivotTable to the Web
  • Using Multiple Source Ranges to create PivotTable

Module 10: Optional Topics
After completing this module, students will be able to:
  • Creating PivotChart
  • Publishing PivotTable to the Web
  • Using Multiple Source Ranges to create PivotTable
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward