16. Charts and Multiple Worksheets

We worked on customizing a Clustered Cone Chart that reflected the consolidated data. We formatted the background color, and added a title using Word Art. We added a Text Box and an arrow to accentuate the most important part of the Chart.

Getting the Workbook ready for printing is also an important part of this project. By selecting all the worksheets, we were able to change margins and create a Custom Header and Custom Footer that enhanced all our worksheets.

In short, there are projects where Templates can multiply the usefulness of the way we use Excel.

Materials Covered: MS Excel - Project 6:
Creating Templates and Working with Multiple Worksheets and Workbooks, pp. 461-480


A break from Cases this week:
Assignment 9 - Shortcuts and Function Keys in Excel 2007: An Online Reference:

1. Click Here for a list of Keyboard Shortcuts and Functions Keys.
   
2. When you're done, in an entry in your journal:.

in your opinion, what are

• three most useful Shortcuts and Function Keys specific to Excel,
• and three most useful generic Windows Shortcuts? Thanks.