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

Item IDCourse Title and DescriptionLength
EXC101XMicrosoft Excel Basic Class6.0 hrs
 Learn to create effective spreadsheets in this hands-on introduction to Microsoft Excel Fundamentals. Course covers Excel fundamentals, formatting a worksheet, functions, charts and basic Web features. No prior knowledge of Excel is assumed. The next class in sequence is Microsoft Excel Intermediate.

 
Session 1Excel Fundamentals 
 
  • Getting started - Spreadsheet terminology, The Excel environment, Navigating a worksheet, Using a template
  • Entering and editing data - Entering and editing text and values, Entering and editing formulas, Saving and updating workbooks
  • Modifying a worksheet - Moving and copying data, Moving, copying, and viewing formulas, Absolute and relative references, Inserting and deleting ranges, rows, and columns
  • functions - Entering functions, AutoSum, Other common functions (COUNT, etc.)

 
Session 2Formatting & Printing 
 
  • Formatting - Text formatting, Row and column formatting, Number formatting, Conditional formatting, Additional formatting options.
  • Charts - Chart basics, Formatting charts
  • Graphics - Working with pictures, Conditional formatting with graphics, Smart Art graphics
  • Printing - Preparing to print, Page setup options, Printing worksheets