Microsoft Excel 97 Advanced: Auditing, Analyzing Data, and Advanced Macros

Overview/Description
This course, Microsoft Excel 97 Advanced: Auditing, Analyzing Data, and Advanced Macros, presents advanced techniques for protecting and auditing workbooks, analyzing workbook data, and customizing the Excel environment.

Target Audience
This course requires that you have an intermediate knowledge of basic Excel operations.

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

Objectives:

Protecting and Auditing Workbooks

  • Protect groups of cells, worksheets, and entire workbooks from editing
  • Trace precedent and dependent cells
  • Trace errors in formulas
  • Create data validation rules and messages for worksheet cells
  • Create and remove workspace settings

    • Analyzing Data

  • Perform a what-if analysis using Goal Seek
  • Create and store scenarios
  • Use custom views
  • Outline a worksheet
  • Consolidate worksheets

    • Customizing Excel

  • Create and modify a toolbar
  • Change startup options
  • Modify standard options
  • Create and edit a template

    • Exploring Macros

  • Display and work with the personal macro workbook
  • Add macros to the menu bar
  • Attach macros to worksheet buttons


    • Course Number: MOFF0015