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