Microsoft Excel Introduction

Building a Simple Workbook

Important Screen Elements

Opening a Workbook

Reviewing a Workbook

Navigating in a Worksheet

Entering Text

Entering Numbers

Entering Dates

Editing a Cell

Deleting Cell Contents

Understanding Mouse Pointer Shapes

Selecting Ranges

Moving Data by Drag-and-Drop

Copying Data with the Fill Handle

Reversing Mistakes with Undo and Redo

Spell Checking Your Work

Saving a File

Closing a File

Using Microsoft Office Help

Working with Worksheets

Renaming Worksheets

Adding Color to Sheet Tabs

Moving Worksheets

Adding New Worksheets

Deleting Worksheets

Writing and Copying Formulas

Writing Formulas

Order of Precedence

Formula Syntax

Using Functions in Formulas

Using the AutoSum Button

Copying Formulas

Using the Clipboard to Copy and Paste

Using the Fill Handle to Copy

Using the Insert Function Tool

Using =TODAY to Insert the Current Date

Using Dates in Formulas

Using AutoCalculate

Formatting a Worksheet

Changing Column Widths

Applying Fonts, Bold, Underline, and Italics

Aligning Data in Cells

Centering Data Across Columns

Wrapping Text

Formatting Numbers, Formulas, and Dates

Adding Borders and Fill Color

Inserting and Deleting Columns or Rows

Inserting Comments

Removing Formatting and Comments

Printing a Worksheet

Previewing Before Printing

Setting Page Options

Setting Margins

Creating Headers and Footers

Setting Sheet Options

Using Page Break Preview

Inserting Forced Page Breaks

Printing a Worksheet

Using Print Areas

Appendix A: Working with Larger Workbooks

Keeping Headings on the Screen as You Work

Hiding Columns

Sorting Rows of Information

Appendix B: Filling a Series

Using the Fill Handle to Copy and Paste

Filling a Number Series by Example

Filling a Date Series

Using AutoFill

Using Predefined Custom Lists

Creating Custom Lists