The catalog is a list of items associated with prices that and, by rule, it should not be changed more than once a day. In practice it is formed by consecutive adding codes of items, dates and prices in the table. How to find the last (current) price? Although at first glance it seems simple, this can be a considerable brain teaser. Also, this is an excellent demonstration of the practical application of formulas containing arrays and one of the “recipes” you will surely like.
“No romance without finance” is part of the lyrics of ’90s hit which point to a major life truth: whatever job you’re doing, sooner or later you are going to review the financial statements. This is inevitable, because the insight into the structure of sources, assets, revenues, expenses and other financial indicators you can learn your position “in space and time ‘, or whether you are doing your job well or not, and where there is room for improvement.
Working in large companies, especially multinational corporations, often involves periodically sending the standardized Excel reports that are intended to provide management with information about the business. These are usually consolidated balance sheets and other reports that display key performance indicators, and the employees who should fill them have a task to enter data into ready-made templates.
More than a year ago I noticed that my money is missing! I never doubted members of my family, but I started to check ATM transactions. Problem is that, most of the time, I take same amounts of cash. And since I am not very penny-wise it was very hard for me to „connect the dots“. Sounds familiar? That’s why I decided to end this phenomenon and started to track family’s incomes & expenses. I created „Simple Home Budget“ which helped me to track money transactions…
Aggregation of data (summarization, counting, averaging) can be done with the help of functions that have one or more of the conditions under which calculation is performed. These are very useful functions because they allow complex analyzes and an efficient way to make summary reports. In the following text we will describe these functions through several examples …