|
Provided by: 123-CBT Computer Based Training Excel 2000 Proficient User |
 |
Course Overview
This course provides participants with the skills to use Microsoft Excel 2000 on a daily basis in their workplace. At the completion of this course, students will learn how to format and print data in a worksheet; make worksheet calculations by using the advanced formulas and functions provided by Excel; manipulate data in a worksheet; create and edit workbooks for integrating with Web technology; and add and modify charts, graphics and 3D shapes to a worksheet.
Learn To:
- Format and print data in a worksheet.
- Make worksheet calculations by using the advanced formulas and functions provided by Excel.
- Manipulate data in a worksheet.
- Create and edit workbooks for integrating with Web technology.
- Add and modify charts, graphics and 3D shapes to a worksheet.
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 and Microsoft Excel 2000 Fundamentals (Course 72030).
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Managing Display Properties
Duration: 1.5 - 2 Hour(s)- Customize the display of a toolbar.
- Create a new toolbar.
- Modify a toolbar.
- Delete a custom toolbar.
- Apply built-in number formats in a worksheet.
- Create a custom number format in a worksheet.
- Add a comment to a cell in a worksheet.
- Manipulate a cell comment in a worksheet.
- Display multiple worksheets in the Print Preview mode.
- Manipulate a report in Excel.
Unit 2: Advanced Calculation Techniques
Duration: 1.5 - 2 Hour(s)- Invoke the Function Palette to insert a function in a worksheet cell.
- Calculate data.
- Display dates.
- Calculate data based on a specific condition.
- Locate a value.
- Calculate values by using a financial function.
- Manipulate a named range for a set of selected cells.
- Perform calculations.
- Record a macro in a workbook.
- Execute a macro.
- Edit a macro in a workbook.
- Copy a macro from one workbook location to another.
- Delete a macro in a workbook.
- Assign a macro to a Command button.
Unit 3: Data Manipulation
Duration: 1 - 2 Hour(s)- Import data from a text file.
- Import tables from an HTML file.
- Import data from other applications.
- Export data to other application.
- Match the different methods of consolidating data with their uses.
- Create validation criteria for entering data in a cell range by using a list.
- Create a message to prompt the user to enter valid data in the cell range of a worksheet.
- Create an error message to be displayed when incorrect data is entered in any cell of a worksheet.
- Match the auditing tools on the Auditing toolbar with their functions.
- Match the standard error messages with their respective worksheet problems.
- Trace cells in a worksheet.
- Locate invalid data in a worksheet.
- Modify the properties of a workbook.
- Apply data protection.
- Enable the protection of selected areas of a worksheet.
- Clear data protection.
Unit 4: Outlining and Web Integration
Duration: 1 Hour(s)- Identify the functions of the worksheet outline symbols.
- Automatically create an outline for the data in an Excel worksheet.
- Manually outline the data in a worksheet.
- Create a hyperlink to a Web site from within a worksheet.
- Display a workbook as a Web Page.
- Save a workbook as a Web Page.
- Publish a workbook on the Web.
- Edit a Web p
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
