On this Microsoft Excel 2003 training course you will obtain the basic skills required to create and use a spreadsheet. You will learn to enter and edit data, create formulas, format elements of a worksheet, and insert charts.

Target audience

Those wanting to obtain basic skills in using a spreadsheet, such as updating data, applying formatting, printing, and making simple calculations.

Course prerequisites

You should be able to use Microsoft Windows and basic functions in Office to start an application, get help, and open, close, and save files.

Course Topics 

Excel Basics

• Spreadsheet Terminology
• Exploring The Excel Window
• Getting Help
• Opening And Navigating Workbooks
• Closing Workbooks

 Entering And Editing Data

• Creating Workbooks
• Entering And Editing Labels And Values
• Entering And Editing Formulas
• Saving And Updating Workbooks

 Printing

• Preparing To Print
• Page Set Up Options

 Modifying A Worksheet

• Moving And Copying Data
• Moving And Copying Formulas
• Using Autofill
• Using Absolute References
• Inserting And Deleting Ranges

 Using Functions

• Entering Functions
• Using Autosum
• Using AVERAGE, MIN, And MAX

 Formatting Worksheets

• Formatting Text
• Formatting Rows And Columns
• Number Formatting
• Other Formatting Features  

 Creating Charts

• Chart Basics
• Printing Charts