Excel: Data Analysis with Pivot Tables
Duration
2h 5m
Students
0
Last Updated
December 11, 2024
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.
- 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
Free
Course Includes
- Preparing data and creating Pivot Tables
- Working with local and external data sources
- Summarizing, organizing, filtering, and formatting Pivot Tables
- Refreshing and Changing Pivot Table data
- Creating Pivot Charts
