O'Reilly logo

Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: Visual QuickProject Guide by Maria Langer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

5. consolidate the results

We now have three worksheets full of budget and actual information. Our next step is to consolidate this information into one summary worksheet for the quarter. We’ll do that with Excel’s consolidation feature.

57-01.jpg

prepare the sheet

The consolidated information will go on its own sheet. We can prepare the sheet by activating it, renaming it, and activating the first cell of the consolidation range.

1. Click the sheet tab for Sheet2 to activate it.

58-01_prepare_sheet_1.jpg

2. Follow the instructions on page 24 to name the sheet tab Quarter 1.

3. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required