Excel Scenario Manager for budgeting and forecasting by Chris Menard

preview_player
Показать описание
Use Excel's Scenario Manager to create different groups of data you can switch to quickly. Example: original budget and updated budget. Another example: new product and you want to know what happens if you sell more units, increase or decrease price or cost.

I recommend naming the cells or range but it isn't requried. The changing cells are input cells and the cells with formulas or functions are dependent cells. You can even create a summary of your changes.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Рекомендации по теме