Learn to Create Scenarios in Excel

You can do a lot more with Excel than input data and create formulas. You can perform "What-if" analysis to extract information from your data.

Scenarios are one of my favorite "What-if" tools to use in Excel.

In this video I demonstrate how to create multiple scenarios for a typical business expense - a monthly budget of expenses.

Scenarios are very useful to use for reporting the results of multiple variables. They are also easy to create.

I invite you to visit my website - www.thecompanyrocks.com/excels to view all of my videos. to print out the step-by-step instructions and to download practice files.

Category:

Education

Tags:

• MS
• Microsoft
• Excel
• Create
• Scenarios
• changing
• cells
• variables
• target
• cell
• summary
• reports
• what-if
• data
• analysis
• lessons
• tutorial

[kellylouchart]

Thank you so much for this video. I wish I had found these videos earlier in the semester.