Tag: Conditional Formatting

5 tips for searching for and finding emails in Outlook

Searching in Outlook has improved greatly over the years as newer versions of the ubiquitous email software have been released. But there’s more to searching than just typing something in the Search Box at the top of your messages list. Use these tips to dive deeper into your Inbox and email folders to quickly find those hard to locate messages. Read more

Excel – Finding and removing duplicate data

One of the many things I absolutely love about my job is that I get to work with so many different people from all kinds of organisations.

However, it doesn’t matter what industry or region I’m working in the challenges of working with large lists of data are pretty much the same.

Something I see often is the need to be able to quickly locate and remove duplicate rows of data (excellent for VLookups).  Most people just sort the data and then manually skim through the excessive lines of information trying to weed out the annoying duplicates.  This works, but boy-oh-boy it can be a time waster. Wouldn’t it be easier to have Excel quickly display the duplicates for you?  Then all you need to do is deal with them. Read more