From the course: Copilot in Excel: Supercharge Your Financial Modeling
Join today to access over 24,800 courses taught by industry experts.
Scenario planning simplified with Copilot
From the course: Copilot in Excel: Supercharge Your Financial Modeling
Scenario planning simplified with Copilot
- Scenario management is a core element of all financial models. It's about answering the what-if questions. This is a guaranteed line of questioning from stakeholders, especially when it comes to working with assumptions, and with Copilot in Excel, we can easily be guided on how to run scenarios. Now the forecast in the second table here have been prepared using industry-supplied rates. I should add that they're fictitious rates, but they come from the assumptions tab here. Let's say that our scenario is to model the impact of a flat 12% growth rate for all products in all years. Let's invoke Copilot and ask the following question, "Can you help me perform scenario analysis using the scenario manager?" Okay, let's scroll back up. This is good. We've already prepared the data, so we don't need to do that step, but certainly from here, the Scenario Manager is a very useful jumping in point. So let's follow along. Let's go to the Data tab as we're being instructed to, and then we're…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.