Monday, April 20, 2015

Prime Productivity Pointer - Inserting Today's Date

When I ask people how they find the answer to a challenge in Excel or Word, I commonly hear the response "I Google it." Whilst Google is great it has its challenges.  Firstly you need to KNOW what you are looking for - sometimes you know the outcome you want but not the technical term and secondly, when you find the answer, your problem is solved, but reality is there are probably 2 or more colleagues looking for the same answer who will potentially go through the same process.

So what's the answer....share the knowledge with your colleagues.  So if you have a colleague who might benefit from this month's pointer, just pass it on.

In this blog post, we take a look at a function that is useful for automatically inserting the current date or calculating the difference between a date (such as a start date) and today’s date.

TODAY Function
The TODAY Function can be used on its own to automatically insert the current date according to your computer, but more often it is used in calculations to determine the difference between one date and today, for example days or years an employee has worked in your organisation.

It’s a very handy tool, if you are used it before, do you know a colleague who could benefit from knowing it too?  Why not send this pointer onto them….

Excel 2007
Excel 2010
Excel 2013

And here are the videos

TODAY Function - MP4 Format
TODAY Function - WMV Format

NOTE: Due to space, we only keep our pointers up on our site for a month or two.

Helping you work SMARTER and not HARDER with Microsoft Office.


Donna Hanson works with select organisations and individuals to increase productivity and reduce risk with technology they already own.

Find out more at www.donnahanson.com.au


To sign up to receive our regular productivity pointers visit www.primesolutions.net.au

Friday, April 17, 2015

Walking Meetings....

With so much of the average office worker's time sitting, at a desk, in meetings, on a train or bus, in a car, is it any wonder we have seen a rise in back complaints.

The last few years have seen an increase in standing desks in the workplace as sitting (well too much of it) is now being viewed as the bad for your health.

According to a Huffington Post article this week, the next step is walking meetings.

Probably not a replacement for larger meetings, but great for one on one conversations.
Researchers at Stanford University say walking leads to more creative thinking.




Huffington Post says, "You can find many big-shot fans of the walk and talk -- including Facebook chief Mark Zuckerberg, Twitter co-founder Jack Dorsey and this guy named Barack Obama. There’s even a TED Talk devoted solely to the topic."

Could this be practical in your workplace?

Love to hear your thoughts..

Read the full article here

Donna Hanson works with select organisations and individuals to increase productivity and reduce risk with technology they already own.

Find out more at www.donnahanson.com.au

 

Saturday, April 11, 2015

Customer Service isn't just external....



Technology was designed to increase our productivity. Those who know me know how passionate I am about working with organisations to build expertise with everyday technology to empower staff to be more productive, engaged and happy in their work.

However there are many other ways to keep staff engaged, happy and productive which all adds to the bottom line. A fantastic colleague of mine Shep Hyken is a specialist in exceptional customer service.  I was fortunate enough to be a guest blogger sharing my experience about both internal and external customer service following a visit to Zappos.com in Las Vegas.

Read the blog here
If you would like a copy of the white paper I wrote about my visit, click here

Donna Hanson works with select organisations and individuals to increase productivity and reduce risk with technology they already own.

Find out more at www.donnahanson.com.au

For more on Shep Hyken, visit www.hyken.com