Data Management in MS Excel 2000

Course Code IP0560

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 is the second course in a series of three in the Excel 2000 curriculum.  This course teaches the students how to effectively work with and manage data in Excel 2000.  The tasks involved in working and managing data include formatting data, performing calculations, using functions to perform calculations, and sorting, summarizing, and analyzing data using Excel.

Audience

End users who are familiar with the GUI environment and need to use numeric data for performing mathematical calculations and data analysis.

Prerequisites

The student should be familiar with MS Office products and Windows 95/98 operating systems and be able to work in GUI environments.  The student should also possess a basic knowledge of Excel 2000, and should be able to create basic Excel workbooks.

Objective

Upon completion of this course the student will be able to:

format cells in a worksheet

Topics Include

Data Formatting

• Basic Data Formatting
• Advanced Data Formatting

Formulas and Functions

• Working with Formulas
• Basic Excel Formulas
• Advanced Excel Formulas

Data Management

• Sorting Data
• Summarizing Data

Data Analysis

• Auditing Data
• Working with Scenarios and Reports

Duration

3 hrs

Minimum Requirements

Netscape or Internet Explorer (versions 4.0 or higher).   Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display; Macromedia Shockwave Version 6.02 or higher.

Media

Web Based Training