by admin | Jan 18, 2021 | Excel | General
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...
by admin | Jan 11, 2021 | Excel | General
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...
by admin | Jan 11, 2021 | Excel | General
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...
by admin | Dec 14, 2020 | Excel | General
This year has been the year of the pivot – so many people have had to pivot in their lives, both personal and professional. Pivot is defined as the action of turning around a point but of course in Excel it invariably means pivot table – which is basically...
by admin | Dec 7, 2020 | Excel | General
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...
by admin | Nov 30, 2020 | Excel | General
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...
