Summary

In this hour, you advanced by leaps and bounds as you moved into the world of working with numbers. Mathematics is the heart and soul of Excel, and you did a great job with constructing formulas and copying them. In Hour 6, "Using Excel Templates," you'll have fun working with Excel templates.

Part I: Excel Basics

Hour 1. Getting Started

Hour 2. Entering Data

Hour 3. Organizing Your Files

Hour 4. Managing Your Files and Workbooks

Hour 5. Letting Excel Do the Math

Why Use Formulas?

How Formulas Work

Creating a Simple Formula

Referencing Cells

Using Range Names in Formulas

Using Relative and Absolute Addressing

Copying Formulas

Troubleshooting Formula Errors

Hour 6. Using Excel Templates

Hour 7. Printing Your Workbook

Part IV: Advanced Excel Techniques

Part V: Creating and Using Databases in Excel

Part VI: At the Office and on the Internet/Intranet