Online Excel 2003 Training

Microsoft » Microsoft Excel

Only $99.95

ONLINE Excel 2003 TRAINING FEATURES

  • Learn Excel 2003 online with these interactive online Excel 2003 courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the Excel 2003 courses
  • Retake the Excel 2003 courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test
  • Excel 2003 Series (26 hours)

1. Excel 2003:1 Getting Started

Time: 3 hours
This course provides an overview of the use of the Excel 2003 interface and new product features.

Objectives

  • 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


2. Excel 2003:2 Creating a Spreadsheet

Time: 4 hours
This course shows you how to input data to an Excel spreadsheet.

Objectives

  • 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


3. Excel 2003:3 Formatting Data

Time: 3 hours
This course provides information about formatting the cells and tables of your Excel worksheets.

Objectives

  • 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


4. Excel 2003:4 Editing and Printing Worksheets

Time: 5 hours
This course provides the user with information on editing and printing worksheets in Excel 2003.

Objectives

  • 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


5. Excel 2003:5 Managing Worksheets

Time: 4 hours
This course shows users how to view and manage information in a worksheet.

Objectives

  • 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


6. Excel 2003:6 Charts and Databases

Time: 4 hours
This course teaches the user how to add charts and graphics to worksheets, and how to create and manage databases using Excel 2003.

Objectives

  • 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


7. Excel 2003:7 Hypertext and Tips

Time: 3 hours
This course provides information about the Web functions available in Excel.

Objectives

  • 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



Resources for Excel 2003

Student Login



  1. Forgot My Password
  2. Support

Live eLearning

Like a class you would go to, but you don't have to go anywhere

More...

Try a Free Course

Click here to try a free course.

Partners & Resources
  1. View Partners & Resources
  2. Become a Partner
© Webucator, Inc. All rights reserved. | Toll Free: 877-932-8228 | UK: 0808-101-3484 | From outside the USA: 315-849-2724| Fax: 315-849-2723