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

Course Description

News and special offers from Orange Coast Database Associates
News

 Home-->Courses-->exc103i

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

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.


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