In order to perform a high-level analytical review of your purchases you may want to compare purchases made to prior financial years. To compare purchases to historic data, you need a formula that will work out which financial year the asset was purchased. To calculate the financial year in which the purchase was made, we […]

Continue reading

This is a list of the top 10 Excel Tips & Tricks of 2012 based on number of views by you! This list is made up of the Excel tips you and our other readers found the most interesting & useful in 2012. Top of the list is: 1. How to create a shared workbook […]

Continue reading

Ever tried to sum up all the positives/negatives in a column per GL account and per month?  If the task is done manually it will certainly turn out to be boring and repetitive.  However by using the Sumif function this seemingly boring and complex task can be simplified.  Follow our example below as we show […]

Continue reading

Are you planning on calculating commission for the sales staff, but the thought of creating a spreadsheet with complex formulae scares you. We have a solution for you, by nesting the IF and the AND functions one can ensure that the set conditions are met before commission is paid out. Below we explain how commission […]

Continue reading