Excel 2000 MOS online training courses
Total Courses: 7    Estimated Training Time: 21 Hour(s)

Summary

1 Year Unlimited access to all 7 courses listed below, includes over 21 hours of online courseware.

This Excel 2000 online training series is designed to help users prepare for the MOS Excel Core examination. The series begins with basic Excel tasks, such as entering and editing data, using Find, Replace, and AutoFill, and creating hyperlinks. It also covers locating, opening, and saving files, and using the help function, Office Assistant. Formatting worksheets is covered in detail, including cell and number formatting, adjusting rows and columns, and the use of AutoFormat, styles, and Format Painter. More advanced topics covered include page setup, managing worksheets and data, and creating formulas and functions. An overview of charts and objects, including the Chart Wizard, is also provided.

Current Price: $29.95 | List Price: $99.95

This Excel 2000 online training series provides 21 hours of self-paced courseware. This web-based training provides 1 year of unlimited access to all of the following lessons:

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

Lesson Detail:

  • Excel 2000: Working with Cells
    This course shows how to enter and edit data in Excel 2000 worksheet cells and how to create hyperlinks.

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

  • Excel 2000: Working with Files
    This course shows how to locate, open, and save files in Excel 2000.

    • Opening Files
    • Saving Files
    • Files and the Internet
    • Using the Office Assistant

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

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

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

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

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

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

  • Excel 2000: Formulas and Functions
    This course shows how to work with formulas and functions in Excel 2000 worksheets.

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

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

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

Certification

Excel 2000

Audience

This series is for anyone preparing for the MOS Excel 2000 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

  • Internet connection
  • Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
  • Authorware and Macromedia Flash player recommended but not required.
  • JavaScript must be enabled.

What You Get

You will receive Unlimited Access to all of the Excel 2000 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 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisifed online learning customers in over 50 countries. We have been providing web based training for the past 9 years.

Web-Based Training Products

You might also be interested in our Desktop Computing Package which includes all of the Excel 2000 training courses listed above plus over 749 hours related training courses

Desktop Computing

Want to learn computer basics? Find out how to use common desktop computing applications like Microsoft Word, Excel, PowerPoint, Access, and Outlook. Learn about operating systems, the Internet, and more. Even prepare for Microsoft Office Specialist certification exams!

70 Series

Price: $89.95