Microsoft Excel 2002- Level 1 - Computer Solutions s.c. - Swift Current, Saskatchewan providing training, support, Web design, accounting software setup and support

Microsoft Excel 2002 - Level 1
Course Outlines	Course Schedule

Course Description

This course is designed to take a new user through the process of creating and formatting spreadsheets. The student will learn how to enter data, select blocks, move cells, and work with basic formulas. Limited time will be spent on multiple worksheets and charting. This course is ideal for those people who have used spreadsheets made by other people but have never been able to create their own spreadsheets. The student will be able to develop his/her own spreadsheets and also work within and understand better the spreadsheets made by other users.

Course Objectives

Ø To learn and become comfortable creating and formatting workbooks and to become familiar with moving through Excel’s menus and tool bars.

Ø Learn the different techniques available for entering data into Excel, moving, copying, and deleting cells and how to format cells as well.

Ø Become familiar with entering basic formulas within the spreadsheet, including using the speedy formulas with the AutoSum button. Learn how to copy formulas and how to use the Formula Palette to enter and edit formulas.

Ø Discover how to use and link multiple worksheets.

Ø Learn the basics of this program so that the user can productively use any windows based spreadsheet program.

Duration

The duration of the course is one day. This day begins at 9:00 am and ends at 4:30 pm.

Table of Contents

I	Excel’s Screen
II	Moving Through Excel Sheets & Menus
	A.	Moving Through Sheets
	B.	Excel’s Pull Down Menus
	C.	Excel’s Toolbars
	D.	Excel’s Shortcut Menu’s
III	Entering Data in Excel
	A.	Spreadsheet Strategies
	B.	Entering Information
	C.	Correcting Cell Information
	D.	Using Undo & Repeat
	E.	Deleting or Clearing Cells
IV	Block Selection & Cell Moving
	A.	Learning How to Select Information
	B.	Moving & Copying Using Drag & Drop
V	Working with Files
	A.	Saving a Workbook File
	B.	Creating a New Workbook
	C.	Opening Workbook Files
	D.	Closing Files
	E.	Arranging & Finding Document Windows

VI	Basic Excel Formulas
	A.	Entering Formulas
	B.	Cell Ranges & Cell Pointing Techniques for Formulas
	C.	Speedy Formulas with the AutoSum Button
	D.	Copying Cells and Formulas
VII	Workbook Formatting
	A.	Widening or Shortening columns or rows.
	B.	Cell Alignment
	C.	Inserting / Deleting Rows & Columns
	D.	Number Formatting of Cells
	E.	Fonts, Borders and Patterns
VIII	More on Formulas and Functions
	A.	Understanding Relative vs. Absolute Cell Referencing
	B.	Using the Formula Palette to enter and edit formulas
	C.	Collapsible Dialogue Boxes
	D.	The Range Finder
IX	Printing Worksheets
	A.	Steps for Printing
	B.	Forced Page Break
X	Using Multiple Workbook Sheets
	A.	Sheets
	B.	Linking Sheet Data with Formulas
XI	Charting Basics

Relevant Links

MS Excel Level 2

MS Excel Level 3

Software Support