Cleaning up emails

What happens if you get a list of names and emails from a colleague/customer but they are in a format that you can’t use e.g. someone has CC’d you on the email but you need to have them in proper cleaned up format… In this video I use a file from my...

Creating a Dashboard in Excel

In this blog post I want to walk you through the creation of a dashboard in Excel. We will be using Slicers, dropdown lists, pivot tables and the lesser known function – GetPivotData. Oh and we might throw in a chart or two and traffic lights for extra...

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...