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

Course Description

News and special offers from Orange Coast Database Associates
News

Group
Training

Individual
Training

Scheduled
Classes

Programming &
Consulting

What's New!

FAQ's

Site Map

Free Catalogs

Special Offers

Current Category

Request information or a quote

Enroll in a public scheduled class

Sales: 800-355-9855

Home

About Us

Calendar

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 Advanced 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 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.


Copyright 2017 D.H.D'Urso & Associates
P.O. Box 6142, Laguna Niguel, CA 92607 949-489-1472
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