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.
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?
Excel has a large number of conversion functions. This text will show the ones used to convert lowercase letters into uppercase, uppercase to lowercase, and capitalize the initial letters of each word in the given cell. We will also mention two features that are used to clean the text, either by removing excessive spaces or unprintable characters that often exist in old applications and end up in the table when retreiving data.