Top bar

Orange Coast Database Associates Database Training, Design and Programming Course Listing Page Computer training

Course Description

News and special offers from Orange Coast Database Associates

Separator bar



Programming &

What's New!


Site Map

Separator bar

Current Category

Request information or a quote

Enroll in a public scheduled class

Sales: 800-355-9855


About Us

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


Format this document for printing

Session 1Advanced Pivot Table Analysis3.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. 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.

Copyright 2022 D.H.D'Urso & Associates
P.O. Box 6142, Laguna Niguel, CA 92607 949-408-1350
Serving: Orange, Los Angeles, San Diego, Riverside, San Bernardino, Imperial and Ventura counties and beyond.

Privacy Statement | Contact Information | FAQ's | Site Map | Back | Home | Top