Custom Search

Advanced Tools of MS Excel 2000

Excel

Serebra Learning Corporation
Training Provided by Serebra Learning Corporation This course is the third course in a series of three in the Excel 2000 curriculum. This course covers the creation of PivotTables, PivotCharts, macros, and databases. The course introduces students to maps and templates in Excel. The course also describes linking of office documents with object linking and using hyperlinks with other office documents.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Duration:3 hours
Training Presented in:English
Advanced Tools of MS Excel 2000 Course Outline - IP0570 - Advanced Tools of MS Excel 2000

Advanced Tools of MS Excel 2000

Course Code IP0570

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 third course in a series of three in the Excel 2000 curriculum.  This course covers the creation of PivotTables, PivotCharts, macros, and databases.  The course introduces students to maps and templates in Excel.  The course also describes linking of office documents with object linking and using hyperlinks with other office documents.

Audience

Application developers who plan, design and implement distributed Excel applications.

Prerequisites

(Currently no course prerequisite information)

Objective

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

create charts using the Chart Wizard

  • format charts in Excel
  • create maps in Excel
  • customize Excel maps
  • create a PivotTable
  • modify the arrangement of data in a PivotTable
  • format a PivotTable
  • create PivotCharts in an Excel worksheet
  • create a PivotChart from a PivotTable
  • create macros for automating tasks
  • create templates
  • create databases in Excel
  • manage databases in Excel
  • link office documents with object linking
  • use hyperlinks with other office documents
  • Topics Include

    Excel Charts and Maps

    • Creating Charts in Excel
    • Customizing Charts in Excel
    • Creating Maps in Excel

    PivotTables and PivotCharts

    • Creating PivotTables
    • Creating PivotCharts

    Macros and Databases

    • Creating Macros and Templates
    • Managing Excel Databases
    • Using Excel Objects

    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 West Hastings, Vancouver, BC    V6C 2W2 Canada
    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...
    tcw11-gfc-v396M-10/25/09-10:39:28-()[A]-[B]-[A] -06:16:57