课程: Excel: Creating Business Budgets

今天就学习课程吧！

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

Controlling inputs

Controlling inputs - Microsoft Excel教程

课程: Excel: Creating Business Budgets

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

Controlling inputs

“

- [Instructor] You might be wondering whether it's possible to control some of the inputs used in a business budget model. Luckily with Excel, this is easy. If you'd like to follow along, have my business budget controls open and navigate to the model overview worksheet. What you'll notice on this sheet are a couple of manual inputs, and we can tell because of the yellow shading for these two cells. If we have a look at financial year and try to type in anything and hit enter on the keyboard, you can tell that cell C7 accepts whatever we type into it. Wouldn't it be great if we could have come controls on this cell? Let's undo the change by selecting control Z on the keyboard. If we navigate now to the lists worksheet, what you'll see is a column here called financial year. Let's go and type in a few financial years, 2019/20, 2020/21, and 2021/22. What we need to do at this point is create a defined range name. Now there are a couple of ways to do this, but the fastest and the one…

内容