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

Thursday, June 15, 2017

What Every School Administrator Needs to Know about Microsoft Word

What Every School Administrator Needs to Know about Microsoft Word & Excel 2016

I've just released an online course SPECIFICALLY for school administrative staff.

$97 per person, but until 30th June it is only $37

For more information go to

Wednesday, March 2, 2016

The Missed Opportunity to Increase Productivity

I don’t know about you, but when I first started work, productivity was generally “measured” by the time you arrived at the office and the time you left.   

These days it seems our productivity is often “measured” by the number of emails we send, who we send them to and when they are sent!

Technology has blurred the line between people and productivity with staff not necessarily knowing what is expected of them when.   

One missed opportunity to increase productivity is considering Time.

Not everyone's time is equal.
Employee costs vary depending on salary and expertise.
Many organisation have high level staff doing tasks that could easily be done by lower salaried ones releasing them to focus on more strategic activities or to increase billable hours.

Additionally there are often two staff members who do the same task but one takes five minutes, the other fifteen. That's 10 minutes lost on one task alone.
Across the course of a week that's almost 1 hr.
Across the year it is over 40hrs or the equivalent of having a staff member work ONE EXTRA WEEK per year.

My question is, what tasks or process are you wasting time and in turn $$ on?

For more information on Donna and her productivity focused solutions for business, visit or


Tuesday, February 16, 2016

A Picture Tells a Thousand Words

As the saying goes, “A picture tells a thousand words”,

Have you ever tried to insert one into your Word document and it just didn’t do what you wanted it to?

Pictures are a vital part of reports and proposals today.
They tell us so much more than words can say and often enable a moment, an idea or a concept to be captured and shared in a more meaningful way.

When communicating, a picture cuts through the words and presents and image that when snapshotted in our minds eye we never forget.

This month we explore what you must know about inserting pictures into Word documents.
Some of the tips will also work when you are working with pictures in Powerpoint.

Important Note:
If you are inserting pictures into your documents and presentations that have been taken by someone else – for example an image from the internet, be mindful that this may be infringing copyright.

If you are looking for images you can freely use – known as royalty free images (you pay a once off fee and they are yours to use forever) or simply free images, visit sites such as, or, to buy ones you can reuse at no additional cost of or try sites such as or* or you can even start using your own images.

Inserting and Managing Pictures in Word

PDF Links

And here are the videos

Inserting and Managing Pictures in Word - MP4 Format
Inserting and Managing Pictures in Word- WMV Format

Invest just 5 minutes of your time to review this month’s pointer.
As I always say …. “You Don’t Know What You Don’t Know!”

Feel free to share this post with anyone you think might find it useful.

Want more?

Each month I send out a complimentary productivity pointer.
A tip, trick or shortcut in Excel.
Subscribe at

PS This is one of my own pictures taken on a recent trip to Washington DC.