Online Training | 800‑258‑3837
Back to Course List

Microsoft Excel 2010: Analyzing Data Using PivotTables, Slicers, and PivotCharts

Preview video
Preview Video
Course Format
Video on Demand  Video On Demand
Product ID
sonieadu_vod
Training Time ?
61 to 66 minutes
Language(s)
English
Video Format
High Definition
Required Plugins
None
Number of Lessons
7
Quiz Questions
5
Question Feedback
Wrong Answer Remediation
Lesson Bookmarking
Interactive Producer
Mastery Training Content Network
Original Content Producer
Sonic Performance Support GmbH
Course screen Course screen Course screen
Overview

Many companies today use Excel to analyze data; however, large Excel files can be overwhelming to work with. A more compact way to view information quickly is with a PivotTable. With this online course, you will learn how to create and customize PivotTables and PivotCharts in Microsoft Excel 2010.

The video demonstrations in this training course showcase how to select the data for your PivotTable, including the row and column labels and the values you wish to include. You will learn how to easily group data together for quick, visual reference, and receive an overview of the basic PivotChart features. Slicers, or filters, are covered as a method to help you analyze your data. This course also shows how to transfer the PivotTable into a PivotChart for a graphical representation of your Excel data.

Video on Demand   This course is in the Video On Demand format, to read about Video On Demand features click here.

  • Install on any SCORM LMS
  • Full-screen video presentation
  • Print certificate and wallet card
  • You have 60 days to complete the course
Audience

Anyone using Excel 2010 interested in PivotTables and analyzing data

Topics
The course presents the following topical areas:
  • Analyzing Data Using PivotTables
  • PivotTables
  • PivotTable Field Lists
  • Data Grouping
  • Inserting Calculated Fields
  • Filtering Data Using Slicers
  • Analyzing Data Using PivotCharts

© Mastery Technologies, Inc.