Tag Archives: Learning

An Excel Formula to Avoid a #VALUE! Error

If you’re using Excel, this one may be for you.

In M15, you need a formula that multiplies quantity (in, let’s say,  K15) by price (in, let’s say,  L15), but the price column also contains text entries such as Out of stock.  So the formula K15*L15 is not satisfactory because when you multiply a number by a text value (such as “Out of stock”) you get the #VALUE! error.

You could use an IF function to check for text, but there is a shorter solution.

The N function has a single argument: a value. It returns the value if the value is a number, or 0 if the value is text.

So, in M15, use the formula =K15*N(L15).

Thanks to Able Owl Excel tips for this one.


For other great time-saving tips, look up:
Being more efficient with your technology
Technology Information for Staff website

Was this tip helpful to you? Anything else you want to know? Got some suggestions? Please leave a comment below or let me know.

You’ll find more learning at Learning and Development.

Mindfulness Course for Children

Does your child struggle with anxiety or stress? Would you like to support them to learn skills to enhance their wellbeing?

  • The Psychology Centre is offering Pause Breathe Smile (PBS), a group for children (aged 8-11 years) who struggle with stress and anxiety to develop skills of mindfulness.  PBS is an evidence-based program, developed by the Mental Health Foundation, found to improve focus and attention, enhance self-awareness and reduce stress.
  • The group will run from 4 – 5pm, starting Wednesday 23 October for 8 weeks at the Psychology Centre, University of Canterbury. It requires both child and parent/caregiver to attend and learn together.  The total cost of the program is $200.
  • For more information, please email justine.brougham@canterbury.ac.nz

View the following YouTube clip to hear children explain PBS: https://www.youtube.com/watch?v=awo8jUxIm0c

Further information about the research and benefits of PBS can be found here: http://www.scoop.co.nz/stories/ED1707/S00094/pause-breathe-smile-mindfulness-training-will-help.htm

Easily find a phone number

A quick way to find a staff member’s phone number and to call them is to:

1. Create a new email
2. Type their name into the To.. field (and wait for it to underline, or tap Ctrl+K)
3. Right-click their name
4. Click the telephone symbol to call them
or click Open Outlook Properties to see their phone number.

Call a staff member

You may also find this tip helpful:

Simplify your emailing with this quick way to find an email recipient’s name, using Ctrl+K.


For other great time-saving tips, look up:
Being more efficient with your technology
Technology Information for Staff website

Was this tip helpful to you? Anything else you want to know? Got some suggestions? Please leave a comment below or let me know.

You’ll find more learning at Learning and Development.

Turn an Email into a Calendar Appointment

From time to time you might get an email that you’d like to use to form the basis of a calendar appointment. Usually this would be to remind yourself to do something; or if you need to send a meeting invitation to people, to include all the information that is in the email.

To do this, simply drag the email from your Inbox and drop it onto the Calendar icon, in the lower left corner of the Outlook window.

Outlook calendar icon

A calendar appointment is created, displaying the contents of the email in the body of the appointment. You can then add any other information you’d like to, and even invite others to the appointment (or not, if it is just something you want to put into your own calendar), and save or send it as you would any other appointment.

(Thanks to Rebecca Hurrell for this Tech Tip suggestion, and wording!)


For other great time-saving tips, look up:
Being more efficient with your technology
Technology Information for Staff website

Was this tip helpful to you? Anything else you want to know? Got some suggestions? Please leave a comment below or let me know.

You’ll find more learning at Learning and Development.

Start A Fresh Page In Word

You are working on a Word document…
you are part-way down the page…
and for one reason or another you wish to end that page there and start a fresh page.

What do you do? No, do not hit the Return key over and over until the cursor moves onto a new page!! This leaves a whole lot of blank lines that will haunt you later when you make formatting changes and add other things to the document.

Instead, press Ctrl + Enter

Or:
1. Click the Insert tab
2. Click Page Break

This gives you a new blank page, and your cursor moves to that page. This is the correct way to get a new page,  for the reasons  I mentioned above.

Note: If you need to remove a Page Break – and you will sooner or later – switch on Paragraph marks so that you can see the Page Breaks in your document and delete any you need to.
The Show Paragrah marks icon

 


For other great time-saving tips, look up:
Being more efficient with your technology
Technology Information for Staff website

Was this tip helpful to you? Anything else you want to know? Got some suggestions? Please leave a comment below or let me know.

You’ll find more learning at Learning and Development.