ms excel 2000 tutorial training course online
excel 2000
training course

Excel 2000 Training: Worksheets and Workbooks

Excel 2000 Training: Worksheets and Workbooks shows how to work with worksheet rows and columns manage worksheets and consolidate data in Excel 2000 worksheets.

This training course is for anyone preparing for the MOUS Excel 2000 Core certification exam.
This is self-paced Excel 2000 training -- there are no books to purchase and no scheduled classes to attend.

Excel Training

Excel 2000

Formatting Worksheet

Setup and Printing

Worksheetd and Workbooks

Formulas and Functions

Charts and Objects

Importing Exporting Data

Templates Links Reports

Formatting Sorting Filtering

Macros and Toolbars

Validating and Auditing

Data Analysis Tools

Sharing and Security



Training Courses
Info and Order


Computer Training

Home Business
Opportunity Online

Home Based
Business Opportunity

Worksheets and Workbooks Course Objectives

  • Insert and delete rows and columns
  • Hide and unhide rows and columns
  • Freeze and unfreeze rows and columns
  • Move between worksheets in a workbook
  • Rename insert delete move and copy worksheets
  • Link worksheets consolidate data and check spelling

Worksheets and Workbooks Course Topics

  • Working with Rows and Columns
    • Inserting and deleting rows and columns
    • Hiding and unhiding rows and columns
    • Freezing and unfreezing rows and columns
    • Splitting a worksheet

  • Working with Worksheets
    • Moving between worksheets in a workbook
    • Renaming a worksheet
    • Inserting and deleting worksheets
    • Moving and copying worksheets

  • Linking Worksheets and Consolidating Data
    • Using 3-D references in a formula
    • Using 3-D references in a function
    • Using Paste Special

  • Zooming and Spell-Checking
    • Changing the zoom setting
    • Checking spelling

Our courses have special design features listed below:

  • Certificates of Completion
  • Instructional steps -- walk through a procedure
  • Exercises -- try it out
  • Notes - See additional information related to the topic in the text
  • Tips - See a different, faster, or easier way of doing something
  • Quick References - See a quick reference guide to the features introduced in a chapter
  • Details - Display more detailed information related to the current topic
  • Hotwords - See related information
  • Navigation Bar - Maneuver easily through the courses
  • Topics and Index -- with searching feature and hyper-links
  • Printable Exercises - PDF downloadable files
  • Sample Application Files - PDF downloadable files
  • Glossary
  • Skill Assessment - can be used for pre and post-testing -- tracking first try, best try and grade - if passed, green check mark will appear as 'mastered' - hyperlinks to units within the course to go back and re-take a certain unit again. Use as pre-test to determine which topics you want to focus on and to go directly into that unit.

Technical Requirements

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. Minimum Connection Speed: 28.8k. Authorware recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Sign up for our courses right now, and join the ranks of people who are taking financial advantage of the explosion in the Information Technology field.