Thursday, September 7, 2017

When I speak at conference, I am often asked, "How can I analyse my data when people keep entering items in differently?”

For many it can take hours of frustrating editing to fix in consistent data before it can be analysed. 

Elements such as a person’s surname that is regularly entered or a product description.

For many people the easiest thing to do is simply edit the data.  But it could all be avoided with some simple set up at the start.

You have to take time to make time!

This month think about WHERE the pointer could be useful for you.

Do you have lists of data your team utilise that vary just slightly resulting in extra work or frustration when you sort and filter or analyse it?

Take 5 minutes this month to have a chat with your team or your colleagues about whether this could work to streamline and reduce risk in your Excel spreadsheets.

The simple investment of 5 minutes could save you hours of stress and frustration when you least need it!


Useful for where you have a list of items from which you want users to select an option and keep the data consistent.

It’s useful for a list of names, product descriptions etc.

Here are the links to the PDF’s and videos below:

PDF How To in Excel 2016
PDF How To in Excel 2013

Video How To's
Droplists-MP4 Format

DroplistsWMV Format

Want to receive these pointers every month for free?
Sign up at

No comments:

Post a Comment