Excel 2000: Module II
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
Each
student This
allows students to detect any weak areas that they may have and enables them
to seek out the assistance of the instructor |