Tag Archives: Tech Tip

Save typing time on Your iPad/iPhone

This tip on creating text shortcuts
is worth repeating!

This is the iPad/iPhone version of my Top Tip:
Use Outlook/Word Quick Parts.
For words or phrases you type over and over again, you can easily create shortcuts on the iPad and iPhone. This will
reduce errors and the time you spend typing repetitive phrases (like University of Canterbury), long words, jargon and acronyms.

(The precise details here may vary slightly depending on the model of your iPad/iPhone and the version of the iOS (Apple Operating System) you are running, but the concept remains the same. The concept will also be the same for Android phones and Windows phones – you’ll just have to find the right place.)

On your iPad or iPhone…

  1. Go to Settings > General > Keyboard
  2. Select Shortcuts
  3. Tap the “+” symbol (in the upper right corner)
  4. Type in the phrase you want to shortcut and then the shortcut key you wish to associate with that phrase
  5. Tap Save (in the upper right corner)
  6. Now when you want to type that phrase (in an email, message, document, etc), type the characters assigned to the shortcut and tap the spacebar.

 


Check out our Archive of Tech Tips – to check it out, click here, then hit 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

Quickly Access Your Most-Used Folders

Save yourself A LOT of mouse-clicking every time you open or save something on
your computer.

Just implement this easy tip:

Gain quick access to the Folders you use most using Favorites


Check out our Archive of Tech Tips – to check it out, click here, then hit 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

Shortcut to enter date in Excel

If you use Excel, sooner or later you will need to enter the date into a cell. The following shortcut inserts a snapshot of the date into a cell, formatted in whatever way the cell is formatted.

1. In Excel, open the worksheet you need to insert the date into.

2. Click the cell you wish to insert the date into

3. Type CTRL+; (press the Ctrl key followed by the semicolon key)

The date displays in the cell. Format it any way you wish (eg, long date, short date, colour, etc). It is a snapshot, so it will stay the same no matter what other date you open the workbook.


Check out our Archive of Tech Tips – to check it out, click here, then hit 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

Include an email as an attachment

As you probably know, files can be attached to an email message. But did you know that other Outlook items, such as messages, contacts, or tasks can also be included with a message that you send?

Here we’ll look at including an email as an attachment.

There are various ways to do this, but the simplest way is as follows:

1. Create a new email message in Outlook

2. Drag the new email message window to one side so that you can also see your Outlook Inbox

3. From your Inbox (or Mail folders), drag the email messages you wish to attach and drop them into the body of the new email message. Don’t worry, this will not remove them from the Inbox or folders!
– the attached messages are grouped into an “Attached” area on the new email message

4. Complete the email message with your message and recipient(s)

5. Send the email message


Check out our Archive of Tech Tips – to check it out, click here, then hit 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

Email only those who accepted a meeting – Option B

Last week we covered the quicker way to send a follow-up email to people who have accepted a meeting request, while excluding those who have not accepted the meeting.

However that method best suits occasions when there are only a few people who have declined the meeting request.

Today we look at the method to use if you have a lot of attendees who have declined – say, more than 10.

This looks like a lot of steps but it’s actually quite quick.

In the same way you can send a message to all those who gave no response to urge them along a bit. I explained the “None”
response in this Tip titled Are you causing someone else trouble when you accept a meeting?

This option involves a little use of Excel and filtering, but don’t be put off if you  are not familiar with Excel – here’s where you’ll get to learn a very useful feature! (I have added some explanations for you between the steps below.)

  1. View/open the appointment in Outlook.
  2. Click the Tracking button.
    – The names of all those invited are listed, with their acceptance status displayed to the right of their names.image002
  3. Click Copy Status to Clipboard.
  4. Open Excel.
  5. Select Cell A1.
    – This is the top left empty rectangular “cell” below “A” and next to “1”.
    – Click it to select the cell.
  6. Paste.
    – The names of all those you invited to the meeting display in
    columns, along with their attendance status and response.
  7. Widen the columns so you can read their contents clearly.
    – Do this by dragging to the right the thin line between the
    alphabetical letter at the top of each column, eg, A, B, C
  8. Click anywhere in the contents of those columns, eg, click the name of one of your attendees.
  9. Click the Sort & Filter drop-down arrow at the far right end of the Home Ribbon and click Filter.
    – Filters are added to the top of each column. These are drop-down arrows that allow you to sort information in the column.image003
  10. Click the filter drop-down arrow at the top of the Response
    column, and choose Sort A to Z.
    – All the staff who accepted are shown listed at the top of the
    Response column.
  11. Select all the names of the staff who accepted in the Name
    column.
    – To select the names, starting with the first name, click and drag your mouse down over the names you wish to select, in the same way you would select text in an email or Word document.
  12. Copy.
  13. Open Outlook
  14. Create a new message.
  15. Click into the To: field.
  16. Paste.
    – All the names you copied are pasted in.
  17. Press Ctrl+K to force Outlook to reconcile the names with the Name & Address Book.
  18. Write the message and send it.

And that’s it! Let me know how you find it – leave a comment.

Like these tips? Want to see more tips?

Learning and Development