Description
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.
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).
Prerequisites
(Currently no course prerequisite information)
Objective
- 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.
Topics Include
Unit 1: Managing Display Properties - 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 - 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 - 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 - 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 page after opening it in Excel.
Unit 5: Charts and Drawing Objects - Identify the different components of a chart.
- Match the different types of Excel 2000 charts with their functions.
- Create a chart from a data series.
- Change the chart type.
- Set a chart as the default chart.
- Save a chart.
- Set the print options for a chart.
- Print a chart.
- Resize a chart by using the selection handles.
- Move a chart from one worksheet location to another.
- Add titles to a chart.
- Customize the chart axes of a chart.
- Modify the data in a chart.
- Insert specified pictures on a worksheet.
- Create a drawing object by using the Drawing toolbar.
- Modify a drawing object in a worksheet.
- Move a drawing objects in a worksheet.
- Delete a drawing object in a worksheet.
- Add a three-dimensional effect to a given object in a worksheet.
- Add a WordArt title to a chart sheet.
Duration
8
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).
The network version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
Web Based Training
|
