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

Related Courses

Request information or a quote

Enroll in a public scheduled class

Sales: 800-355-9855


About Us

Contact Us

EXC102i: Microsoft Excel Training Part 2

Book List | Course Links

Tuition: $195.00 per student

Length: 1 day

Synopsis: 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.

Formats: Private groups (min. 3 students) at your facility only.

Scheduling: Classes can be scheduled to suit your group's convenience in as little as 2 to 3 weeks.

Group Discounts: 2-4 students 20%, 5-8 30%, >8 quote


Format this document for printing

Session 1Functions and Data3.0 Hours
  • 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 Tables3.0 Hours
  • 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

Materials: Student manual, training certificate, access to Logical Operations course website after class.


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