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
This article is tagged with the following keywords. Find out more about MyNBR Tags
- Christchurch City Holdings pays out all underlying profit to council owner
- Nigel Latta only tells half the story on the economy
- Strong support for Seymour’s call for an end to ‘demographic ministers’
- Hawaiki Cable names US landing partner
- Wellington Airport wants to re-start resource consent for runway extension
Most listened to
- ASB economist Daniel Snowden: Businesses only see the kiwi dollar dropping by 4% in 12 months
- ‘If you want to go around telling people how they should think, don’t do it with taxpayer money’ – David Seymour on Susan Devoy
- Craigs' Grant Swanepoel on how he expects Z to reconfigure the Z and Caltex brands
- Cameron Officer details the latest motoring news
- 9 Spokes CEO Mark Estall on his company's progress since listing