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 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 …
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.
After we have created a structured table it would be nice to take some time to change its appearance. Excel has a large number of predefined styles, which allow us to change the way this table is displayed, and there are many other options that can be used to format individual parts of a structured table. Before we start to fill in the data table, let’s make it a better looking!
Depreciation means the expense of fixed assets. The depreciation calculation is used to find out how this cost should be spread over several periods, since it is assumed that we are not rich enough to immediately reimburse the cost of purchasing a fixed asset. Depending on whether we want to distribute the costs evenly or if we want to pay more in a certain period, in order to pay less, there are several functions for calculating depreciation.