Excel Pivot Tables Data Analysis Training

Excel Pivot Tables Data Analysis Training Course Excel Pivot Tables Data Analysis Training
By TED Integrated
Microsoft® Excel Series:

Data Analysis with Microsoft® Excel Pivot Tables 2013/2016

“The real problem is that, pivot tables are rarely explained properly...”

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
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
Course Title:
Data Analysis with Microsoft Excel Pivot Tables 2013/2016
Training Category:
Information Technology
Target Audience:
Executive, senior executive, manager and above. It is also for those who are heavy users in Microsoft Excel.
Duration:
1 Day
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Workshop
  • Group Discussion
  • Presentation Handouts
  • Computer Lab Work
  • Lecture
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

Creating neat, informative summaries out of huge lists of raw data is a common challenge. And while Excel gives you all the tools you need to create such summaries, the actual work of writing formulas, cutting and pasting information, and organizing your totals into a new table can be extremely tedious.

Excel has a feature called pivot tables that can solve all these problems. Pivot tables quickly summarize long lists of data. By using a pivot table, you can calculate summary information without writing a single formula or copying & pasting data. But the most notable feature of pivot tables is that you can arrange them dynamically. With the drag of a mouse, you can easily rearrange the pivot table so that it summarizes the data based on gender or age groupings or geographic location. This process of rearranging your table is known as pivoting your data: you're turning the same information around to examine it from different angles.

Pivot tables are a hidden gem in Excel. Many otherwise experienced spread sheet users avoid them because they seem too complicated at first glance. The real problem is that, pivot tables are rarely explained properly. Discover that pivot tables are really just a convenient way to build intelligent, flexible summary tables.

Course Objectives ›

At the end of the course, participants should be able to understand and/or perform the following:

  • Define pivot tables
  • Pivot Table Tools
  • Summarising & Presenting Data
  • Grouping Data
  • Multiple Data Sources
  • Problematic Data
  • Pivot Charts

Course Outline ›

DAY 1

Introduction to pivot tables

  • Creating Pivot Tables
  • Filtering Data
  • Re-arranging Data
  • Extracting Data

Pivot Table Tools

  • Sorting Data
  • Refreshing Data
  • Changing Data source
  • Pivot Table Designs
  • Customising Layouts & Totals

Summarising & Presenting Data

  • Handling Multiple Values
  • Changing How Values Are Summarised
  • Changing How Values Are Displayed
  • Customising Calculations

Grouping Data

  • Handling Values
  • Handling Dates
  • Performing Manual Grouping

Multiple Data Sources

  • Data From Multiple Ranges
  • Data From An External source

Problematic Data

  • Filling Up Blank Cells
  • Creating Recurring Labels
  • Solving Date Issues

Pivot Charts

  • Charting Basics
  • Changing Chart Types
  • Formatting Pivot Charts
  • Using Slicers

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : [email protected]

Related Courses ›

Published by: ,