Orange Coast Database Associates Course Catalog

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 ID	Course Title and Description	Price	Per	Length
EXC101X	Microsoft Excel Training Part 1	195.00	Student	6.0 hrs
	Learn to create effective spreadsheets in this hands-on introduction to Microsoft Excel Fundamentals. Course covers fundamentals, formatting a worksheet, formulas, functions, data operations, and worksheet management. No prior knowledge of Excel is assumed. The next class in sequence is Microsoft Excel Part 2.
Session 1	Excel Fundamentals
	Getting started - Navigate the user interface, use Excel commands, create and save workbooks, enter cell data, use Help Performing calculations - Create worksheet formulas, insert functions, reuse formulas and functions Modifying a worksheet - Insert, delete and adjust cells, rows, and columns, search for and replace data, use profiling and research tools
Session 2	Formatting & Printing
	Formatting a Worksheet - Apply text formats, Apply number formats, Align cell contents, Apply styles and themes, Apply Basic Conditional Formatting, Create and Use Templates Printing a Workbook - Preview and print a Workbook, Set up the page layout, Configure headers and footers Managing Workbooks - Manage worksheets, Manage workbook and worksheet views, Manage Workbook Properties