Why the help menu is your best friend

Debbie Mayo-Smith


You can always count on someone covering their face with both hands in the "oh, no" expression – usually after I have shown groups an example of Text to Columns in Excel.

It is the way you can automatically split names apart from one column to two in Excel. The face in hands represents a realisation of their wasted time doing long lists one by one.

Let’s quantify one example.

Take $6923.08 in salaried time and who knows how many lost opportunities from lack of time.

The figure represents two individuals, one on $70k per year and the other at $50k, both spending three full working weeks splitting first and last names apart manually.

The pity is that instead of three weeks and two staff members, the entire project could have been accomplished with three clicks using the Text to Columns function.

This is symptomatic of the wasted time I hear about as a "productivity" business speaker and trainer.

There is a vast gulf between the everyday business tools people have on hand, and what they can actually do with them.

So much time is needlessly wasted doing computer tasks manually one by one, when it should be, and could be, done almost at once.

I think the root of the problem is two-fold.

First, computer training is not a priority now so staff are often left to DIY (do it yourself).

But DIY doesn’t happen because people at work are usually too busy. They don’t have the time to stop, think and search for a quicker or smarter way to do things.

Second is the rapid change in software and technology with upgrades. Just think of the massive productivity crash that went with the changeover from Office 2003 to 2007 or 2010. And soon we’ll have Office 2013.

It’s not only Microsoft Office, but also upgrades from the internet to smartphones. And propriety or industry software systems. From Skype to Social media.

If you use Facebook you know it seems to change monthly.

Solutions aside from training?

  • DIY – with a 10-minute schmooze. Diary a few minutes once or twice a week and have a play – looking through the file menu/ribbons or asking questions to help. Microsoft has loads of how-to videos and tutorials online.
  • Share a tip at office meetings. Make sharing a computer tip a fun part of every weekly office meeting.
  • Tips on intranet. Have staff put their top tips on the intranet to share.
  • Ask IT helpdesks to put together a tip of the week. Most IT managers and helpdesks are a fountain of knowledge but don’t have the time to comment on everyday software functions (or they think everyone will know them – which is not the case).
  • Books. Have an office library of books. I have a few

Debbie Mayo-Smith works with companies that want more effective staff and management

Check debbie@debbiespeaks.co.nz

Got a question about this story? Leave it in Comments & Questions below.

This article is tagged with the following keywords. Find out more about MyNBR Tags

Comments & Questions

Commenter icon key: Subscriber Verified

Post New comment or question

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.

NZ Market Snapshot


Sym Price Change
USD 0.6952 0.0000 0.00%
AUD 0.8901 0.0000 0.00%
EUR 0.5907 0.0000 0.00%
GBP 0.5276 0.0000 0.00%
HKD 5.4294 0.0000 0.00%
JPY 78.9230 0.0000 0.00%


Commodity Price Change Time
Gold Index 1278.6 -9.430 2017-10-20T00:
Oil Brent 57.8 0.550 2017-10-20T00:
Oil Nymex 51.9 0.580 2017-10-20T00:
Silver Index 17.0 -0.177 2017-10-20T00:


Symbol Open High Last %
NZX 50 8124.1 8142.3 8124.1 0.07%
NASDAQ 6633.4 6640.0 6605.1 0.36%
DAX 13057.8 13063.6 12990.1 0.01%
DJI 23205.2 23328.8 23163.0 0.71%
FTSE 7523.0 7560.0 7523.0 0.00%
HKSE 28360.0 28519.8 28159.1 1.17%
NI225 21391.0 21489.3 21448.5 0.04%
ASX 5896.1 5924.9 5896.1 0.17%