|
|
|
|
|
|
EXC201: Excel Data Analysis with Pivot Tables
|
Book List |
Course Links
|
|
|
|
Tuition: $155.00 per student |
Length: 1/2 day |
|
|
Synopsis:
This course covers using Excel advanced PivotTable functionality to analyze your raw data. The student will prepare data for PivotTable reporting and create PivotTables from various data sources, analyze data using PivotTables and work with PivotCharts. The contents of this course can be tailored to suit custom groups. Students should have taken Microsoft Excel Part 3 or have equivalent experience.
|
|
Formats:
Offered exclusively to groups of three or more.
|
|
Scheduling:
Flexible. Group classes can be scheduled to suit your needs.
|
|
Group
Discounts:
2-4 students 20%, 5-8 30%, >8 quote
|
|
|
|
| Session 1 | Advanced Pivot Table Analysis | 3.0 Hours | | |
- Preparing data and creating PivotTables - Prepare data, create a PivotTable from local and external data sources.
- Analyzing data using PivotTables - Summarize and organize PivotTable data, filter PivotTable data, format a PivotTable, refresh and change PivotTable data.
- Working with PivotCharts - Create a PivotChart, manipulate PivotChart data, format a PivotChart.
| |
|
|
Materials:
Comprehensive manual; training certificate.
|
|
Location:
Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.
|
|
Related Services |
|
Need
help with a project? We may also provide programming
and consulting services covering the above material. See
Programming and Consulting for more information.
|
|
|
|
