Simple Vaccination timetable

This video show you how to create a very simple timetable for vaccinations with names and a dropdown list for timeslots (which can be updated). You can download the completed version here. You can view the video on how I did it...

My 21 for 2021

I do love a good podcast and one of my absolute favourites is Gretchen Rubin’s Happier. She does it with her sister – Liz Craft – who also has a great podcast called Happier in Hollywood with her writing partner Sarah Fain. One of their key ideas...

Cleaning up an accounts file with Power Query

One of the most common tasks faced by accountants and office workers is that of data cleansing i.e. removing the extra blank columns , sub totals, blank rows so beloved of accounts packages but which all need to be removed before any sort of Excel analysis can be done...

Faster Filtering with Filter()

Filter() is one of the new dynamic array functions in Excel. So what does that mean? If you have used Excel you will know that generally it has made like a single celled organism – create your formula in ONE cell and then copy it down or across. The new range of...

How to create a unique ID in Excel

A while back one of my customers asked me about a way to create a unique ID from a customer’s name and a random number. Of course I was intrigued and using a combination of Left(), Right() and Randbetween() helped her do just that. Yum, I do love me an Excel...