Microsoft Excel 2000: Advanced Workbooks and Customizing Excel

Overview/Description
Description: This course, Microsoft Excel 2000: Advanced Workbooks and Customizing Excel, presents advanced techniques for protecting and auditing workbooks, analyzing workbook data, and customizing the Excel environment.

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:

Protecting and Auditing Workbooks

  • Protect cells, worksheets, and workbooks
  • Audit worksheet content
  • Use data validation tools
  • Save a workspace
  • Control workbook access with passwords

    • Analyzing Workbook Data

  • Use PivotTables and PivotCharts
  • Modify a PivotTable
  • Create and modify a PivotChart
  • Work with Goal Seek and Scenarios to achieve desired results
  • Consolidate worksheets into a single report
  • Display a worksheet in outline format

    • Customizing the Excel Environment

  • Customize toolbars
  • Customize Excel views
  • Change Excel's default settings


    • Course Number: MOFF0115