Hour 7. Restructuring and Editing Excel 2003 Worksheets

This hour teaches you how to manage and organize your Excel 2003 worksheets to make them really work for you. You'll be surprised how Excel follows and updates formulas as you modify worksheet data. If you really want to master Excel, you must understand how to set up and work with cell ranges. Therefore, this hour's material will greatly enhance your Excel expertise. You will learn to use range names and references to produce more powerful Excel formulas and functions.

In addition to using the editing tools, you also learn how to format worksheets to make them look better. This hour teaches the formatting essentials so you will be ready for even more fancy stuff in the next hour.

The highlights of this hour include the following:

How to insert and delete rows and columns
How to work with ranges of cells
When range names are important
How to write formulas so that they compute in the order you want them to
How to format cells to add eye-catching appeal to your worksheet