Microsoft® Office Excel® 2007 Plain & Simple

Changing How You Look at Excel Workbooks

When you’re examining your Excel data to make a business decision, you’ll probably need to look at data from more than one worksheet, or even more than one workbook. Hourly sales totals can help determine when you need more staff on the floor, but if you keep track of the number of customers in the store as well, you might find that your great sales on Monday mornings come from landscape architects loading up for the week. In that case, you would be better off having your warehouse staff and not your counter clerks show up to handle the load.

You can open more than one workbook at a time and arrange them on the screen so you can read data from both sources at the same time. You can do something similar ...