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 and Consulting

What's New!

FAQ's

Site Map

Free Catalogs

Special Offers

Current Category

Related Courses

Request information or a quote

Enroll in a public scheduled class

Sales: 800-355-9855

Home

About Us

Catalog

Calendar

Contact Us

EXC103I: Microsoft Excel Advanced Training

Book List | Course Links

Tuition: $195.00 per student

Length: 1 day

Synopsis: Hands-on course covers advanced-level features and functions of Microsoft Excel. Students will learn how to create nested functions, export/import data, perform what-if analyses, create pivot tables, use the Goal Seek and Solver utilities, record and run macros. Students should have taken Microsoft Excel Intermediate or have equivalent experience. When taken on a private basis, class content can be tailored to your needs.

Formats: Custom scheduled corporate groups (min. 3 students) at your facility or our studio in San Juan Capistrano, Orange County, California.

Scheduling: Flexible. Group and private training can be scheduled to suit your needs. See calendar for scheduled classes.

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

 

Format this document for printing

Session 1Course Topics3.0 Hours
 
  • Working with advanced formulas - Using names , Using decision-making functions , Creating nested functions , Using financial functions
  • Lookups and data tables - Working with lookup functions , Using MATCH and INDEX , Creating data tables
  • Advanced list management - Creating subtotals , Validating cell entries , Exploring database functions , Working with data forms
  • Working with PivotTables and PivotCharts - Working with PivotTables , Rearranging PivotTables , Formatting PivotTables , Working with PivotCharts
 
Session 2Course Topics3.0 Hours
 
  • Exporting and importing - Exporting and importing text files , Exporting and importing XML data , Querying external databases
  • Using analytical options - Working with Goal Seek and Solver , Working with the Analysis ToolPak , Working with scenarios , Working with views
  • Working with macros - Running and recording a macro , Working with VBA code , Function procedures
  • Interactive Web pages - Creating interactive Web spreadsheets , Publishing PivotTables on the Web
 

Materials: Student 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