Microsoft Excel 2002 Core: Worksheets, Workbooks, and Workgroups

Overview/Description
Description: Microsoft Excel 2002 is a powerful spreadsheet program. The Help system and the many intuitive features make Excel easy to learn and use. This course, Worksheets, Workbooks, and Workgroups, presents techniques for moving from simple worksheets to workbooks and workgroups.

Target Audience
This course is designed for Microsoft Excel 2002 beginners or those new to Microsoft Excel 2002. Prior experience with opening, editing, and formatting worksheets, along with using charts and other graphics, is recommended.

Expected Duration
This course, including the practice exercises, will take up to four hours to complete.

Objectives:

Printing in Excel

  • Print and use Print Preview
  • Set page breaks
  • Set print areas
  • Print a worksheet
  • Identify features available in Page Setup
  • Use Page Setup for header/footer settings
  • Use Page Setup for sheet and chart settings

    • Managing Workbooks

  • Use built-in templates to create workbooks
  • Move, print, and delete a file using Open or Save As
  • Use file and folder commands in Excel
  • Find workbooks and other files using Basic Search
  • Find workbooks and other files using Advanced Search
  • Select multiple worksheets
  • Insert and delete worksheets
  • Move and copy worksheets
  • Hide and display worksheets
  • Manipulate the appearance of worksheets

    • Using AutoShapes and 3-D Cell References

  • Draw AutoShapes
  • Draw lines and connectors
  • Select and deselect AutoShapes
  • Insert and edit text in AutoShapes
  • Move AutoShapes
  • Move connectors to different connection sites
  • Resize and rotate AutoShapes
  • Format AutoShapes using the Format AutoShape dialog box
  • Format AutoShapes using the Drawing toolbar
  • Hide worksheet gridlines
  • Align and distribute AutoShapes
  • Order stacks of AutoShapes
  • Group and ungroup AutoShapes
  • Size, move, and rotate groups of AutoShapes
  • Format groups of AutoShapes
  • Use 3-D references in formulas
  • Enter a formula that uses a 3-D reference
  • Change the worksheet range in a 3-D reference

    • Collaborating in Workgroups

  • Save worksheets and workbooks as Web pages
  • Edit and preview worksheets and workbooks saved as Web pages
  • Create a hyperlink to a file or Web page
  • Modify hyperlink destinations
  • Format hyperlinks
  • Move, copy, and delete hyperlinks
  • Insert and edit comments in worksheets
  • Display comments in worksheets
  • Size, move, copy, and delete comments
  • Format comments
  • Create, view, edit, and respond to discussion comments
  • Close, filter, and hide/show discussion information


    • Course Number: MOFF0213