Microsoft Excel 2000 Expert User

Course Code NGE72032

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This course provides participants the knowledge to use the advanced features of Microsoft Excel 2000. At the completion of this course, students will learn how to create and use templates; retrieve, sort and manipulate data from a list; create and modify shared workbooks; and analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools.

Audience

This course is intended for end users that are looking to use the fundamental features of Microsoft Excel 2000. Participants should have completed Microsoft Windows 98 Fundamentals (Course 71011) or have equivalent knowledge, Microsoft Excel 2000 Fundamentals (Course 72030) and Microsoft Excel 2000 Proficient User (Course 72031).

Prerequisites

(Currently no course prerequisite information)

Objective

• Create and use templates.
• Retrieve, sort and manipulate data from a list.
• Create and modify shared workbooks.
• Analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools.

Topics Include

Unit 1: Template and Database Integration

• Create a template based on a workbook.
• Create a workbook based on an existing template.
• Modify a template.
• Open a workbook based on a Spreadsheet Solutions template.
• Customize a Spreadsheet Solutions template.
• Enter a record in a list.
• Retrieve specific data in a list by using a criteria.
• Apply filters to a list.
• Summarize the data in a list.
• Query a database.
• Open a table within a database.
• Extract field data from an open database query.
• Define a criteria for retrieving specific data from the selected fields in a database query.
• Run a Web query.

Unit 2: Workbook Capabilities

• Create a shared workbook.
• Highlight changes within a shared workbook.
• Accept or reject changes in a shared workbook.
• Display the history of changes made in a shared workbook.
• Merge the changes from one workbook into another workbook.
• Move and copy data from one workbook to another.
• Paste attributes from one workbook to another.
• Link cells in separate workbooks.
• Open two linked workbooks.

Unit 3: Data Analysis and Summary

• Create a data map.
• Match the Data Map toolbar buttons with their functions.
• Add a text label to a data map.
• Add a pop-up label to a data map.
• Modify the colors, symbols, functions and sizing of the map data.
• Modify a legend text value or numeric value in a data map.
• Add the map features in a data map.
• Add pushpins to a data map.
• Create a pivot table.
• Match the buttons on the Pivot Table toolbar with their functions.
• Modify the pivot table data.
• AutoFormat the pivot table data.
• Consolidate data in a pivot table.
• Create an interactive pivot table for the Web.
• Add a field to an interactive pivot table.
• Show grand totals in a pivot table report.
• Insert subtotals in a list.
• Change the summary function in a pivot table.
• Change the calculation type in a pivot table.
• Create a chart in a new sheet.
• Hide and display the detailed data of a cell.
• Add a record in a list.
• Sort a list in the data table.
• Apply filters to a data list by hiding rows/columns that do not match your criteria with columns/rows labels.
• Validate data to stop incorrect entries by displaying a message for the incorrect data entry in a data table.
• Create a scenario in the data table.
• Modify an existing scenario in the data table.
• Merge scenarios in the data table from one workbook to another.
• Delete a scenario in the data table.
• Change the values of a cell in the data table.
• Solve a problem of a cell in the data table.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

Web Based Training