|
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
only £50.00
(approx $88 USD)
|