Solver is an add-in tool that lets you find solutions to various problems. You can use solver in Excel to run through "what-if" scenarios that might help you determine the best course of action. The "best" answer will be different for each problem, and might include maximizing profits, reducing cost, or producing the best use of resources. Before we continue, you should … [Read more...]
Goal Seek to Break Even
Recently I found myself deciding if I should sell some stock in order to provide a little extra cash to my bank account. I purchased shares of the company's stock four times in various quantities, and at varying prices. Due to the downturn in the stock market recently the prices dropped steadily, so I was able to purchase some of the shares at a low price. The company has … [Read more...]
Goal Seek to Solve A Problem
Microsoft Excel is jam packed with cool useful features that tend to go unused by most users, simply because they don't know how to use them, or even that they exist. One of these features is Excel's Goal Seek tool. First, some background on what it does. Goal Seek is essentially the answer to every middle school aged kid's math test word problem. It is best used when you … [Read more...]