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.
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.
2. Follow the instructions on page 24 to name the sheet tab Quarter 1.