From the course: Excel: Learning Cash Flow Forecasting

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Building a sales forecast in Excel

Building a sales forecast in Excel

From the course: Excel: Learning Cash Flow Forecasting

Start my 1-month free trial Buy for my team

Building a sales forecast in Excel

“

- [Narrator] When we build financial models, we want to be thoughtful about structuring the model and the data in logical ways. We want to make it easy for us and other people involved to follow what's going on. Here, you'll see that we have received 12 months of sales data by customer. I have intentionally placed all of this information into a dynamic table. Where are dynamic tables, if I were to go to Insert, Table is located right here. These dynamic tables allow us to capture our data as objects, making it easy for us to use lookups and other functions without having to worry about them breaking. This will prove to be extremely important to this financial model and to this course. At the bottom of my data, you're going to note that I have this little corner. I call it the data wedge. This indicates that all of my data above it and to the left is captured in a dynamic table. Why do I insist on using these? Well, allow me to illustrate with an example. I'm going to move us over here…

Contents