Microsoft Excel 2002 Fundamentals

Audience

The intended audience for this course includes end users and power users who may or may not be familiar with previous versions of Microsoft Excel. Their relevant duties may include office or managerial duties. They may be involved in working with accounting and financial data. The audience will include end users help desk/support personnel and other network designers. It is expected that learners should have a working knowledge of Microsoft Windows 9x or later operating systems. Some learners may have a basic knowledge of either Microsoft Office 97 or 2000 programs.

Objective

• Start Excel 2002.
• Identify elements of the Excel 2002 interface.
• Open a workbook.
• Match the different types of data that can be entered into a worksheet with their definitions.
• Edit worksheet data.
• Identify the methods for clearing the contents of a cell in a worksheet.
• Insert a row and column in a worksheet.
• Delete a row and column from a worksheet.
• Hide a row and column in a worksheet.

Topics Include

Unit 1: Basics of Excel 2002

• Start Excel 2002.
• Identify elements of the Excel 2002 interface.
• Open a workbook.
• Search for a workbook.
• Open an existing template to create a workbook.
• Save a modified workbook.
• Insert a new worksheet.
• Format a worksheet tab.
• Move a worksheet within a workbook.
• Delete a worksheet.
• Match worksheet navigation methods with their functions.
• Get Help by using the Office Assistant.
• Identify features of the Help Window.

Unit 2: Working with Data

• Match the different types of data that can be entered into a worksheet with their definitions.
• Edit worksheet data.
• Identify the methods for clearing the contents of a cell in a worksheet.
• Insert cells in a worksheet.
• Check the spelling of data in a worksheet.
• Replace text in a worksheet.
• Enter a formula in a worksheet cell.
• Edit a formula in a worksheet.
• Match types of cell references with their functionality.
• Use a worksheet link in a formula.
• Sort a list in descending and ascending order.
• Apply a standard filter to a list.
• Copy a range of cells.
• Use the Fill command on a range of cells.
• Identify features of the Print Preview page.
• Set a page break in a worksheet.
• Modify page settings for printing.
• Align a page for printing.
• Add a header and a footer.
• Set an area to be printed.
• Set the print display.
• Select nonadjacent cell ranges for printing.

Unit 3: Formatting Worksheets

• Hide a row and column in a worksheet.
• Modify the size of a row and column.
• Freeze a row and column.
• Merge cells in a worksheet.
• Split merged cells.
• Change font properties.
• Change the alignment of text.
• Add a border and a pattern.
• Apply different number formats.
• Apply automatic formatting to a range of cells.
• Apply conditional formatting to a range of cells.
• Create a new formatting style.
• Apply a formatting style to a range of cells.
• Insert a row and column in a worksheet.
• Delete a row and column from a worksheet.

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).

• 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