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 | Mar 8, 2021 | Excel | Useful tricks
Ah, yes that joyful scenario. You have a list – a great big juicy list and you want to scroll down that list but oh no my headings have disappeared…WHAT DO I DOOOOO? Well I *have* heard of people who have sellotaped the headings onto their...
by admin | Mar 1, 2021 | Excel Functions | Useful
Like many of my blog posts this came from a request from an attendee at one of my classes. She wanted to get a better understanding of how to clean up unwanted spaces in Excel – that’s the Trim() function. She also wanted to learn how to combine multiple...
