Microsoft Excel Introduction

Building Simple Workbooks

Understanding Excel Terminology

Examining Important Screen Elements

Opening Workbooks

Reviewing Workbook Data

Navigating Worksheets

Entering General Text

Entering Numbers

Entering Dates

Editing Cells

Deleting Cell Contents

Understanding Mouse Pointer Shapes

Selecting Cells, Rows, and Columns

Moving Data by Drag-and-Drop

Copying Data with the Fill Handle

Reversing Mistakes with Undo and Redo

Checking for Spelling Errors

Saving Workbooks

Closing Workbooks

Using the Help Command

Managing Worksheets

Renaming Worksheets

Adding Color to Worksheet Tabs

Moving Worksheets

Inserting Worksheets

Deleting Worksheets

Writing and Copying Basic Formulas

Understanding Formulas Elements and Syntax

Understanding Excel's Order of Precedence

Creating Basic Formulas

Using Functions in Formulas

Using the Sum Button

Writing and Copying Basic Formulas (cont.)

Copying Formulas

Using the Insert Function Tool

Using the TODAY Function to Insert the Current Date

Using Dates in Formulas

Using AutoCalculate

Formatting Worksheets

Changing Column Widths

Applying Fonts, Bold, Underline,
and Italics

Copying Formatting from One Cell to Another

Aligning Data in Cells

Centering Data Across Columns

Wrapping Text within Coumns

Formatting Numbers and Formulas

Applying Borders

Applying Fill Color

Inserting and Deleting Columns or Rows

Inserting Pictures or Clip Art

Moving and Resizing Pictures

Deleting Pictures

Working with Larger Workbooks

Keeping Headings on the Screen as You Work

Previewing Before Printing

Printing Row and Column Headings

Hiding and Unhiding Columns

Sorting Lists of Information

Creating Custom Sorts

Printing Worksheets