Classes Data & Analytics
Microsoft Apps
Excel – Data Analysis with PivotTables
- 0.5 days
- 6 upcoming dates
- 6 guaranteed to run
- May qualify for CEU/PDU credit
Upcoming dates
All times shown in the class's own timezone. 6 of 6 are guaranteed to run, meaning they go ahead regardless of enrollment.
| Dates | Starts | Where | Status | Seat | Book |
|---|---|---|---|---|---|
| Thu, Aug 20 | 9:00 AM to 12:30 PM EDT | Live virtual | GUARANTEED | $148 | |
| Fri, Sep 4 | 9:00 AM to 12:30 PM EDT | Live virtual | GUARANTEED | $148 | |
| Fri, Sep 18 | 9:00 AM to 12:30 PM EDT | Live virtual | GUARANTEED | $148 | |
| Mon, Oct 26 | 9:00 AM to 12:30 PM EDT | Live virtual | GUARANTEED | $148 | |
| Mon, Nov 23 | 9:00 AM to 12:30 PM EST | Live virtual | GUARANTEED | $148 | |
| Mon, Dec 28 | 9:00 AM to 12:30 PM EST | Live virtual | GUARANTEED | $148 |
About this class
Being able to harness the power of PivotTable features & create PivotCharts will help students gain an edge. Not only will students be able to summarize data to analyze, but they can organize the data in a way that can be meaningfully presented to others.
What you'll be able to do
Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data. You will: Prepare data for PivotTable reporting and create PivotTables from various data sources. Analyze Data Using PivotTables. Work with PivotCharts.
Course outline
1 - Preparing Data & Creating PivotTables
- Prepare Data
- Create a PivotTable from a Local Data Source
- Create a PivotTable from Multiple Local Data Sources
- Create a PivotTable from an External Data Source
2 - Analyzing Data Using PivotTables
- Summarize PivotTable Data
- Organize PivotTable Data
- Filter PivotTable Data
- Format a PivotTable
- Refresh and Change PivotTable Data
3 - Working with PivotCharts
- Create a PivotChart
- Manipulate PivotChart Data
- Format a PivotChart
Before you attend
Excel - Part 1 & Part 2 or equivalent experience.
How reserving works. Your card is authorized, not charged. We confirm the seat with the training center, usually within one business day, and take payment only once it is held. If the class turns out to be full we release the authorization and you are not charged.
Request a quote
Tell us how many people and roughly when. We'll come back with dates, seat price, and a total by the end of the next business day.