Tag Archives: IT Learning

Press Tab When Filling In Forms

When you’re filling in an online form and you’re moving your cursor from one field to the next as you enter information such as your name, address, and so on, don’t use your mouse to get the cursor from field to field –

JUST PRESS TAB!

Fill in a field, then press the Tab key: the cursor will move to the next field. Fill in that field, and press Tab again: again the cursor will move to the next field.

Try it. You’ll be amazed at how much this simplifies the laborious task of filling in online forms. This works for most other programs too. (But sadly not all.)

You can also use the Tab key in Excel to move from cell to cell, or in Word tables to move from cell to cell.


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.

Finding Commands or Help in Microsoft Office Programs

Do you ever find that you simply cannot find the command you’re looking for in a program? Or need help on how to do something? 

Well, in Microsoft Office programs (such as Outlook, Word, Excel, PowerPoint, etc) there is an easy solution right within the program.

Within the program (eg, Microsoft Word), at the right hand end of the Ribbon Tabs, there is a field containing the text Tell me what you want to do…

This image shows the Help field in Word

 

  1. Click into the Tell me what you want to do… field
  2. Type in what you wish to do
    – The program will list commands relating to your query
  3. Select an option
    or select Get Help on…

 


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.

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.

LEARN is getting a facelift!

On 10 November 2019 LEARN will be upgraded. A consequence of the upgrade will be a change to how LEARN looks. It will have a cleaner, contemporary interface and an improved experience on mobile devices. In addition, the upgrade will include improved: forum management, messaging interface, and analytics.  All courses and their activities and resources will remain unchanged.

Front Page

Course Page

During 2019 the e-Learning Support team has been finding out what people think of LEARN and working to create the new look and feel based on feedback from staff and students.  There will be a number of opportunities to become familiar with the changes:

If you have any specific feedback about the theme please contact:   e-learning@canterbury.ac.nz

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.