LearnPro: Applying Excel 97

Course description

Overview: Students will learn how to create spreadsheets and charts, and how to use Excel’s database features.

Prerequisites: Students should understand the basics of Windows 95 and Excel. To acquire the Excel basics, students can complete the LearnPro Excel 97 QuickSkill CBT tutorials either before attending class or during the first half hour of class.

Skills List

Students are introduced to the following essential and extended skills in this course:

Essential Skills

Add cell borders

Adjust column width and row height

Align cell contents

Apply character formats

Change the worksheet’s active cell

Clear the contents of a cell

Copy and paste data

Copy formulas using the Edit, Fill command

Create formulas using AutoSum tool or SUM function

Create new, blank workbook file

Define a cell

Define and describe a spreadsheet

Enter data into cell

Enter formulas

Enter labels and values

Familiarity with chart environment

Familiarity with database environment

Familiarity with spreadsheet environment

Insert and delete rows and columns

Modify numeric formats

Move around the worksheet

Open, save (update), and/or close file

Preview printout

Print a worksheet

Save file with new name

Select cell and range of cells

Use absolute cell references in formulas

Use Microsoft Help examples and demos

Use relative cell references in formulas

Use Undo and Redo

Extended Skills

Center text across columns

Create an Average function

Create spreadsheet without detailed guidance

Sort data

Use brackets to control order of operation in formula

Use File, Page Setup command to alter worksheet appearance

Use the Chart Wizard to create a chart

Use the Sum function

Course content

Case 1: Initial Exploration

Group Session

Case 2: Marketing Analysis

Case 3: Office Expense Sheet

Case 4: Vehicle Mileage Log

Case 5: Assessing Average Sales

Case 6: Production Schedule

Case 7: Sales Analysis

Case 8: Weekly Income Schedule

Case 9: Feasibility Study

Case 10: Charting Budgets

Case 11: Creating and Sorting a Database

Case 12: Sorting Records

Case 13: What-If Analysis