Microsoft Excel 2002 Expert: Customizing Data Management

Microsoft Excel 2002 Expert: Customizing Data Management

Overview/Description
Efficiency is the name of the game in today's fast paced world, especially when it comes to managing financial data. Templates, customized toolbars and menus, data summaries, and data consolidation are important skills for being more productive in less time. This course provides learners with the skills to customize the Excel 2002 environment, summarize data, and manage workbooks This course is also designed to prepare users for the Excel Expert 2002 MOUS certification exam.

Target Audience
This course is designed for Microsoft Excel 2002 users. Previous experience with Excel 2002 is recommended.

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

Objectives:

Customizing Excel

Add a button to an existing toolbar

Remove a button from an existing toolbar

Create a new toolbar

Add a menu item to an existing menu

Create a custom menu

Formatting Numbers

Create a custom number format

Apply a custom number format

Create a format for displaying numbers in thousands, millions, or billions

Apply conditional formats based on cell values

Apply conditional formats based on a formula

Summarizing Data

Prepare a list for using subtotals

Create a single-level subtotal

Create a multiple-level subtotal

Apply a simple filter

Apply a custom filter

Apply a Top 10 filter

Set up a criteria range

Apply an advanced filter based on multiple criteria

Apply grouping and outlining to a worksheet

Manage the level of detail in grouping and outlining

Set up custom views for grouping and outlining

Managing Workbooks

Create a template from an existing workbook

Create a new workbook based on a template

Edit and save a workbook template

Create a workspace based on a multiple-file layout

Save a workspace

Create worksheet consolidation by position

Create worksheet consolidation by category

Course Number: MOFF0214