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 Read More

Build your own Excel Add-in thumb

Build your own Add-in: Calculation Timer

In this post, I will show you, step-by-step, how to create an Add-in with its own custom Ribbon.  Rather than just creating an example Add-in which says, “Hello World!”, we will build something useful – a calculation timer.  The process of creating any Add-in will be similar, so you can apply these principles to your Read More

Charting tips when in rush thumb

Excel charting tips for when you’re in a rush

Creating advanced charts in Excel can take a bit of time, as there are so many things to change.  Recently, I had to prepare a financial presentation quickly, like really quickly.  I knew exactly which charts were required (I had been given very clear instructions) and I knew how to do them (which is always Read More