Excel 2003 Level 1

Prerequisites:

To ensure your success, we recommend you first take the following course or have equivalent knowledge: Microsoft Office Windows XP: Introduction

If you have taken an introductory course for an earlier version of the Windows operating system, this will also meet the prerequisite.

Course Description:

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft‚® Office Excel 2003 to manage, edit, and print data.

You will create and edit basic Microsoft‚® Office Excel 2003 worksheets and workbooks.

Audience: 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.

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.

This course includes the following modules:

Getting Started

• Enter data in a worksheet
• Edit data
• Change the appearance of data
• Save a workbook

Editing Your Worksheet

• Moving data to other cells
• Copy data to other cells
• Fill cells with a series of data
• Insert and delete rows and columns
• Undo and Redo an entry
• Find and replace numbers
• Enter data in a range
• Verify data in a range

Performing Calculations

• Sum a Range of Data
• Use a Built-in Function
• Copy a Formula
• Create an Absolute Reference

Formatting

• Number Formats
• Custom number formats
• Font Size and Type
• Styles
• Borders and Colours to cells
• Column Width and Height
• Align Cell Contents
• Merge and Center Cells
• AutoFormat

Working with multiple worksheets

• Format worksheets Tabs
• Reposition Worksheets in a workbook
• Copy Worksheets

Customising layout

• Split a worksheet
• Arrange worksheets
• Freeze and unfreeze rows and columns
• Hide & Unhide worksheets

Page Display & Printing Options

• Freeze rows and columns
• Print Title
• Set Page Margins
• Headers and Footers
• Page Orientation
• Insert and remove page breaks
• Print a range