Microsoft Excel 2000 Advanced: Collaboration Tools and Templates

Overview/Description
This course, Microsoft Excel 2000 Advanced: Collaboration Tools and Templates, presents advanced techniques for sharing and revising worksheets, working with templates, and performing advanced workbook techniques.

Target Audience
This course requires that you have a working knowledge of intermediate Excel operations.

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

Objectives:

Working with Collaboration Tools

  • Annotate a worksheet with comments
  • Monitor development with change tracking
  • Share workbooks for group use
  • View and edit workbook properties

    • Standardizing Workbooks with Templates

  • Use Excel's built-in templates
  • Create a new template
  • Test a template

    • Advanced List Techniques

  • Manipulate records in a list
  • Perform calculations in a list
  • Query external databases
  • Create a data map

    • Additional MOUS Topics

  • Preview and print multiple worksheets
  • Use add-in programs
  • Record and run macros
  • Assign macros to buttons
  • Create interactive PivotTables for the Web


    • Course Number: MOFF0116