• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part III: Computing with Excel 2002 > Restructuring and Editing Excel 2002 Work...

Hour 8. Restructuring and Editing Excel 2002 Worksheets

This hour teaches you how to manage your Excel 2002 worksheets as well as organize them to make them work more effectively for you. You will be surprised how Excel helps maintain your formulas when you modify worksheets. Understanding ranges is critical if you want to really master Excel. Therefore, be sure that you master this hour. You will use range names and references in Excel formulas and functions.

In addition to 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 the 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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint