From the course: Excel: Sales Forecasting
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Running your own analysis
- [Instructor] So what have we learned? Well, hopefully at this point you have a good handle on how it is you can actually use Excel in a nuts and bolts way for sales forecasting. As we've seen, Excel's great for building basic budgets and forecasts based on things like a percent of sales method or based on a linear increase in number of customers. So Excel's great for that kind of basic tool. But it's also really nice for going through and building more complex forecasts. Excel lets us easily build data sets and then clean them up. From there, we can do quick regressions and then build forecasts based on those regressions. And we can do this either at the company-wide level based on macroeconomic data or company data that we gather or we can do it at the customer or transaction level based on information specific to those customers or those transactions. My suggestion would be if you want to learn more about this topic, start…
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.