Microsoft Excel 2000 - 2003 Level 1 (S1N1)

In this course, you will explore worksheets and workbooks, learn to work in columns and rows, and to work with cell contents. You will create formulas and use function commands to manipulate data.

Course Outline

If you are new to Microsoft Excel 2000, 2002, or 2003, this course will teach you the fundamentals about spreadsheets. You will explore worksheets and workbooks, learn to work in columns and rows, and to work with cell contents. You will create formulas and use function commands to manipulate data. Finally, you will learn how to change the page setup, and to print your documents.

What You'll Learn

• Learn navigation skills to create and use Excel spreadsheets
• Organize columns and rows to accommodate information
• Edit the contents of cells to organize the information on your worksheet
• Calculate values using formulas and specify an exact address of a cell by creating an absolute cell reference
• Create formulas by typing functions or building 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

Who Needs to Attend

New users of Excel 2000/2002/2003

Course Outline

1. Getting Started with Microsoft Excel

• Understanding Spreadsheet Concepts
• Creating New Workbooks

2. Modifying the Worksheet

• Working with Columns and Rows
• Working with Cell Contents

3. Using Formulas and Functions

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

4. Formatting Worksheets

• Formatting Cells
• Formatting Worksheet Elements

5. Setting Print Options

• Changing the Page Setup
• Previewing the Workbook

Additional Details

Pre-Requisites

Certificates offered

Certificate of Completion

Cancellation Policy

We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted.

Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.

Map & Reviews

Global Knowledge
[ View Provider's Profile ]

Global Knowledge Edmonton
10050 - 112 Street
Suite 400
Edmonton, Alberta
Canada   T5K 2J1

Reviews

 

   

I am very disappointed with the handouts. I was told I could go online and download a copy of the manual, the problem is that I would like the printed copy of the manual. I chatted online with one of your technitian who was unable to help me. Then I was told someone would contact me by phone to help me. That never happened. When taking a training course, a person EXPECTS to leave the course with ALL the material.

Reviewed by Betty M. 2011