Standings updated as of May 14. The NHL playoffs are coming soon and so I have set up a template for predictions that you can use. https://youtu.be/r8uURQJZqnw Download Template It is fairly straightforward - you select the team you ex ...
PLEASE NOTE THERE IS A NEWER VERSION OF THIS TEMPLATE AVAILABLE HERE A bank reconciliation can be a time-consuming process but this template can help speed it up. By assigning categories and setup quick ways to match items, you can qui ...
Excel has random number generator functions which are useful if you need to test a template or create some sample / dummy data.The RAND function returns a number between 0 and 1. You could multiply this by a factor of 10 or 100 to get a much lar ...
Excel's what-if-analysis options aren't the greatest, but one option which is very useful and can save time is Goal Seek. What Goal Seek effectively does is it can do trial and error for you in seconds, and be much more precise than doing it manually ...
In VBA there is a custom DateDiff function that allows you to easily calculate the difference between dates - whether you want the difference to be in days, weeks, months, years, it is easier to accomplish this in VBA than through regular Excel formu ...
In this post, I am going to cover some commonly used date functions and show you how to do some basic date calculations in Excel. Incrementing Dates by Days and Months One of the more common date calculations in Excel is to increment your dat ...
When comparing forecasted amounts vs actuals one way to help emphasize and highlight variances is by shading those areas. I'll show you how to easily do that in this post. Below is my starting data set I will need to create two extra columns to th ...
When charting something on Excel you sometimes may want to add vertical lines to identify key dates, or horizontal lines for target or benchmark amounts. In this post I'll show you how to do both.Horizontal lines can be used to identify target or ben ...
Download TemplateThis template allows you to create a customized letter - be it a cover letter or any other kind of letter from a pre-defined list of sentences and paragraphs that can also utilize variables. In order to accomplish this you will fir ...
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 ...
