Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

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

Chapter 5. Managing and Viewing Workshee... > Changing How You Look at Excel Workb...

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 if you have relevant data in two parts of the same worksheet. If you can’t see everything you need to see, you can split the worksheet into two or four units, all with independent scroll bars.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint