16 – Conditional formatting in Excel

So for this I am going to walk you through one of the exercises I do with my learners when I am teaching Conditional formatting – particularly using the Highlight Cells Rules options. This is a file with the exercises in it. Here are the questions The number of...

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