From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use What-If Analysis

Use What-If Analysis

From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Start my 1-month free trial

Use What-If Analysis

“

- [Narrator] There are two great what-if analysis tools we can use in Excel 2016. They are scenario manager, where we can create different scenarios for different outcomes. And goal seek, where we can change the value in just one cell in order to meet our goal. On the Excel 2016 MOS Expert exam you may encounter a task that asks you to perform what-if analysis. So we'll review both types, scenarios and goal seek, so you'll be prepared for any what-if analysis tasks you come across on the exam. I have the 0407 exercise file open, so let's tackle this topic. We're going to focus on our Landon Hotels, specifically the Piccadilly location. We have 100 rooms available. Our average nightly rentals are 70. Our current room rate is 85 dollars and based on the nightly rentals and the room rate, we see our 2016 average daily sales. And based on our daily sales, we can determine what the 2016 yearly sales are. I want to go ahead and create three different scenarios. We're going to first take a…

Contents