课程: Excel: Creating Business Budgets
今天就开通帐号，24,600 门业界名师课程任您挑！
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…
随堂练习，边学边练
下载课堂讲义。学练结合，紧跟进度，轻松巩固知识。
下载课程离线学习
下载课程到移动设备，轻松离线学习。在领英学习 iOS 或安卓版 APP 下载课程