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.d2associates.com
Accelerated training for working professionals

Microsoft Access and Relational Database Training
Course Catalog

Item IDCourse Title and DescriptionPricePerLength
EXC102iMicrosoft Excel Intermediate245.00Student6.0 hrs
 Hands-on course covering intermediate-level features and functions of Excel 2003. Students will learn how to work with large worksheets, use 3-D formulas, customize Excel's toolbars and menus, apply special cell formatting, sort and filter lists, create combination charts and trendlines, use Excel's auditing features, and work with templates. Comes with a companion CBT program. Students should have taken EXC101X Excel Basic or have equivalent experience.

 
Session 1Worksheets 
 
  • Working with large worksheets - Viewing options, Hiding, displaying, and outlining data, Printing large worksheets
  • Using multiple worksheets and workbooks - Using multiple worksheets, Linking worksheets by using 3-D formulas, Consolidating data, Linking workbooks, Managing workbooks
  • Customizing Excel - Using the Options dialog box, Customizing toolbars and menus
  • Advanced formatting - Borders and shading, Using special number formats, Working with dates, Working with styles, Other advanced formatting

 
Session 2Intermediate Excel Features 
 
  • List management - Examining lists, Sorting and filtering lists, Advanced filtering
  • Advanced charting - Chart formatting options, Using combination charts, Using graphic elements
  • Documenting and auditing -Auditing features, Comments and text boxes, Protection, Workgroup collaboration
  • Using templates - Built-in templates, Creating and managing templates