The 6 Scenario Modeling Functions You Need to Know in Excel

Pivot Tables allow you to take one set of data and compare it to another set of data. Pivot Tables are very useful for comparing different scenarios, because they allow you to see the
effects on one area when something changes in another area. For example, let's say that your company is considering expanding their business to include selling frozen yogurt. But, before you make
the decision, you want to know how this might affect the average annual revenue per store. You could use a Pivot Table in Excel to explore how an expansion would affect total yearly revenue or
monthly revenue, based on different assumptions about customer numbers or product prices. The pivot table will show the effect on each scenario side by side in a single spreadsheet!

Leave a Reply