|
Provided by: Seletel Informatique Excel 2000 MOSExcel |
 |
Online
Certificate Program
Provided by Seletel Informatique
This series is designed to help users prepare for the MOS Excel Core examination. The series begins with basic Excel tasks, such as entering and editing data, using Find, Replace, and AutoFill, and creating hyperlinks. It also covers locating, opening, and saving files, and using the help function, Office Assistant. Formatting worksheets is covered in detail, including cell and number formatting, adjusting rows and columns, and the use of AutoFormat, styles, and Format Painter. More advanced topics covered include page setup, managing worksheets and data, and creating formulas and functions. An overview of charts and objects, including the Chart Wizard, is also provided.
|
|
||||||||||||
Excel 2000 MOS
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
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
About The Training Provider: Seletel Informatique
Seletel Informatique - Are you looking for a way to master skills that doesn't involve time-consuming classroom attendance? Are you looking for a way to train yourself at a lower cost? Need some qualifications for a job? Need to train your employees? Try our solution. When you register for an online course you will receive one year of unlimited access to your online computer training course.
High quality online...
