HOME COURSES FAQS CONTACT
 

EXCEL 2003

 

Course Description

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.

 


  GETTING STARTED

top

Provides an overview of the use of the Excel 2003 interface and new product features.

  TOPICS COVERED

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


  CREATING A SPREADSHEET

top

Shows you how to input data to an Excel spreadsheet.

  TOPICS COVERED

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


  FORMATTING DATA

top

Provides information about formatting the cells and tables of your Excel worksheets.

  TOPICS COVERED

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


  EDITING AND PRINTING WORKSHEETS

top

Provides the user with information on editing and printing worksheets in Excel 2003.

  TOPICS COVERED

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


  MANAGING WORKSHEETS

top

Shows users how to view and manage information in a worksheet.

  TOPICS COVERED

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


  CHARTS AND DATABASES

top

Teaches the user how to add charts and graphics to worksheets, and how to create and manage databases using Excel 2003.

  TOPICS COVERED

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


  HYPERTEXT AND TIPS

top

Provides information about the Web functions available in Excel.

  TOPICS COVERED

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


only £99.00
(approx $150 USD)
 

 

 
 

Copyright 2003, Stonebridge Associated Colleges Ltd

HOME

COURSES FAQS CONTACT US