Excel: Data Analysis with Pivot Tables

$49.99 $20.00

Get Actionable Insight From Your Data With Excel’s Popular Power Tool!

Pivot Tables are the perfect tool to analyze large amounts of data in Excel, and in this Excel: Data Analysis with Pivot Tables course, Microsoft trainer Kathy Jones will show you how to effectively use the PivotTable tools in Excel 2013 and 2016. Are you ready to learn how to get more from Excel with the power of PivotTables?

Length: 2 hrs 27 min

This title is available in the
Total Training All-Access library.

Subscribe Now


Being able to summarize, visualize, and tabulate your data makes PivotTables an important skill for anyone who uses Excel to store and report on data. Taught by Microsoft trainer Kathy Jones, Excel: Data Analysis with Pivot Tables will help intermediate and advanced users work more effectively with Excel PivotTables and PivotCharts in both the 2013 and 2016 versions of Excel.

Topics covered include:

  • Preparing Data and Creating PivotTables
  • Working with Local and External Data Sources
  • Summarizing, Organizing, Filtering, and Formatting PivotTables
  • Refresh and Change PivotTable Data
  • Working with PivotCharts

Objectives. You will be able to:

  • Create a pivot table from a local data source, multiple local data sources, and external sources
  • Organize data within a pivot table
  • Modify pivot table options

Sample clip


1. Excel: Data Analysis with Pivot Tables 2:27:33
Preparing Data
Create From Local Data Source
Create From Multiple Local Sources
Create From External Sources
Summarize Table Data
Organize Pivot Table Data
Filter Data Part 1
Filter Data Part 2
Format Pivot Table
Refresh And Change Data 
Pivot Options Part 1
Pivot Options Part 2
Creating A Pivot Chart Data
Manipulate Pivot Chart Data
Formatting A Pivot Chart


Kathy Jones is a training professional with experience in all aspects of training and consulting, including classroom presentations, project management process analysis, program design and development, and individual knowledge transfer. She has a special focus on work with project management teams to improve processes, as well as the soft skills involved in managing projects and teams such as negotiation and problem resolution. She also specializes in working with technical teams such as IT groups or help desks to improve communication and customer skills.

Specialties: Project management process analysis and training; Communication, negotiation and team building skills for technical managers and specialists.

You may also like…