computer training image
Online Training Classes Purchased Securely
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout
Online Payments

Benefits of Computer Coach's online computer training classes

  • Accessible 24 hours a day 7 days a week, so you can learn when you have time.
  • Cost-effective solutions, so you don’t go broke learning the skills you need.
  • Available Anytime, anywhere with an Internet connection, so you can study at your house, office, or where you feel comfortable.
  • Interactive & fun courses allow for greater retention of course topics.
  • Easy to use so you can start learning right away.
  • Full of hands-on labs so you can get the practice you need
  • HTML Based so you don’t need any additional downloads
  • Live Mentor Available to ask questions and get clarification

online computer training questions answered

Excel 2000 Online Course

12 Month Subscription - $35
Live Mentor +$30

Summary:
This 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.

Certification:
MOS

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

Features:
●  Exercises that allow users to practice the application
●  A file containing the text of the exercises
●  Simulations that allow users to practice course skills, even if they don't have access to the application
●  A glossary
●  A Skill Assessment

Topics included in the course:
Excel 2000 : Working with Cells
Excel 2000 : Working with Files
Excel 2000 : Formatting Worksheets
Excel 2000 : Page Setup and Printing
Excel 2000 : Worksheets and Workbooks
Excel 2000 : Formulas and Functions
Excel 2000 : Charts and Objects

Excel 2000 : Working with Cells
Summary: Time: 4.0 hour(s)
This course shows how to enter and edit data in Excel 2000 worksheet cells and how to create hyperlinks.

Objectives:
After completing this course, students will be able to:
Enter data
Edit one or more cells
Find and replace values
Use the AutoFill feature to create series
Create and edit hyperlinks

Topics:
Entering Data
Editing a Cell
Editing Multiple Cells
Replacing Values and AutoFilling
Creating Hyperlinks
top

Excel 2000 : Working with Files
Summary: Time: 3.0 hour(s)
This course shows how to locate, open, and save files in Excel 2000.

Objectives:
After completing this course, students will be able to:
Open files
Save files
Send a workbook via e-mail
Save a worksheet or workbook as a Web page
Use the Office Assistant

Topics:
Opening Files
Saving Files
Files and the Internet
Using the Office Assistant
top

Excel 2000 : Formatting Worksheets
Summary: Time: 4.0 hour(s)
This course shows how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2000 worksheet.

Objectives:
After completing this course, students will be able to:
Format cells
Adjust alignment and indentation of text in cells
Adjust rows and columns
Format numbers
Use the AutoFormatting feature
Define, apply, and remove a style

Topics:
Formatting Cells
Adjusting Cells
Adjusting Rows and Columns
Formatting Numbers
Using AutoFormatting and Styles
top

Excel 2000 : Page Setup and Printing
Summary: Time: 2.0 hour(s)
This course shows how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in Excel 2000 worksheets.

Objectives:
After completing this course, students will be able to:
Preview worksheets, workbooks and Web pages
Change page setup
Set up headers and footers
Set print options
Print worksheets, workbooks, and selections

Topics:
Previewing
Page Setup
Headers, Footers, and Titles
Printing
top

Excel 2000 : Worksheets and Workbooks
Summary: Time: 3.0 hour(s)
This course shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in Excel 2000 worksheets.

Objectives:
After completing this course, students will be able to:
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

Topics:
Working with Rows and Columns
Working with Worksheets
Linking Worksheets and Consolidating Data
Zooming and Spell-Checking
top

Excel 2000 : Formulas and Functions
Summary: Time: 3.0 hour(s)
This course shows how to work with formulas and functions in Excel 2000 worksheets.

Objectives:
After completing this course, students will be able to:
Enter and revise formulas
Use absolute and relative references
Use the AutoSum feature
Enter and use basic functions
Enter and use date functions, financial functions, and logical functions

Topics:
Working with Formulas
Using References and AutoSum
Entering Functions
Using Basic and Date Functions
Using Financial and Logical Functions
top

Excel 2000 : Charts and Objects
Summary: Time: 2.0 hour(s)
This course shows how to create, modify, and print charts; insert, move and delete pictures, and draw lines and shapes in Excel 2000 worksheets.

Objectives:
After completing this course, students will be able to:
Use the Chart Wizard to create a chart
Modify charts
Preview and print charts
Insert, move, and delete an object (picture)
Create and modify lines and objects

Topics:
Creating Charts
Modifying and Printing Charts
Working with Objects
Drawing Lines and Shapes
top

12 Month Subscription - $35
Live Mentor +$30