Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

Maximizing PivotTable (Microsoft Excel 2007)

Course Details
Code: 50482
Tuition (USD): $295.00 $265.50 • Classroom (1 day)

This 1 day course provides participants with the knowledge and skills to use the features and functions of Microsoft Office Excel PivotTable 2007 to accomplish analysis tasks.

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 2007.

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

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

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: Adding Special Effects
  • 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
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

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 Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward