Microsoft Excel Pivot Table Training

Microsoft Excel Pivot Table Training Microsoft Excel Pivot Table Training
By TED Integrated
PSMB HRDF Claimable
Course Title:
Maximizing Pivot Table in Microsoft Excel 2007/2010
Training Category:
Information Technology
Target Audience:
Anyone who wants to learn how to use Excel pivot tables more efficiently and effectively plus experienced Excel users who have already use or want to use pivot tables for data analysis.
Duration:
1 Day
Public Program* Now Available! »
Dec 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Tue 19 Dec 2017 9:00AM - 5:00PM
Fee Per Person:
RM900.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Jan 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 29 Jan 2018 9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Mar 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 21 Mar 2018 9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Apr 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Fri 27 Apr 2018 9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
May 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Fri 04 May 2018 9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Jun 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Fri 29 Jun 2018 9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Jul 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Fri 27 Jul 2018 9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Sep 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Fri 28 Sep 2018 9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Oct 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 10 Oct 2018 9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
Dec 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Fri 21 Dec 2018 9:00AM - 5:00PM
Fee Per Person:
RM954.00
Register Now!

* Other terms & conditions apply.
For In-house Training »
Request for Quotation Request for Quotation
For Customization & Other Inquiries »
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Presentation Handouts
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions
Microsoft Excel Training Series:

Maximizing Pivot Table in Microsoft® Excel 2007/2010

“Maximizing the potential of Pivot Table in Microsoft Excel!”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service [email protected] Contact Customer Service+603-2386-7788

Introduction

This course is for anyone who wants to learn how to use Excel pivot tables more efficiently and effectively plus experienced Excel users who have already use or want to use pivot tables for data analysis. Students will also learn how to produce and automate summary reports from large blocks of data in a matter of seconds.

Prerequisites

To ensure your success, we recommend that you have a good basic working knowledge of Excel. Students can obtain this level of skill through our Excel Foundation, Intermediate and Advance courses.

Course Objectives

At the end of this course, participants should be able to:

  • Define pivot table
  • Create and work with pivot table
  • Manipulate pivot table and its data
  • Slice-and-dice data with pivot table on Excel 2010
  • Perform calculations on pivot table's data
  • Use pivot table with external data
  • Use pivot chart

Course Outline

DAY 1

Module 1: Introduction to Pivot Table

  • What is a PivotTable
  • Identify the Source
  • Creating the Pivot Table
  • Working with Pivot Table Layout

Module 2: Manipulating the PivotTable

  • Rearranging the Layout
  • Adding New Field
  • Renaming a Field
  • Formatting Numbers
  • Changing Sorting Order
  • Showing Top 10
  • Refreshing Data

Module 3: Advance Options

  • Grouping Items
  • Displaying Subtotals
  • Hiding/Showing Grand Totals
  • Formatting PivotTable
  • Using Slicer (Only for 2010)
  • Formatting Slicer (Only for 2010)

Module 4: Pivot Table Calculations

  • Using Formulas
  • Create a Calculated Field
  • Create a Calculated Item
  • Use the GETPIVOTDATA Function
  • Turn Off the GETPIVOTDATA Function

Module 5: Working With External Data

  • Creating a Pivot Table Based on External Data
  • Create a Pivot Table Consolidated from multiple worksheets
  • Page fields in consolidation
  • A single page field
  • Multiple page fields

Module 6: Pivot Chart

  • Creating PivotChart
  • Edit and Format Pivot Chart

For In-house Training:

Request for Quotation

Request for Quotation Now

For Content Customization & Other Inquiries:

Contact TED Integrated

Contact Customer Service

+603-2386-7788

Email Customer Service [email protected]

Ad by Google

Related Training Courses:

More Other Training Courses:

Published by: ,