|
Provided by: 123-CBT Computer Based Training Excel 2000 Fundamentals |
 |
Training
Provided by 123-CBT Computer Based Training
Course Overview
This course provides participants with the fundamental skills to use Microsoft Excel 2000 on a daily basis in their workplace. At the completion of this course, students will learn how to create and save a new workbook; add and manipulate worksheets; enter and manipulate data in single and multiple cells; use formulas and functions; format workbooks, worksheets and cells; and change fonts and data formats.
Learn To:
- Create and save a new workbook.
- Add and manipulate worksheets.
- Enter and manipulate data in single and multiple cells.
- Use formulas and functions.
- Format workbooks, worksheets and cells.
- Change fonts and data formats.
Content Emphasis
Skills-Based
Audience
This course is intended for end users that are looking to use the fundamental features of Microsoft Excel 2000. Participants should have completed Microsoft Windows 98 Fundamentals (Course 71011) or have equivalent knowledge.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Getting Started
Duration: 2 - 3 Hour(s)- Start Microsoft Excel 2000.
- Identify the different parts of the Excel 2000 interface.
- Identify the new features in Excel 2000.
- Create a new workbook.
- Match the various components of the Save As dialog box with their respective functions.
- Save a workbook to a different location.
- Close a workbook.
- Match the various components of the Open dialog box with their respective functions.
- Open an existing workbook.
- Preview a worksheet.
- Open a workbook from a specific location.
- Search for a workbook to be opened.
- Insert a worksheet.
- Copy a worksheet in an existing workbook.
- Move a worksheet to an existing workbook.
- Delete a workbook.
- Rename a worksheet.
- Navigate a worksheet.
- View multiple worksheets/workbooks simultaneously.
- Customize the display of a worksheet.
- Link two worksheets.
- Access the Help system.
- Locate a solution to a problem by using the Office Assistant.
- Identify the functions of the different tabs in a Microsoft Excel Help window.
Unit 2: Working with Data
Duration: 2 - 3 Hour(s)- Enter data in a worksheet.
- Enable the AutoComplete feature.
- Reverse the last action performed on a worksheet.
- Enter formula in a specified cell.
- Edit a formula.
- Identify the application of different types of cell referencing.
- Calculate a specified value of a range by using the AutoCalculate feature.
- Modify the range accessed by a formula.
- Copy a specified data from one location to another.
- Copy specified attributes of data on the clipboard.
- Paste selected text in a worksheet.
- Move specified data item from a given location to another.
- Clear the specified attributes of a cell.
- Manipulate the cell positions.
- Spell-check a worksheet.
- Replace a text string with another string.
- Select rows and columns in a worksheet.
- Select a specified range of cells in a worksheet.
- Copy a range of cells from a specified location to another.
- Move a cell range from a specified location to another.
- Modify the layout of a page prior to printing.
- Add marginal data to customize a worksheet before printing.
- Modify the placement of data on a page before printing.
- Manipulate print display settings.
- Preview a worksheet before printing.
- Print data.
- Manipulate a range of cells for printing.
- Send a workbook through e-mail.
Unit 3: Formatting Worksheets
Duration: 2 Hour(s)- Insert rows and columns in a worksheet.
- Delete rows and columns from a worksheet.
- Manipulate row and
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
Excel 2000 Fundamentals
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
