lmayer@elgin.edu

Multiple Worksheets

Tutorial 6 Objectives:

After completing Tutorial 6, students will be able to:

  • Use Multiple Worksheets
  • Consolidate Data from Multiple Worksheets Using a 3-D Reference
  • Print Worksheet Groups
  • Use Templates
  • Create a Workbook Based on a Template
  • Create and Save a Custom Workbook Template
  • Use Data from Multiple Workbooks
  • Manage Multiple Workbooks
  • Work with Linked Workbooks
  • Work with a List of Links
  • Use Lookup Tables
  • Create an Excel Workspace

Click here for presentation

Click here for Key Terms.

Homework: Case Problem 1 page EX 293
                           Case Problem 4 page EX 297 steps 1-3

     

Previous Lecture         Next Lecture