Orange Coast Database Associates
P.O. Box 6142
Laguna Niguel, CA 92607

Previous Page

949-489-1472 (Office)
800-355-9855 (Toll free)
http://www.ocdatabases.com
Accelerated training for working professionals

Orange Coast Database Associates, Inc.
Course Catalog (All Modalities)

Item IDCourse Title and DescriptionPricePerLength
EXC102iMicrosoft Excel Training Part 2195.00Student6.0 hrs
 Build on your Beginning Excel skills with this intermediate class. Covers using functions and lists and analyzing data. Provides a solid introduction to charts and pivot tables. When taken on a private basis, class content can be tailored to your needs. Students should have taken Microsoft Excel Part 1 or have equivalent experience. The next class in sequence is Microsoft Excel Part 3.

 
Session 1Functions and Data 
 
  • Working with functions - Work with ranges, use specialized functions, work with logical functions, work with data & time functions, work with text functions
  • Working with lists - Sort data, filter data, query data with database functions, outline and subtotal data
  • Analyzing data - Create and modify tables, apply intermediate conditional formatting, apply advanced conditional formatting

 
Session 2Charting and Pivot Tables 
 
  • Visualizing data with charts - Create charts, modify and format charts, use advanced chart features
  • Using pivot tables and pivot charts - Create a pivot table, analyze pivot table data, present data with pivot charts, filter data by using timelines and slicers