Excel 2002: Getting Started

« back to previous page

Description:	Students will create, edit, and print basic worksheets in Excel. They will enter formulas for calculations and improve the appearance of worksheet data by using a variety of formatting techniques. In addition, they will learn how to manipulate and protect large worksheets.
Prerequisites:	Windows 2000 or equivalent skills
Length:	One day

Getting Started
• Understanding Excel
• Working with the Excel Screen
• Working with the Toolbars
• Understanding the Menus

Basic Worksheet Skills
• Creating a New Worksheet
• Entering Data in a Worksheet
• Saving, Closing and Opening a Workbook
• Selecting a Range
• Using AutoFill
• Adjusting Column Widths
• Inserting and Deleting Rows and Columns
• Moving Around the Worksheet

Performing Calculations
• Entering Simple Formulas
• Using the AutoSum Button
• Using Built-in Functions
• Copying a Formula
• Creating an Absolute Reference
• Using Date Arithmetic
• Using the Range Finder
• Performing an Error Check

Editing a Worksheet
• Deleting a Range
• Using Cut, Copy and Paste
• Using Find and Replace
• Working with the Clipboard Task Pane
• Using Paste Special

Formatting
• Creating Presentation Quality Worksheets
• Specifying a Numeric Format
• Creating a Custom Numeric Format
• Using Zeros in Formatting
• Changing Text Formats
• Working with Styles
• Applying Borders and Shading
• Using the Format Painter
• Inserting Page Breaks
• Applying an AutoFormat

Printing Worksheets
• Using Print Preview
• Working with Print Areas
• Selecting Print Options
• Setting Margins
• Setting Headers and Footers

Working with Large Worksheets
• Using Zoom Features
• Splitting the Window
• Freezing and Unfreezing Panes
• Changing the Display Screen

Working with Help
• Using the Office Assistant
• Working with the Help Interface

Using Protection and Comment Boxes
• Inserting and Editing Comment Boxes
• Sizing and Deleting Comment Boxes
• Viewing and Hiding Comments and Comment Indicators
• Locking and Unlocking Cell Ranges
• Checking the Protection Status
• Protecting the Worksheet