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