Forecast sheet

Forecast Sheet is an option used to calculate trends using specific forecasting functions. This is the Excel 2016 novelty. Based on the data provided for the appropriate time period, future values are forecasted and the lower and upper confidence interval is calculated. The calculated values are shown in the table along with a graph showing trends in data movement.

Solver

The Goal Seek option allows us to easily find a value that meets the set goal. However, this is an option of modest possibilities. To find the optimal calculated solution, by setting the target value and additional parameters, use the Excel Add-in named Solver. It is a complex tool, with many possibilities, which comes up to the target by applying one of the methods of Operational Research.

Goal Seek

Goal Seek is one of the What-If tools used to calculate how much to change an argument of a formula, or argument that indirectly affects to it, in order to get a certain result. This is a simple option that can be used, for example, to calculate the sales price of the item that is needed to reach the desired sales level. Learn about the Goal Seek option in the text that follows …

Data tables

One of the What-If analysis tools are Data tables. It is an option that allows the formula’s arguments to be taken from the rows or columns of a specially formed table and thus automatically populated. In practice, this option is not used as often, but it can be handy when we use functions that have more arguments to see the value of the results depending on the change of arguments.

Pivot charts

Pivot charts have almost all properties as standard charts that are used to visualize reporting data. They are specific in that they are always in relation to the Pivot table on the basis of which they were created or by some other data source (Data Model). Changing data in the Pivot table, e.g. by adding a new report dimension, the Pivot chart is automatically updated. You can find out more about Pivot Charts in the text that follows …