Microsoft Excel 97

		Course Schedule
		Course Outlines
		Website Design
		Software Support
		Surfing the Internet
		Services Offered

(306) 773-3949

Home

Services We Offer
What's New
Newsletter
About Us
Upcoming Courses
Course Outlines
Website Design
Surfing The Internet
Links
FAQ

Microsoft Excel ’97 - Level 1

Course Schedule - Course Outlines

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 their 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.

Course Length	Recommended Prerequisites
1 day	The only prerequisite is to have some experience or skills already with operating the mouse through Windows ‘95/’98.

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

VI 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

VI 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

VII Printing Worksheets

A. Steps for Printing

B. Forced Page Break

VIII Using Multiple Workbook Sheets

A. Sheets

B. Linking Sheet Data with Formulas

IX Charting Basics