by admin | Apr 5, 2021 | Excel | General
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...
by admin | Mar 22, 2021 | Excel | General
In this video I show you how to calculate a location allowance but only when certain conditions are met – the Ref number has to be higher than a certain figure and it’s only paid when the employee is from one of four departments. However it also has to be...
by admin | Mar 15, 2021 | Excel | General
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...
by admin | Feb 15, 2021 | Excel | General
One of my main sources for these blog posts are questions I get from my subscribers and class participants. Recently I had one of my participants ask for help. He had applied conditional formatting to numbers – the idea would be that if the number was greater...
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...
