From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
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 Goal Seek and Scenario Manager
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Use What-If Analysis Goal Seek and Scenario Manager
- [Instructor] We're going to use what-if-analysis, goal seek and scenario manager in this video so that we can see how just by changing and adding different values we can create a goal seek function that will, for instance, tell us how much we can borrow, if we have some knowns, such as what interest rate would it be, and what's the most that we can afford to pay per month. We'll also look at how we can create different scenarios, again, using different values, and each time we add a different value it will recalculate and give us a new scenario. Let's take a look at our what-if-analysis workbook. First, we'll work with the scenario manager. We have our 2019 total sales for a few of our products. We'll create three scenarios, the first one will be the sales in their current state, the 2019 sales. The next two will show an increase of three and five percent. On the data tab, I'll go to what-if-analysis, scenario manager…
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.
Contents
-
-
-
-
-
-
Use AND(), OR(), and NOT() in nested functions6m 9s
-
Use IF() and IFS() in nested functions4m 31s
-
(Locked)
Use SWITCH() in nested functions3m 38s
-
Use SUMIF(), AVERAGEIF(), SUMIFS(), and AVERAGEIFS() functions5m 2s
-
(Locked)
Use COUNT() and COUNTIF()2m 54s
-
Use MAXIFS() and MINIFS() in nested functions3m 27s
-
(Locked)
Look up data using VLOOKUP() and HLOOKUP()5m 52s
-
Use the MATCH() and INDEX() functions5m 47s
-
(Locked)
Use NOW() and TODAY() functions and calculate dates using WEEKDAY() and WORKDAY() functions8m 15s
-
(Locked)
Summarize data from multiple ranges by using the Consolidate feature3m 10s
-
(Locked)
Use What-If Analysis Goal Seek and Scenario Manager5m 57s
-
(Locked)
Calculate financial data with NPER() and PMT() functions3m 30s
-
(Locked)
Troubleshoot formulas9m 24s
-
(Locked)
Challenge: Create advanced formulas27s
-
(Locked)
Solution: Create advanced formulas9m 8s
-
-
-
-