Happy Friday Excellers, you are probably thinking two things here as you have read the title of the blog post..... We can't use conditional formatting in charts  I thought this was...

Sometimes is is not enough to just highlight duplicate values using conditional formatting in Excel, sometimes you just do not want to allow users to enter duplicates. For example if you are...

Friday Formula time.....  Today let's look at a handy formula for transforming an email address into a name, without the email address junk that is associated with it. At work I  get data...

Happy Friday Excellers, time for some Formula Fun. Today a simple formula to conditionally highlight any policy numbers in our data set that are out of date.       Here...

Have you come across a data set that looks a bit like this?.  The source data in your Pivot Table is not as clean as it should be with a slight variation in spelling that is a right pain in the...

Here is another time saving tip for you today, Excel not only has autocorrect, but you can instruct it to insert the correct words for you, even if you shorten them to a few letters, to save time...