Home

About Us

Catalog Main Catalog Microsoft Access Courses Database Development Courses Discounts and Passports Miscellaneous Fees & Services SQL Courses

Contact Us

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 via online Remote Learning. 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.