Learn Online with StaffKit Training Courses
Online Employee Business and Computer Training

Excel 2002 Training


Summary:

This series is intended as preparation for the Excel 2002 Microsoft Office User Specialist (MOUS) Core Proficiency exam. It introduces Excel's newest enhancements such as task panes for New Documents, Clipboard, Search, and Insert Clip Art; the Ask a Ques

This Excel 2002 online training series provides over 22 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:

1 . Charts and Objects
2 . Formatting Worksheets
3 . Formulas and Functions
4 . Page Setup and Printing
5 . Working with Cells
6 . Working with Files
7 . Worksheets and Workbooks

Lesson Detail:

Charts and Objects
This course shows users how to create, modify, and print charts, insert, move and delete pictures, and draw lines and shapes in Excel 2002 worksheets.


  • Creating Charts
  • Modifying and Printing Charts
  • Working with Objects
  • Drawing Lines and Shapes

Formatting Worksheets
This course shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet.


  • Formatting Cells
  • Adjusting Cells
  • Formatting Numbers
  • Adjusting Rows and Columns
  • Using AutoFormatting and Styles

Formulas and Functions
This course shows users how to work with formulas and functions in Excel 2002 worksheets.


  • Working with Formulas
  • Using References and AutoSum
  • Entering Functions
  • Using Basic and Date Functions
  • Using Financial and Logical Functions

Page Setup and Printing
This course shows users how to preview and print worksheets and workbooks, add headers, footers, and titles, and adjust page settings in Excel 2002 worksheets.


  • Previewing
  • Printing
  • Page Setup
  • Headers, Footers, and Titles

Working with Cells
This course shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks.


  • Entering Data
  • Editing a Cell
  • Editing Multiple Cells
  • Replacing Values and AutoFilling
  • Creating Hyperlinks

Working with Files
This course shows users how to locate, open, and save files in Excel 2002.


  • Opening Files
  • Saving Files
  • Files and the Internet
  • Working with Comments
  • Using the Office Assistant

Worksheets and Workbooks
This course shows users how to work with worksheet rows and columns, move between worksheets in a workbook, consolidate data, change the zoom setting, and check spelling in Excel 2002 worksheets.


  • Working with Rows and Columns
  • Working with Worksheets
  • Linking Worksheets and Consolidating Data
  • Zooming and Spell-Checking
  • Using a Data Filter

Certification:
Excel 2002


Audience:
This series is for anyone preparing for the MOS Excel 2002 Core certification exam.


Features:

  • Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
  • Activities allow learners to apply course concepts in an interactive questioning environment.
  • Exercises allow learners to practice in the actual application being studied.
  • Supplied sample files include sample documents, application files, programs, and programming code that enable learners to practice with these files, enhancing the learning experience.
  • A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
  • Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
  • Search text enables learners to rapidly search all text within a course to easily retrieve information required.
  • Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
  • A skill assessment generates a customized learning path based on the results of a pre-test.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Bookmarking tracks the learner's progress in a course.

Technical Requirements:


What You Get:

You will receive Unlimited Access to all of the Excel 2002 training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.


Web-Based Training Products:


Excel 2002 Online Training Series

Only $49.95    staffkit

You might also be interested in our Desktop Computing Package which includes all of the Excel 2002 training courses listed above plus hundreds of hours of related online training courses

 

Desktop Computing Package

Only $139.95   staffkit

Excel 2002
Training Series
Total Courses: 7
Total Time: 22+ hours
$99.95
Only $49.95
Available in Package only
Total Courses: 381
Total Time: 1119+ hours
$399.99
Only $139.95
Satisfaction Guaranteed    BBB Online Accredited Business          Fruad Protection Guaranteed By American Express            Paypal World Seller

Reviews:

'offers employers an excellent way to train their staff economically and without having to send them out of the office.'
HRMReport.com

'this is a must have resource'
California Technology Magazine

'this is theUltimate
Career Development
Package.'
MidWest Technology Journal

Read more customer
reviews about our
e-learning training tutorials

StaffKit offers a centralized e-learning solution for business, computer, technical, compliance and employee training.
Copyright © 2001-2014 StaffKit All Rights Reserved