Data Management in MS Excel 2000

Excel

Serebra Learning Corporation
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.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Duration:3 hours
Training Presented in:English
Training Provided by Serebra Learning Corporation
  • M asked: Hello What is the cost for this hour course? Can the person registered enter the site to work on the course at any time? thanks
Data Management in MS Excel 2000
Course Outline - IP0560 - Data Management in MS Excel 2000

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


click to enlarge

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

  • format data in a worksheet
  • format data with styles
  • perform simple calculations on data
  • write custom formulas
  • use financial functions to perform calculations
  • use date and time functions to perform calculations
  • perform advanced calculations using logical functions
  • use lookup functions to perform calculations
  • sort and filter lists
  • use the query wizard to extract data
  • summarize details stored in Excel worksheets
  • audit Excel workbooks
  • use goal seek to make decisions
  • create and compare scenarios
  • create custom reports
  • 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

    Serebra Learning Corporation, 1660 - 999 W Hastings St, Vancouver, BC, Canada   V6C 2W2
    Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490
    E-Mail: sales@serebra.com - Web Site: www.serebra.com
    About The Training Provider: Serebra Learning Corporation
    Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
    Custom Search
    tcw11-v473M-12/16/11-23:02:31-()[A]-[A]-[B] -11:04:48