The changing cells are what you selected.The first set will be the current values. Scenario Manager dialog boxĮach scenario will be a set of the cells you just selected,Ĭontaining unique values. Haven’t created any scenarios yet, it says there are none defined. This displays the Scenario Manager dialog box. On the ribbon, select the Data tab > What-If.Hold the Ctrl key ( Command key on the Mac) while dragging from B6 down to B12, then Ctrl + click ( Command + click on the Mac) B17. First, select all the cells that will change.We'll open up the Scenario Manager and begin: Now we'll dig into What-If Analysis in Excel. This shortcut is identicalĭisplay formulas using Excel keyboard shortcut 1. Make Your First Scenario Step 1: Set up the First Scenario Press Ctrl + ` again to return the sheet to normal. Tip: press Ctrl + ` (accent mark) to display all the formulas on the sheet at once. Subtracts total cost from total revenue (B22-B13). (t-shirts, souvenirs) assumes patrons purchase an average of $5/seat (5*B4).īeverage assumes patrons purchase an average of $15/seat (15*B4). Multiplies the number of seats x ticket price (B4*B17). Here are the formulas the calculated numbers use: The numbers in orange boxes are calculated, so we won’t adjust This sheet currently displays the smallest of the venues, which Excel What-If Analysis Scenerio Manager - Practice Worksheet Worksheet below and a worksheet of the completed Excel Scenario Manager exercise. You can re-create the sheet below or download practice-files.zip, which contains the scenarios.xlsx Watch the complete tutorial screencast above, or work through the step-by-step written version below, but first download the practice worksheet so you can work through the excercises. Excel What-If Analysis: How to Use the Scenario Manager

Show credit in excel 2016 for mac