Learn how to enable iterative calculations and how to use Goal Seek and Scenarios. Author Jen McBee demonstrates how to use Goal Seek to find a missing or unknown value in a worksheet using Goal Seek, and how to create additional scenarios for a range of data using the Scenario Manager. Jen also shows you how to enable iterations.
- [Instructor] In this video, we will be reviewing…how to use the What-If Analysis Tools.…We'll also be looking at how to enable iterations.…We'll first go into our Excel options…and enable our iterations.…Now, you're probably wondering what an iteration is.…Well, quite simply,…it's the repeated recalculation of a worksheet cell…until a specific numeric edition is said.…And you'll see once we get in and look at the options…that you can set for your iterations…exactly how you can control how many times…that calculation will be performed.…
This is important because your What-If analysis tools…that we'll be looking at today,…creating scenarios and using Goal Seek,…both use an iterative process.…We're going to be working in the…0405 What-If Analysis workbook.…So we're going to go ahead and jump in there…and let's start by looking at the…settings for our iterations.…We'll go to our file tab,…go down to options,…and click on the formulas tab.…
By default, your iterative calculations are not turned on,…so you'll need to come in and enable them first…
Author
Jennifer McBee
Released
5/4/2017Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc. In the managing workbooks chapter, learn how to work with templates, versions, and macros. In the formatting and layout chapter, see how to apply custom formats and styles. The advanced formula chapter covers additional functions including a nested IF. The charts and tables chapter shows how to create a new PivotChart. The course concludes with a sample exam you can use for practice.
- Using templates
- Managing versions
- Leveraging macros
- Linking to external data
- Protecting cells
- Hiding formulas
- Using advanced Fill Series options
- Creating form fields
- Using advanced functions: AND/OR, SUMIFS, AVERAGEIFS, and COUNTIFS
- Manipulating options in existing PivotCharts
Skill Level Advanced
Duration
Views
-
Introduction
-
Welcome57s
-
-
1. Microsoft Office Specialist (MOS) Expert Exam Overview
-
2. Manage and Share Workbooks
-
Create and modify templates4m 15s
-
Link to external data6m 51s
-
-
3. Apply Custom Formats and Layouts
-
Create form fields5m 1s
-
4. Create Advanced Formulas
-
Use a Nested IF function3m 54s
-
Use the AND/OR functions6m 21s
-
Use financial functions3m 24s
-
-
5. Create Advanced Charts and Tables
-
Create new PivotCharts3m 39s
-
Apply styles to PivotCharts4m 20s
-
-
6. Sample Exam
-
Conclusion
-
Next steps30s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Enable iterative calculations and use What-If Analysis tools