Excel – Multiple Sheets, Add ‘Em Up on a Summary Sheet

Excel2013LogoKeeping track of a budget by department or ledger number using Excel? And you want to put each department or ledger category on separate worksheets? Now how do you add up all that information by department on a summary sheet?

Knowing how to rearrange, copy and delete sheets, group them together so that what you do to one sheet you do to all will make finding and tracking those numbers easier.  Then summarize the information on all the sheets by adding a Summary sheet and create linking and 3-D formulas. You can even create hyperlinks to the individual sheets from the summary sheet so you don’t have to scroll across the bottom of the Excel windows to find just the sheet for which you are looking.

Want to know more? Watch a video, attend a workshop or request a consultation.

*Atomic Learning Video, login with your college username and password.