Excel 2000: Module II
Course Summary

Lesson 1: Reviewing the Basics

Approximate Time: 45

Exercise File(s) Needed: 2Quarterly Sales2.xls, 2Quarterly Sales3.xls, 2Sales Summary1.xls, and 2Sales Summary2.xls

Summary of Objectives: Students get started with Excel 2000, create worksheets, modify worksheets, format worksheets, print worksheets, work with basic formulas and functions, use multiple worksheets, enhance worksheets, use styles and AutoFormats, and work with charts

Lesson 2: Using Names

Approximate Time: 40

Exercise File(s) Needed: 2Parts.xls, 2Payroll1.xls, 2Salon1.xls, and 2Salon2.xls

Summary of Objectives: Students name cells, name formulas, check and list names and references, create 3-dimensional names, and work with ranges

Lesson 3: Working with Advanced Functions

Approximate Time: 40

Exercise File(s) Needed: 2Commission.xls, 2Grades1.xls, and 2Grades2.xls

Summary of Objectives: Students use the NOW function, use the DATE function, use the VLOOKUP function, use the IF function, use the PMT function, and use the FV function

Lesson 4: Working with Advanced Formatting Features

Approximate Time: 35

Exercise File(s) Needed: 2ManHours.xls, 2Voyager1.xls, and 2Voyager2.xls

Summary of Objectives: Students use advanced number formats, create custom number formats, and apply outlines

Lesson 5: Locating and Updating Data

Approximate Time: 15

Exercise File(s) Needed: 2Expenses.xls, 2HardSales1.xls, and 2HardSales2.xls

Summary of Objectives: Students find and replace data, and control recalculation

Productivity Builder 1

Approximate Time: 30

Exercise File(s) Needed: 2CompuMax.xls and 2Attendance.xls

Lesson 6: Using Special Format and Print Options

Approximate Time: 30

Exercise File(s) Needed: 2TimeCard.xls, 2MusicCatalog.xls, 2Report1.xls, 2Candy.xls, and 2Report2.xls

Summary of Objectives: Students format zero values, change the display of negative values, and use print options

Lesson 7: Protecting Worksheet Data

Approximate Time: 35

Exercise File(s) Needed: 2Pool.xls, 2Club1.xls, and 2Club2.xls

Summary of Objectives: Students use comments, use worksheet and range protection, hide and display data, and use password protection

Lesson 8: Manipulating the Screen Display

Approximate Time: 35

Exercise File(s) Needed: 2Photos.xls, 2Sounds.xls, 2Gifts1.xls, 2Restock.xls, and 2Gifts2.xls

Summary of Objectives: Students work with multiple workbooks, freeze worksheet panes, adjust the zoom setting, and work with toolbars

Lesson 9: Sharing Worksheet Data

Approximate Time: 40

Exercise File(s) Needed: 2WeddingList.txt, 2ChargeLog.txt, 2SeatingArrangements.xls, 2Repairs.xls, 2Expense2.xls, 2EmployeeExpenses.xls, 2Store342.txt, 2Store134.xls, 2Store214.xls, 2Store343.xls, and 2StoreMaster.xls

Summary of Objectives: Students import text files, export data to other applications, and link workbooks

Lesson 10: Automating Your Work

Approximate Time: 35

Exercise File(s) Needed: 2Turtles1.xls, 2Turtles2.xls, and 2Lumber1.xls

Summary of Objectives: Students work with existing templates, create templates, work with macros, and create custom lists

Productivity Builder 2

Approximate Time: 30
Exercise File(s) Needed: 2Quarterly.xls, 2TimecardJD.xls, 2TimecardHR.xls, and 2Timemaster.xls
Total Exercise File Size for Course: 728 KB
Approximate Length of the Course: 6 hours 50 minutes

Responsibility of the Student

Each student must study all information learned in the course after normal classroom hours so that he/she may gain a firmer grasp of the information covered.

This allows students to detect any weak areas that they may have and enables them to seek out the assistance of the instructor

Back to Course Outlines