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
EXC103IMicrosoft Excel Training Part 3195.00Student6.0 hrs
 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 Part 2 or have equivalent experience. When taken on a private basis, class content can be tailored to your needs.

 
Session 1Course Topics 
 
  • 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 Topics 
 
  • 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