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.
Employees working in HR often make budgets influenced by the number of past days at some time. Excel has a function that calculates how many worked days passed between two dates, as well as a function that calculates the date that is obtained if we add a certain number of working days on the given date. These functions may also be useful to salespeople when they set payment deadlines or liquidators when they determine when they should settle their debit obligations.
When the reports contain dates and/or times, it is useful to know how to use the date and time functions. These functions allow us first to retrieve the system date and/or time and to display it within the cell. Then, by using them, we can distinguish a date/time unit (day, month, year, hour, minute, second, etc.) and use them to calculate the time or date in the future. For example, a date that comes in 5 days …
In practice, it often happens that we have tables that are in a mutual relationship. Similar to the database, the value of a table column column may be a key by which we can access the columns of another table. In this text, we will discuss the functions used to search through data ranges. If you master them, it’s quite certain that this will quickly become one of your favorite Excel tools.