Data Tables – part 1
|

Data Tables – part 1

Here’s a really useful tool for generating various results based upon multiple inputs. It’s a quick way of seeing what happens to results when you vary the input. I usually try each input manually, but I really should set up these data tables to see the results. I’m attaching a PowerPoint that shows in a…

Goal Seek
|

Goal Seek

“I wish you could reverse engineer the answer.” When we do the forecasting, pricing or some kind of modeling, we move forward in spreadsheets by inputting the values for the variables and letting the formulas calculate the end results such as net income or gross margin. However, sometimes, we know what kind of end results…