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 2003 Online Course

12 Month Subscription - $35
Live Mentor +$30

Summary:
This series is designed for beginning and intermediate Excel users. This series teaches learners about creating and editing spreadsheets, what's new in the 2003 version, the Excel interface, navigating, editing, and working with text, values, and formulas, printing, formatting, creating charts and databases, and using images and hypertext in a spreadsheet.

Audience:
This series is for anyone who wants to get the most out of using Excel 2003.

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
●  sA Skill Assessment

Topics included in this course:
Excel 2003 Series: Getting Started
Excel 2003 Series: Creating a Spreadsheet
Excel 2003 Series: Formatting Data
Excel 2003 Series: Editing and Printing Worksheets
Excel 2003 Series: Managing Worksheets
Excel 2003 Series: Charts and Databases
Excel 2003 Series: Hypertext and Tips

Excel 2003 Series: Getting Started
Summary: Time: 3.0 hour(s)
This course provides an overview of the use of the Excel 2003 interface and new product features.

Objectives:
After completing this course, students will be able to:
Identify the parts of the Excel interface
Start and exit Excel
Use menus to execute commands
Move around the workbook window
Search for help topics

Topics:
What is Excel
Cells and worksheets
Opening Excel
Toolbars
The Formula bar and worksheet window
The Status bar, task panes, and scrolling
Moving in the worksheet
Using menus
Shortcut menus and dialog boxes
Getting help
Online help and exiting Excel
top

Excel 2003 Series: Creating a Spreadsheet
Summary: Time: 4.0 hour(s)
This course shows you how to input data to an Excel spreadsheet.

Objectives:
After completing this course, students will be able to:
Input text, values, and formulas
Edit data
Use the speech and handwriting recognition features
Use AutoCorrect, AutoFill, and AutoSum
Retrieve backup files following a system crash

Topics:
Data entry
Text and values
Fixed decimal places
Dates and formulas
Complex formulas
Editing cells
Speech recognition
Dictation and voice command
Handwriting and AutoComplete
Using AutoFill
Special symbols and shortcuts
Using functions
Using AutoSum
Saving your worksheet
top

Excel 2003 Series: Formatting Data
Summary: Time: 3.0 hour(s)
This course provides information about formatting the cells and tables of your Excel worksheets.

Objectives:
After completing this course, students will be able to:
Use AutoFormat
Apply different number formats
Change the size of rows and columns
Change fonts and font sizes
Modify the alignment of cell entries
Add borders, shading, and colors to cells

Topics:
Selecting cells
Using AutoFormat
Moving toolbars
Using the Format Cells dialog box
Dates and special numbers
Calibrating columns
Changing fonts
Altering the alignment
Altering cell appearances
Patterns and format painter
top

Excel 2003 Series: Editing and Printing Worksheets
Summary: Time: 5.0 hour(s)
This course provides the user with information on editing and printing worksheets in Excel 2003.

Objectives:
After completing this course, students will be able to:
Find and open a workbook
Edit a workbook
Find and correct errors
Prepare a workbook for printing
Print a workbook

Topics:
Opening workbooks
Finding files
Using the Search task pane
Undo and redo
Editing with drag and drop
Copying formulas
Cut, copy, and paste
Deleting and inserting cells
Correcting errors
Print preview
Selecting print options
Page setup
Headers and footers
Setting sheet options
Controlling page breaks and formulas
top

Excel 2003 Series: Managing Worksheets
Summary: Time: 4.0 hour(s)
This course shows users how to view and manage information in a worksheet.

Objectives:
After completing this course, students will be able to:
View information in a worksheet
Insert comments
Use Find and Replace
Protect a worksheet
Manage multiple worksheets
Create a summary worksheet

Topics:
Viewing worksheets
Headings
Comments
Assigning names
Find and replace
Researching and calculating
Protecting your work
Maintaining multiple worksheets
Editing multiple worksheets
Naming and arranging sheets
Manipulating worksheet windows
Comparing and copying worksheets
Summary worksheets
top

Excel 2003 Series: Charts and Databases
Summary: Time: 4.0 hour(s)
This course teaches the user how to add charts and graphics to worksheets, and how to create and manage databases using Excel 2003.

Objectives:
After completing this course, students will be able to:
Create charts using Chart Wizard
Insert clip art into a worksheet
Create your own graphics
Create a database
Manage a database

Topics:
Using the Chart Wizard
Editing charts
Changing the chart options
Adding images
WordArt and organizational charts
Grouping and hiding images
Creating a database
Adding e-mail and Web addresses
Viewing and finding records
Sorting records
Using AutoFilter
Custom AutoFilters
top

Excel 2003 Series: Hypertext and Tips
Summary: Time: 3.0 hour(s)
This course provides information about the Web functions available in Excel.

Objectives:
After completing this course, students will be able to:
Add hyperlinks to Excel worksheets
Follow and edit hyperlinks
Save static and interactive Web pages in Excel
Edit Web pages
Send Excel workbooks in e-mail

Topics:
Adding hyperlinks to a workbook
Following hyperlinks
Editing hyperlinks
Saving a static Web page
Interactive Web pages
Interactive databases and charts
Editing Web pages
Saving and sending worksheets
Top ten features
Top ten beginner basics
Ten commandments of Excel 2003
top

12 Month Subscription - $35
Live Mentor +$30