Microsoft Excel 2000 Fundamentals

Course Code NGE72030

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

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.

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

Prerequisites

(Currently no course prerequisite information)

Objective

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

Topics Include

Unit 1: Getting Started

• 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

• 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

• Insert rows and columns in a worksheet.
• Delete rows and columns from a worksheet.
• Manipulate row and column visibility in a worksheet.
• Change the row height and the column width to a specified value.
• Restrict movement of rows and columns in a worksheet.
• Accommodate long text strings in cells.
• Manipulate page breaks manually in a worksheet.
• Format textual data.
• Align text in a cell according to the specifications.
• Rotate the text in a cell to a specified degree.
• Manipulate the appearance of a cell.
• Copy a format from a cell to a range of cells.
• Format numerical data according to specifications.
• Manipulate style settings for a range of cells.
• Format a range of cells.
• Enable the List AutoFill feature.
• Sort data by a single column in a specified order.
• Sort data by three columns in a specified order.
• Sort columns.

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

Web Based Training