From the course: Excel: Creating Business Budgets
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Summarizing revenue - Microsoft Excel Tutorial
From the course: Excel: Creating Business Budgets
Summarizing revenue
- [Instructor] Having worked really hard to build the business' budget model inputs, let's bring some of this information together and summarize the business' revenue picture. If you'd like to follow along with me, have my business budget revenue open and navigate to the revenue plan worksheet. On this worksheet, what you'll notice, are a couple of tables that have been prepared. This first table here is our pricing table, and that is where we estimate the price per sale per product. We need to include our products here. Rather than typing them in manually, we're going to link to where we have already created them elsewhere in our model. In cell B9, type equals, navigate to the sales plan worksheet, and then select cell B14 and hit enter on the keyboard. And let's drag this all the way down to the end, and you'll see that we have a couple of zeroes, which just means that if we want to add more products down the track, these will automatically pre-populate. Now what we want to do is…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.