Freezing panes in Excel is useful when you want to still see certain rows or columns as you scroll through a large data set. Without doing so you could easily get lost in your data trying to figure out which header or category the value you are looki ...
Download: Waterfall Chart Template This is a chart that is useful in reviewing variances and monitoring change from one period to another. Favourable (positive) variances are green, and unfavourable (negative) variances are r ...
Download TemplateThe project budget template is designed to help track expenses that you do not need to compare against multiple time periods. That being said you could copy the template and create a separate instance for each period you want to cov ...
This template is designed to allow you to easily track and manager your expenses using budgets and copying transactions downloaded from your bank or credit card statement. The template can be downloaded here DOWNLOADING TRANSACTIONSOnce you have a do ...
Please note this works only on versions of Excel 2010 and newer There are many different ways to show progress in Excel, and in this post I am going to provide you a template to show you how you can do this through an image. Link to the template is ...
If you have a formula that involves multiple sheets and you later sort that data you may notice your cell references are now out of order and need to be corrected. It can be frustrating and dangerous because you may not realize your formulas are now ...
MatchThis functionThis function works as if you were doing multiple lookup statements in one formula. The example I'm going to use is if you wanted to look at your credit card statement and from the description determine what vendor it is. For this f ...
The RANK() function in Excel is limited to a single range and if you do not have a set of unique numbers to use the rank function on it will return repeating values.There is a workaround however. If you can afford an extra column for a 'rank total' t ...
A good way to plan and organize your journal entries is to use t accounts. This template will allow you to setup and manage multiple accounts and see the impact of all your entries. It’s a quick way to plan and hopefully prevent any mistakes before t ...
If you’re looking for a way to manage your employee expense reports and don’t want to shell out hundreds of dollars every month, then this expense report template could be a great option for you. You can set up rules and flags for categories and ...
