“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.
If we choose to create a complex Excel document that combines all the elements of a business process, we will try to call everything nicely, mark it, color it … During this process, we will create multiple worksheets, and sometimes give them long names in order to describe them as accurately as possible. The trouble is that the document can then become overloaded. The goal of this “recipe” is to show you a simple trick to find the desired worksheet faster.
ABC analysis is a method used for analysis and management of inventory. Depending on the share in the total value of the stock it distributes items in groups A, B or C. They make up about 70%, about 25% and about 5% of the total, respectively. Since items from Group A account for the largest share of the total value they require frequent and rigorous control. Items from the group B require something smaller, while items from the group C require the least control.
When we make reports, the goal is for them to be both functional and beautiful. Their background can also contribute to the appearance of the worksheet in a positive way. It is a picture that is placed behind the tables, charts, and other elements of the report. If after hiding it, we also hide lines separating cells (Gridlines) reports will look like they were not created in Excel. But, more importantly, users will be able to easily find the necessary information.
Rounding functions are approximating numbers to higher or lower values. On that occasion, they are guided by mathematical principles. However, when pricing is often required, rounding is done at a higher or lower level according to a given degree of significance, which is the decimal number in relation to which the rounding is done. Dear merchants (and everyone else), we present you functions FLOOR and CEILING!