(Online Delivery) Microsoft Excel for Office 365/2021: Data Analysis with PivotTables
Description
In this course, you will use the advanced PivotTable functionality in Excel to analyze your raw data.
You will:
- Prepare data for PivotTable reporting and create PivotTables from various data sources.
- Analyze data by using PivotTables.
- Work with PivotCharts.
Lesson 1: Preparing Data and Creating PivotTables
Topic A: Prepare Data
Topic B: Create a PivotTable from a Local Data Source
Topic C: Create a PivotTable from Multiple Local Data Sources
Topic D: Create a PivotTable from an External Data Source
Lesson 2: Analyzing Data by Using PivotTables
Topic A: Summarize PivotTable Data
Topic B: Organize PivotTable Data
Topic C: Filter PivotTable Data
Topic D: Format a PivotTable
Topic E: Refresh and Change PivotTable Data
Lesson 3: Working with PivotCharts
Topic A: Create a PivotChart
Topic B: Manipulate PivotChart Data
Topic C: Format a PivotChart