Today is nothing new if you are not paid on time, although it is not a pleasant experience at all. You’ve done the job, and now you need to put in the extra effort to get paid. Excel can allow you to, in a very simple way, gain insight into all overdue receivables; to find out how much invoices aren’t paid, what are the amounts, which customers and how many days are late with payments. Based on this information, you can review your relationship with your clients.
A very rugged title, isn’t it? When you use multi-conditional data aggeregation functions like SUMIFS, AVERAGEIFS, COUNTIFS, etc. there may be multiple values from one column that you want to consider. This is accomplished by listing these values in curly brackets and then summing all the results. Here’s a quick guide to how to use multiple values for a one criterion.
Fixing cell addresses is an old topic. However, when you create a structured table (data table) and try to copy a formula that points to a cell inside it, the rules of the game change. That is, the address will not be updated as desired. These addresses can also be fixed, and in the text that follows you will learn how to do this.
Slicers are great feature, but unfortunately they can not be used to filter traditional Excel reports. If we use the conditional aggregation functions, in order to calculate the desired values, as well as the data validation technique, we can make simple but effective filters by selecting the values from the list. By selecting the criteria from the list, the automatic update of the values in the report is performed. Let’s see how this works!
I often get upset when I go to the supermarket and see the workers closing the passages by racking up the shelves. How to help them? If a company has implemented an ERP, it is possible to extract a stock report, critical inventory, and a place where the items are located (warehouse, location, position). With a little imagination and knowledge of conditional formatting techniques, there is an easy way to mark those shelves and positions where urgent refill is required.