Summary

This hour extended your knowledge of worksheets by giving you more editing tools with which to insert and delete columns , rows, and cells . After you name important worksheet ranges, you won't have to track specific references in your worksheet; the name is easier to remember, and Excel changes the range if you insert data in or delete it from the range.

One of the most powerful aspects of worksheets is their recalculation capability. If you change data or a formula, Excel recalculates the entire worksheet as soon as you make the change. You are always looking at the computed worksheet with up-to-date information, no matter what kind of data changes you make. When you use formulas, you not only improve your worksheet accuracy, but also you finish your worksheets faster.

The next hour picks up where this one leaves off, going into formatting in more detail. Additionally, you see that graphics spruce up your worksheet and are easy to produce.