Tag Archives: Office

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.

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.

When Excel Menu Icons Are Greyed Out

When you’re using Excel, do you ever find that the Ribbon and menu icons are inexplicably greyed out?

This can happen if you are in edit-mode in a cell (the cursor is blinking in a cell, waiting for you to enter something), or you have a dialog box open. It can also happen when you minimise an Excel workbook, then open a different one: if you were editing a cell in the first workbook (or have a dialog box open), you won’t be able to insert or edit anything in the second.

The solution is easy: hit the Esc key on the upper left corner of your keyboard.

Thanks to Able Owl 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.

Configuring Out of Office Reply for a Shared Mailbox

Do you manage a shared mailbox in Microsoft Outlook?

Now that it’s Christmas and you may be thinking about switching on Automatic Replies (Out of Office), doing so for a shared mailbox can be a real battle. Christmas is all about The Good News and there’s good news here too: there is an easy way to do this.

The easiest way to switch on Automatic Replies (Out of Office) for a shared mailbox is to do so through Outlook Web App.

This is actually pretty quick and straight forward, so don’t be put off by all the steps in the instructions below. Just forge on!

  1. Log in to Outlook Web App (OWA)
    – by following these steps
    – or by clicking this link

Now you are logged in to OWA, all you need to do is access the shared mailbox and switch on Out of Office.

2. Access the shared mailbox
Click your name in the upper-right corner of the OWA window
(a dialogue box appears titled Open Other Mailbox)
    –
Enter the name of the shared mailbox you’d like to add the Out of Office reply to, then click Open (the shared mailbox opens)

3. Switch on Out of Office
Click options in the upper-right corner (just below where your name was before you opened the shared mailbox)
Click set automatic replies
Set up your Automatic Reply, ensuring you consider replies to senders inside the organisation and outside the organisation
(to get started, click the radio button titled Send automatic replies)
– you can set an automatic start and end date/time if required
Click Save in the lower-right corner (it has a green tick next to it).
When you are finished, click sign out  in the upper-right corner.

If you have a Tech Tip suggestion, please let me know.


For great time-saving tips, look up our Archive of Tech Tips or look through the the Technology Information for Staff website.

Was this tip helpful to you? Anything else you want to know? Please leave a comment below.

You’ll find more learning at Learning and Development.

Looking for IT Information?

If you are looking for IT information, the Technology Information for Staff web site is for you. It covers everything from passwords to training, remote access to electronic filing, SPAM to traveling with your mobile devices, Skype for Business to ergonomics, and more.

This is a central location for information about the technology staff use regularly at UC.

The Technology Information for Staff web site also serves as an IT Induction for new staff, so please direct new staff members to it (it is also on the New Staff Orientation Checklist). If you are a new staff member you can work through it, starting on your first day and continuing from there.

You should find this website useful at any time. It is self-service, but you may need to ask a colleague to assist you from time to time. Managers /Heads may wish to nominate such a person, and should ensure that any new staff members know who to talk to when the content directs them to check with ‘a colleague’.

If you can’t find something or have a suggestion for the Technology Information for Staff website, please email Learning and Development.


Have you seen our Archive of Tech Tips? Click the link, then press the ‘End’ key on your keyboard to jump to the end of the Archive list where the most recent Tips are.

Was this tip helpful to you? Anything else you want to know? Please leave a comment below.

You’ll find more learning at Learning and Development.