From the course: Excel: Creating Business Budgets
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Summarizing expenses - Microsoft Excel Tutorial
From the course: Excel: Creating Business Budgets
Summarizing expenses
- [Instructor] Let's say that you have calculated all of the business's expense budgets but they're in different worksheets in the model and we want to bring all this information together and summarize in a simple table. If you'd like to follow along with me, have my business budget expenses open and navigate to the expense plan worksheet. You'll notice that we have already prepared a table here but it's blank. We need to populate this with all of the business's expenses. If we navigate to the expense types worksheet, you'll notice that we have expenses here already. So all I'm going to do is select these cells and copy by selecting control C on the keyboard, navigate back to the expense plan worksheet and, rather than paste, I'm going to paste values. We can do this a few ways. I'm just going to right click, select paste special, and then values, and then select okay on the keyboard, and we have now populated all of the expense types that we need in our summary table. Some of these…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.