Tag Archives: ITS

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.

UC People (PeopleSoft) Outage 8 October

The PeopleSoft system, including UC Vacancies and UC Temp Vacancies, will be unavailable from Tuesday 8 October, 12noon – 5pm, for planned system maintenance.

We encourage staff to complete any urgent PeopleSoft self-service transactions before the outage and log out of PeopleSoft. We apologise for any inconvenience.

If you have any questions about this maintenance, please contact the IT Service Desk.

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.

Introducing the new Digital Payment Solutions Project

Financial Services and ITS are excited to announce the launch of the new Digital Payments Solutions Project!

Between October 2019 and June 2020, UC will be replacing some of the legacy systems currently used for processing payments at the University. The key objectives of the project are to:

  • Increase the security of the systems processing payments, in line with the Payment Card Industry Data Security Standard (PCI-DSS);
  • Improve user experience – This will be through the implementation of modern solutions, with additional functionality (i.e. reporting) and user friendly interfaces;
  • Improve organisational and administrative processes – Mainly through the elimination of manual processes and double entries, streamlined financial reconciliations, standardisation of processes for selling products / services across UC, and clear delineation of responsibilities for the set up and management of products / services sold by the University; and
  • Reduce technical debt – Through the implementation of modern commercial off the shelf solutions which will greatly eliminate interface issues, provide product management capability, and allow for future improvements as these are required.

This project is shortly commencing the execution phase, with initial changes being rolled out from November 2019.

Whilst the Digital Payments Solutions Project will be improving a number of processes, broadly speaking it has the following four work streams:

Once fully implemented these upgrades will have minimal impact on the daily life of students and most staff, however in order to have a successful implementation some effort will be required from the appropriate Business Units staff. We will be contacting such staff at least 3 weeks prior to any changes being made, to discuss the changes that will be affecting you such as overall timeline, requirements, training, etc.

If you want to learn more about this exciting project, or simply have a query or two, please see the FAQs by clicking on this link, or email digitalpaymentsproject@canterbury.ac.nz with your questions.

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.