Ch.17--"Working with workbooks and consolidating data"

Chapter 17 explains how to work with multiple worksheets and workbooks. Just as you are able to copy and paste data within a worksheet Excel allows you to move between various worksheets. To copy data betweens worksheets you just copy the data and paste it where you wish. To add more worksheets to a workbook you press and hold down the Ctrl key and put the mouse pointer over one of the tabs and drag it to the right of the last tab and then release the key and the mouse. To rename a tab just double click on it. To print multiple sheets choose the active sheet(s) option on the print menu. A workspace is multiple workbooks and in order to save it you go to file then save workspace. Excel will save all of the workbooks you have up and save them in the workspace.

The first project wants you to create a workbook that has a worksheet for every month of the year. The way to do that is to add more worksheets with the directions above and rename the 12 months the 12 months of the year. The second project is the simplest thing you can do. All you do is open project 17-2a and project 17-2b and save it as a workspace by going to file and save workspace.

The activity wants you to consolidate the data to sum the quarterly totals figures for each department on the Year-End Report. To consolidate the data go to data then consolidate. In the reference section go to the quarter one worksheet and select the totals for each department. And then hit enter, now that data will be consolidated when you hit OK. Do the same for the other three quarters. Go to your Year-End totals and make sure that the first department’s total has the mouse over it and then hit OK. It consolidates the data then adds up the quarterly totals for the departments.