◊ EXCEL 2003 ONLINE TRAINING SERIES
Online Excel 2003 Training
Microsoft » Office
Only $99.95
Excel 2003 Series (26 hours)
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
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. 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. 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. 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. 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. 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. 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
