From the course: Excel for Project Management

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Scenario analysis in Excel

Scenario analysis in Excel - Microsoft Excel Tutorial

From the course: Excel for Project Management

Start my 1-month free trial Buy for my team

Scenario analysis in Excel

“

- [Instructor] Okay, so let's build out our last features of our dashboard so that when people ask us questions about it, we can actually give them answers, and we can change how things look on the dashboard, and give the ability for people to interact and to really understand the data. So the first thing we want to do for our scenario analysis is I have selected the data in AO through AQ, so I'll hit Control + C there. Over here I'm going to do a paste value, so we're going to paste to complete. I probably did want to paste, not just the values, but also the number formatting with it. Okay, so one of these here is going to be our scenario, one of them is going to be our actuals. So I'm going to type I... I'm going to type in "SCENARIO" above here, again I did a merge and center. If you don't like merge and center, okay do center across, that's your life, I won't judge you, okay? But I do like merge and center, I'm sorry, I'm sorry, guys. I'm going to do Control + C here and then I'm…

Contents