From the course: Excel: Creating Business Budgets
Join today to access over 24,700 courses taught by industry experts.
Controlling inputs - Microsoft Excel Tutorial
From the course: 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…
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.