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

Bulk-email-templates-thumb

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

Resetting the scroll bar in Excel Thumb

Resetting the Scroll Bar in Excel

The horizontal and vertical scroll bars in the Excel window are set by the size of the used range (the range of cells containing any value, formula, formatting etc).  Occasionally, this range can become excessively large (normally by accident).  As a result, the scroll bar becomes tiny.  A small mouse movement in the scroll bar Read More

Spreadsheet-Day-17-October-Thumb

Spreadsheet Day 2017

Happy Spreadsheet Day! What are your feelings about allocating days to celebration or awareness of certain things?  Like International Talk Like a Pirate Day (19th September), Oatmeal Nut Waffles Day (11th March) or Bathtub Day (7th October)?  Well, the 17 October is International Spreadsheet day.  Normally, I would think these days are pointless, but I Read More

Change image based on cell value Thumb

3 ways to change an image based on a cell value

From stock parts to holiday villas, from employees to logos, there are many reasons you may want to automatically change an image based on a cell value.  In this post, we’ll explore 3 different methods to achieve this task: Named range + INDEX/MATCH + linked picture Chart fill + #N/A VBA User-Defined Function Each solution Read More

Get file name of current workbook thumb

Get the file name of the current workbook

There are times in Excel when we may want to display or use the file name of the current workbook, or maybe the name of a specific worksheet.  Whilst there are a variety of options none of them are particularly obvious.  This post will consider some of the possible options: Header/Footer section CELL Function VBA Read More