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
0 kommentar(er)
