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.
The business of most companies is impossible without keeping a certain level of inventory. Excess items in stock, if there is no economic justification for it, is a loss that is reflected, both through the cost of storage and through the amount of captured working capital. Excel has a very simple way to determine the quantity of items that are most in stock, as well as any additional information regarding those items.
The old word angro, sometimes used in the Serbian language, comes from the French term “en gros” which means “in gross”, “wholesale” … It served me as the inspiration for the title, and in the text I want to show you advanced possibilities when using the SUM function. Let’s see in what, not very common, ways we can give it arguments and summarize the data.
If you are a wholesaler or distributor, you will often form more price lists for different groups of partners, which can be retail, wholesale, hotels and restaurants… Wouldn’t it be a good idea to keep all your product and price information in one table and print it, by desired criteria, when needed for each specific customer? Let’s see the practical application of the Advanced Filter option…
With the exception of the IF function, Excel has multitude of logical functions that are often unfairly neglected. The AND, OR, and XOR functions are also used to test the one or more conditions. The first returns TRUE if all conditions are met, the second if at least one of the conditions is met, and the third is used to examine cases where at least one but not all conditions are met. These functions can be used to analyze student performance on exams.