Microsoft Office Excel 2003 BeginningTraining

"Fun, energetic - kept the class moving at a comfortable pace and made it interesting"

-Julie B, Coca Cola

Get your Training Quote

• Call (800) 611-1840 for Class Schedule

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

CED Solutions is your best choice for Excel 2003 , Excel 2003 training, Excel 2003 certification, Excel 2003 boot camp, Excel 2003 certification training, Excel 2003 certification course, Excel 2003 course, Excel 2003 class.