In this course you will use the advanced PivotTable functionality in Excel to analyze raw data. You will learn to prepare data for PivotTable reporting and create PivotTables from various data sources, analyze data by using PivotTables, and work with PivotCharts.
Prerequisite(s):
Excel Level 2
Audience:
Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.
Outline:
Lesson 1: Preparing Data and Creating PivotTables
Prepare Data
Create a PivotTable from a Local Data Source
Create a PivotTable from Multiple Local Data Sources
Excel – Data Analysis with PivotTables
Dates are listed in Pacific Time Zone
$175.00
Learn to create and analyze PivotTable data.
Description
Overview:
In this course you will use the advanced PivotTable functionality in Excel to analyze raw data. You will learn to prepare data for PivotTable reporting and create PivotTables from various data sources, analyze data by using PivotTables, and work with PivotCharts.
Prerequisite(s):
Excel Level 2
Audience:
Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.
Outline:
Lesson 1: Preparing Data and Creating PivotTables
Lesson 2: Analyzing Data by Using PivotTables
Lesson 3: Working with PivotCharts
Additional information
3.5 Hours
No
Related products
Excel – Level 3
$295.00 Add to cartExcel – Level 1
$295.00 Add to cartData Model Design using Power BI Desktop – Level 2
$595.00 Add to cart