If algebra isn’t your strong suit, you can use Goal Seek to find answers to that type of question quickly.
- When you create a formula in Excel,…it's easy to ask questions such as:…what percentage of this mixture is quartz?…It's a far different question to ask:…how much do I need to increase the quartz of this mixture…so it accounts for 20% of the total?…If algebra isn't your strong suit, you can use…Goal Seek to find answers to that type of question quickly.…In this movie, I will show you how to use Goal Seek.…My sample file is the GoalSeek workbook,…and you can find it in the chapter one folder…of the exercise files collection.…
My goal is to find the amount of milky quartz…that brings the quartz part of a mixture…up to 23% of the total.…I have three items that I need to enter.…The first is the amount of milky quartz in the mixture.…This is the cell we're going to be changing as we go along,…so I'll just make it zero for now.…I'm typing that value in cell B3, and I'll press enter.…Now there's the base;…the base is a neutral powder,…for example, that might be sand or something similar.…
Let's say that the base consists of 42 grams,…
LinkedIn Learning (Lynda.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.
- Finding target values using Goal Seek
- Finding a solution using Solver
- Tuning investment portfolios
- Organizing worksheets
- Creating objective and control formulas
- Experimenting with different constraints
- Optimizing resource placement
- Defining decision trees