Course 50448-B: Maximizing PivotTable (Microsoft Excel 2010)

Microsoft

Course 50448-B: Maximizing PivotTable (Microsoft Excel 2010)

Share This Learning Path

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

Audience Profile

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

Prerequisites

Course outline

Module 1: Making Data Work For You

Module Overview

This module explains 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 Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Maximize the Power of PivotTable.

Module 2: A Quick Tour

Module Overview

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 Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Determine the source needed for its PivotTable.
Create the PivotTable.
Working with the PivotTable.

Module 3: Manipulating the PivotTable

Module Overview

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 Sessions

Not available for this module

Lab Lessons

Lab lessons not available

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.
Showing Top 10 values.
Refreshing Source data within the PivotTable.

Module 4: Digging Deeper

Module Overview

This module explains how to group item, display subtotals and grandtotals within the PivotTable. It also introduce the feature of Slicer to display item in PivotTable.

Lessons

Grouping Items
Displaying Subtotals
Hiding/Showing Grand Totals
Formatting PivotTable
Using Slicer
Formatting Slicer

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

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 5: Beyond the Basics

Module Overview

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 Sessions

Not available for this module

Lab Lessons

Lab lessons not available

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 6: More PivotTable Calculations

Module Overview

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 Sessions

Not available for this module

Lab Lessons

Lab lessons not available

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 7: Optional Topics

Module Overview

This module explains 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 Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Creating PivotChart.
Publishing PivotTable to the Web.
Using Multiple Source Ranges to create PivotTable.

Book Your Seat

Find Learning Paths

Course 20703-1-B: Administering System Center Configuration Manager

Join our community of certified professionals

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Contact Us

International Computer Training Center