◊ EXCEL 2002 ONLINE TRAINING SERIES
Online Excel 2002 Training
Microsoft » Office
Only $49.95
Excel 2002 Series (22 hours)
ONLINE TRAINING FEATURES
- Learn online with these interactive online courses.
- Affordable Pricing (Only $49.95 for the complete series)
- A full year to complete the courses
- Retake the 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. Working with Cells
Time: 4 hours
This course shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks.
Objectives
- Enter cell data including text, numbers, and formulas
- Edit cell data
- Insert, delete, and move cells
- Find and replace cell data and formats
- Create hyperlinks
Topics
- Entering Data
- Editing a Cell
- Editing Multiple Cells
- Replacing Values and AutoFilling
- Creating Hyperlinks
2. Working with Files
Time: 3 hours
This course shows users how to locate, open, and save files in Excel 2002.
Objectives
- Manage workbook files and folders
- Create workbooks using templates
- Save workbooks using different names and file formats
- Convert worksheets to Web pages
- View and edit comments
Topics
- Opening Files
- Saving Files
- Files and the Internet
- Working with Comments
- Using the Office Assistant
3. Formatting Worksheets
Time: 4 hours
This course shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet.
Objectives
- Apply and modify cell formats
- Modify row and column settings
- Use automated tools to format worksheets
- Apply styles
Topics
- Formatting Cells
- Adjusting Cells
- Formatting Numbers
- Adjusting Rows and Columns
- Using AutoFormatting and Styles
4. Page Setup and Printing
Time: 2 hours
This course shows users how to preview and print worksheets and workbooks, add headers, footers, and titles, and adjust page settings in Excel 2002 worksheets.
Objectives
- Preview and print worksheets and workbooks
- Modify Page Setup options for worksheets
Topics
- Previewing
- Printing
- Page Setup
- Headers, Footers, and Titles
5. Worksheets and Workbooks
Time: 4 hours
This course shows users how to work with worksheet rows and columns, move between worksheets in a workbook, consolidate data, change the zoom setting, and check spelling in Excel 2002 worksheets.
Objectives
- Modify row and column formats
- Modify worksheet names and positions
- Insert and delete worksheets
- Use 3-D references
- Check spelling
- Work with a subset of data by filtering lists
Topics
- Working with Rows and Columns
- Working with Worksheets
- Linking Worksheets and Consolidating Data
- Zooming and Spell-Checking
- Using a Data Filter
6. Formulas and Functions
Time: 3 hours
This course shows users how to work with formulas and functions in Excel 2002 worksheets.
Objectives
- Work with formulas
- Use references and AutoSum
- Enter Functions
- Use basic and date functions
- Use financial and logical functions
Topics
- Working with Formulas
- Using References and AutoSum
- Entering Functions
- Using Basic and Date Functions
- Using Financial and Logical Functions
7. Charts and Objects
Time: 2 hours
This course shows users how to create, modify, and print charts, insert, move and delete pictures, and draw lines and shapes in Excel 2002 worksheets.
Objectives
- Create, modify, position, and print charts
- Create, modify, and position objects
Topics
- Creating Charts
- Modifying and Printing Charts
- Working with Objects
- Drawing Lines and Shapes
Resources for Excel 2002
