课程: Excel: Creating Business Budgets

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Preparing the workbook

Preparing the workbook - Microsoft Excel教程

课程: Excel: Creating Business Budgets

开始一个月试用 购买团队方案

Preparing the workbook

“

- [Instructor] Before building a business budget model, using Excel, it's important to set out the workbook in a manner that makes it easy to navigate. If you'd like to follow along with me then have My Business Budget setting out open and select the model overview worksheet. As you can see, this worksheet has been prepared with some information. Let's go ahead and populate it. The first thing that we want to do is to give this model a title. So, up here in row four I'm just going to include some text. The purpose of this workbook is to manage a cafe's operational budget. The next thing is to select a financial year, and I'm just going to type in 2019-20. And we also want to select a scenario. And in this case, I'm going to assume that we're having just one scenario for the model, scenario one. The scenario is essentially an identifier. It can be used for creating different versions of the budget. You'll then notice we have a worksheet table. And this is something that we'll come back…

内容