Excel: Data Analysis with Pivot Tables
- 15 Sections
- 2h 5m Duration
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
Manipulate Pivot Chart Data
Formatting A Pivot Chart
Pivot Tables are the perfect tool to analyze large amounts of data in Excel. The ability to summarize, visualize, and tabulate your data makes PivotTables an important tool for Excel users who need to store and report on data. Microsoft certified trainer Kathy Jones will show you how to create, format and manipulate PivotTables and PivotCharts so you can easily get the results you need from your data.