Put away the calendar and use a formula

In this tutorial I am going to show you how to calculate the difference in hours/days/working days between two sets of dates. Put away our calendar/s and learn how to use these formulas instead. You can download the completed file here You can view the video...

How to analyse Case time duration in Excel

I was recently asked by a participant in a class for some help with analysing case time duration – basically what was the average time duration from the opening of a support case to it being closed off and what time band it fell into. This required the use of...

Creating a calendar in Excel –

In this video I want to show you how you would set up a calendar to use in Excel. We will be using the Text() function to extract days and months and then Conditional Formatting to show up the different types of leave. You can download the completed file here. You can...

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