By implementing business software we usually retrieve Master data from the previously used application, primarily the Partners and Items. Data is usually exported from old software to Excel, it is processed, and imported into a new application. When processing, there is often a need to “cut” the text in one of the columns from the left, from the right or from the given position, or to find a part of it in order to use it to generate some new content …
When someone tells you, “I’m left without text” this usually means a state of shock and confusion. Ignoring text related functions will not leave you in shock, but you will certainly be deprived of some useful tools. These functions are numerous, and in the “recipe” that follows I’ll describe these that allow merging of two or more texts into one, converting text to number or number in text, determining the length of text …
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.