Microsoft Excel 2000 - 2003 Level 1

Microsoft Excel 2000 - 2003 Level 1

Course ID: S1N1
Duration: 1 day

Prerequisites

Windows 98, Windows ME, Windows 2000, or Windows XP

Course Objectives

After completing the course, participants will be able to:

Open and move around in an Excel workbook to learn navigation skills necessary for creating and using Excel spreadsheets
Organize columns and rows to accommodate information and edit the contents of cells to organize the information on your worksheet
Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference, create formulas by typing functions or build more complex formulas using the Insert Function dialog box
Format cells and worksheet elements to make the worksheet consistent and readable
Change the page setup and preview the workbook to define how the printed worksheet appears

Course Content

Getting Started with Microsoft Excel 2003
Understanding Spreadsheet Concepts ; Creating New Workbooks

Modifying the Worksheet
Working with Columns and Rows ; Working with Cell Contents

Using Formulas and Functions
Creating and Using Formulas ; Creating and Using Functions ; Using Absolute Cell References ; The Insert Function Command

Formatting Worksheets
Formatting Cells ; Formatting Worksheet Elements

Setting Print Options
Changing the Page Setup ; Previewing the Workbook

More Information

For more information, contact us by phone or send us an e-mail.

Toll Free: (866) 926-5671

Halifax • Montreal • Ottawa • Toronto • Winnipeg
Regina • Saskatoon • Calgary • Edmonton • Vancouver