Excel Auto Resize Thumb

Auto resize an Excel spreadsheet to fill the screen

Every office I have ever worked in has been an equipment battleground.  It didn’t matter what the equipment was; it just had to be better than everybody else.  A new keyboard, a bigger screen, even a mouse mat with a wrist rest was enough to make everyone else jealous.  I was once lucky enough to Read More

Excel FILES Function Thumb

Excel function to list files in a folder without VBA

Listing the files in a folder is one of the activities which cannot be achieved using normal Excel formulas.  I could tell you to turn to VBA macros or PowerQuery, but then any non-VBA and non-PowerQuery users would close this post instantly.  But wait!  Back away from the close button, there is another option. For Read More


Automatic e-mail template for Excel

If you speak to anybody who works in the accountancy field, they will always be talking about the “month end”.  In all medium and large companies there will be a process at each month end which requires statements to be issued and reports to be distributed.  This monthly process fills most finance people with a Read More

Excel settings you're not using Thumb

17 Excel settings you’re not using…but should be

If there is one thing Excel has in abundance, it’s settings.  To new and even experienced users, it can be overwhelming.  It is difficult to know which settings to use and when to use them.  In this post, I’d like to share a few settings you’re probably not using, but you might find useful.  They Read More