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.

Investment planning

Excel has a multitude of financial functions. I’m not sure how many of them can be applied in Serbian business environment, but they are useful when making complex calculations. Financial investment planning functions aim to answer the question: how much will, under the given conditions, be worth my money after a certain period of time? That is, if I borrow money to someone how much I will come? Or, if we lend money for how much it will cost me?