MCSEClasses Certification Training Boot Camp

Excel 2003 - Level 1

Course Length:	1 days
Course Price:	$245 (Fort Lauderdale)

Class Schedule

Call for Class Schedule

This course is also available in a Remote Classroom Instruction format.

In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

Course Objective: You will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.

Target Student: This course is designed for persons preparing for certification as a Microsoft® Office Specialist in Excel, who already have knowledge of the Microsoft® Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft® Excel 2003 worksheets.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

create a basic worksheet.
modify a worksheet.
perform calculations.
format a worksheet.
develop a workbook.
print the contents of a workbook.
customize the layout of the Excel window.

Course Content

Lesson 1: Getting Started with Excel

An Overview of Excel
Navigate in Excel
Select Data
Enter Data
Save a Workbook
Obtain Help

Lesson 2: Modifying a Worksheet

Move and Copy Data Between Cells
Fill Cells with Series of Data
Insert and Delete Cells, Columns, and Rows
Find, Replace, and Go To Cell Data

Lesson 3: Performing Calculations

Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Create an Absolute Reference

Lesson 4: Formatting a Worksheet

Change Font Size and Type
Add Borders and Color to Cells
Change Column Width and Row Height
Merge Cells
Apply Number Formats
Create a Custom Number Format
Align Cell Contents
Find and Replace Formats
Apply an AutoFormat
Apply Styles

Lesson 5: Developing a Workbook

Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Copy a Workbook

Lesson 6: Printing Workbook Contents

Set a Print Title
Create a Header and a Footer
Set Page Margins
Change Page Orientation
Insert and Remove Page Breaks
Print a Range

Lesson 7: Customizing Layout

Split a Worksheet
Arrange Worksheets
Freeze and Unfreeze Rows and Columns
Hide and Unhide Worksheets

MCSEClasses.com is your best choice for Excel 2003, Excel 2003 training, Excel 2003 certification, Excel 2003 certification boot camp, Excel 2003 boot camp, Excel 2003 certification training, Excel 2003 boot camp training, Excel 2003 boot camp certification, Excel 2003 certification course, Excel 2003 course, training Excel 2003, certification Excel 2003, boot camp Excel 2003, certification Excel 2003 boot camp, certification Excel 2003 training, boot camp Excel 2003 training, certification Excel 2003 course.