Excel Essentials

Using Microsoft Excel

3 Hours
Versions 2003 or 2007

Building a Simple Spreadsheet

Understanding Components of a Workbook

Opening and Reviewing a Workbook

Entering Text, Numbers, and Dates

Editing and Erasing Cell Contents

Understanding Mouse Pointer Shapes

Selecting Ranges

Moving Data by Drag-and-Drop

Reversing Mistakes with Undo and Redo

Spell Checking Your Work

Saving and Closing a File

Using Online Help

Writing and Copying Formulas

Writing Formulas

Using Functions in Formulas

Using the AutoSum Button

Copying a Formula Across or Down

Using the Fill Handle to Copy

Using the Clipboard to Copy

Formatting Worksheets

Widening or Narrowing Columns

Applying Fonts, Bold, Underline, and Italics

Aligning Data in Cells

Formatting Numbers and Formulas

Adding Borders and Shading

Inserting and Deleting Columns or Rows

Printing Worksheets

Previewing Before Printing

Setting Page Options

Setting Margins

Creating Headers and Footers

Setting General Sheet Options

Printing a Workbook