Tag Archives: data analysis

Scenarios in Excel

Excel has a variety of data analysis tools built-in, some of them very sophisticated. One of the easiest to use is a scenario that gives a snapshot of what things would be like if certain conditions were to change. These are particularly useful in financial models or in situations where the effects of the predictions need to be… Read More »

How to Use Goal Seek for What-If Analysis

Excel Training by Netresult Training There are many occasions when you need to know the steps to take to reach a goal you already know. The goal could be an amount, of profit for example, or a percentage. A typical example might be “I need to make 45,00 profit this year. What do I need to change my… Read More »