Custom Search

MS Office 2000: Excel for Experts I

Excel

Serebra Learning Corporation
Training Provided by Serebra Learning Corporation This course teaches the student how to customize the Excel interface, automate tasks and perform complex calculations. The student will also look at generating customized reports to facilitate analysis and decision-making.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
study at homeThis course may be available for home-study
web-based,online cbt,cdweb-based,online cbt,cd
Contact Serebra Learning Corporation for more information
Duration:10 hours
Training Presented in:English
MS Office 2000: Excel for Experts I
MS Office 2000: Excel for Experts I
Course Code NT2890

Outline

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

Description

This course teaches the student how to customize the Excel interface, automate tasks and perform complex calculations.  The student will also look at generating customized reports to facilitate analysis and decision-making.

Audience

This course is targeted at students who need to use Excel 2000 effectively for generating reports.  This course is also intended for students preparing for the MS Excel 2000 Expert (MOUS) Exam.

Prerequisites

To benefit completely from this course, the student should be a proficient user of Excel. The student can acquire these skills from the preceding   two courses: · MS Office 2000: Excel for Professionals - I · MS Office 2000: Excel for Professionals - II

Objective

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

customize built-in toolbars and menus

  • create custom toolbars and menus
  • create templates
  • use built-in data forms
  • customize data entry
  • manage macros
  • perform calculations using formulas and functions
  • customize print settings
  • print worksheets, workbooks and charts
  • extract selective data using filters
  • customize data display
  • create charts using the Chart Wizard
  • insert graphics from ClipArt
  • draw objects using the Drawing toolbar
  • Topics Include

    Generating Reports

    • Performing Calculations
    • Printing Reports

    Enhancing Reports

    • Customizing Reports
    • Using Graphical Tools

    Enhancing Worksheet Functionality

    • Customizing Excel Interface
    • Customizing Data Entry
    • Enhancing Calculations
    • Managing Macros

    Duration

    10 hrs

    Minimum Requirements

    IBM 486 DX or compatible, 16MB RAM, Soundblaster (or compatible) sound card, 2 x CD ROM drive, 25MB free hard disk space, Windows 3.1 or Windows 95.

    Media

    CDROM
    Web Based Training

    © Copyright Serebra Learning Corp., 2002

    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...
    Advertise With Us
    Want to market your reports training?