Store Multiple Values With Excel Scenarios

If you’re working on the office budget, you might be collecting data from different departments. Or maybe you’re planning your back to school spending. If you get that bonus at the end of your summer job, you can use some higher budget numbers. If the bonus falls through, you’ll need your low budget estimates.

Store Data With Scenarios

With Excel Scenarios, you can store different sets of values (in up to 32 cells) in a workbook. Then, without any programming, you can switch between the saved values.

In this example, we store budget projections for two departments. View and print one department’s budget, and then switch to the other department, all in the same cells.

scenarios05a

Download the Sample File

To see the written instructions for creating scenarios, please visit the Excel Scenarios page on the Contextures website. There is a sample file that you can download, to see how the Scenarios work.

Excel Dashboard Deadline Reminder

Last week, I recommended the Excel Dashboard Course offered by Mynda Treacy from My Online training Hub. Dashboards are the new buzzword when it comes to Excel reporting and employers are specifically asking for these skills. If you need to take your Excel skills to the next level to get that dream job, then knowing Excel Dashboards will help you stand out from the competition.

The early bird discount for the course ends today, so sign up now, to save 20%.  Registration is only open until August 14th, and you can see the course details and a sample video here: Excel Dashboard Course

Watch the Excel Scenarios Video

To see the steps for creating and showing scenarios, watch this short video tutorial. I also share tips for quickly naming cells, and automatically adding those names to your formulas.

 

____________________

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *