◊ EXCEL 2000 MOS ONLINE TRAINING SERIES
Online Excel 2000 MOS Training
Microsoft » Office
Only $49.95
Excel 2000 MOS Series (21 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 how to enter and edit data in Excel 2000 worksheet cells and how to create hyperlinks.
Objectives
- Enter data
- Edit one or more cells
- Find and replace values
- Use the AutoFill feature to create series
- Create and edit 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 how to locate, open, and save files in Excel 2000.
Objectives
- Open files
- Save files
- Send a workbook via e-mail
- Save a worksheet or workbook as a Web page
- Use the Office Assistant
Topics
- Opening Files
- Saving Files
- Files and the Internet
- Using the Office Assistant
3. Formatting Worksheets
Time: 4 hours
This course shows how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2000 worksheet.
Objectives
- Format cells
- Adjust alignment and indentation of text in cells
- Adjust rows and columns
- Format numbers
- Use the AutoFormatting feature
- Define, apply, and remove a style
Topics
- Formatting Cells
- Adjusting Cells
- Adjusting Rows and Columns
- Formatting Numbers
- Using AutoFormatting and Styles
4. Page Setup and Printing
Time: 2 hours
This course shows how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in Excel 2000 worksheets.
Objectives
- Preview worksheets, workbooks and Web pages
- Change page setup
- Set up headers and footers
- Set print options
- Print worksheets, workbooks, and selections
Topics
- Previewing
- Page Setup
- Headers, Footers, and Titles
- Printing
5. Worksheets and Workbooks
Time: 3 hours
This course shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in Excel 2000 worksheets.
Objectives
- Insert and delete rows and columns
- Hide and unhide rows and columns
- Freeze and unfreeze rows and columns
- Move between worksheets in a workbook
- Rename, insert, delete, move, and copy worksheets
- Link worksheets, consolidate data, and check spelling
Topics
- Working with Rows and Columns
- Working with Worksheets
- Linking Worksheets and Consolidating Data
- Zooming and Spell-Checking
6. Formulas and Functions
Time: 3 hours
This course shows how to work with formulas and functions in Excel 2000 worksheets.
Objectives
- Enter and revise formulas
- Use absolute and relative references
- Use the AutoSum feature
- Enter and use basic functions
- Enter and use date functions, financial functions, 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 how to create, modify, and print charts; insert, move and delete pictures, and draw lines and shapes in Excel 2000 worksheets.
Objectives
- Use the Chart Wizard to create a chart
- Modify charts
- Preview and print charts
- Insert, move, and delete an object (picture)
- Create and modify lines and objects
Topics
- Creating Charts
- Modifying and Printing Charts
- Working with Objects
- Drawing Lines and Shapes
Resources for Excel 2000 MOS
