课程: Excel Modeling Tips and Tricks

Continuing to build Excel models - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

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

Continuing to build Excel models

“

- [Michael] We've reached the end of our journey in Excel modeling, but there's a few key points I'd like you to keep in mind. First of all, as you now see, Excel's a great tool for business modeling and it can be used to make models for nearly any variable of interest in business, whether it's a complex model spanning multiple different sheets and encompassing hundreds of different variables, or a fairly simple model used for basic sales forecasting or something like that, perhaps for a small business, Excel can be your go-to tool for doing this. Regardless of the difficulty involved in your model, you've got a three step process you'll want to follow, first, determine your variable of interest. Second, make assumptions related to that variable, so figure out what it is you're trying to analyze or understand, and then what are the driving factors behind that variable, behind the outcomes that you're interested in. Once you've determined that those assumptions, then you're prepared to go through and set up your model construct. That'll let you go through and actually create the model for that variable over time. Once you've completed your model, you need to go through and be sure that you sanity check your results and review your assumptions. And you don't just do this once. Excel models are not a set it and forget it type of product. Instead, you'll need to review the model and the logic behind it regularly, the world does change and your models need to also. So keep these factors in mind as you go out and start building Excel models. And of course, keep an eye out for great additional courses right here on LinkedIn Learning, and I'll see you next time.

内容