filmov
tv
Excel Scenario Manager for budgeting and forecasting by Chris Menard
Показать описание
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!
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!