Orange Coast Database Associates
P.O. Box 6142
Laguna Niguel, CA 92607

Previous Page

949-408-1350 (Office)
800-355-9855 (Toll free)
http://www.ocdatabases.com
Accelerated training for working professionals

Orange Coast Database Associates, Inc.
Open Enrollment Course Catalog

Item IDCourse Title and DescriptionPricePerLength
EXC101NMicrosoft Excel for Absolute Beginners140.00Student5.0 hrs
 Learn to create Excel spreadsheets in this hands-on introduction to Microsoft Excel Fundamentals. Course covers Excel fundamentals, formatting a worksheet, functions, charts and basic features. This is a beginner class for those who have not used Excel before. No prior knowledge of Excel is assumed.

 
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
  • Printing - Preparing to print, Page setup options, Printing worksheets