Back to Search Results

Training Course Summary:

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.

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.

Pre-Requisites:

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.

Who Should Attend:

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.

Training Course Overview/Content:

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