Tag Archives: Professional Development

Remove Duplicates in Excel

If you have ever needed to remove duplicates from a database in Excel, you will know how incredibly useful this tip is.

This is so simple and quick to use. Remove Duplicates does exactly what you’d expect — it removes the duplicates in any given range of data.

Excel’s Remove Duplicates tool is found:
– on the Data Ribbon…
– in the Data Tools section of the Ribbon.

BONUS: If you just want to highlight duplicates, you can do this using Conditional Formatting. The shortcut to get you there is Alt H L. (Or find it on the Home ribbon under Styles).

Thanks to Harvard Business Review for this tip.
If you have a Tech Tip suggestion, please let me know.


For great time-saving tips,
look up our tips on Being more efficient with your technology 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.

New! Computer Efficiency Website

Learning & Development have just launched a new website:

Being more efficient with your technology.

Simplify and enhance your work by adopting these quick wins. They will enable you to be significantly more efficient in your computer usage. For maximum impact, use as many as you can.

Adopt these favourite efficiency tips to simplify and enhance working on your computer

 


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

You’ll find more learning at Learning and Development.

Learn to be Culturally Responsive with your Pedagogy

Liz Brown, Kaiārahi Matua, is running three Culturally Responsive Pedagogy workshops this year.

Book your place on one of the following course dates:

  • Thursday 11 April, 12.30pm – 4.30pm, or
  • Wednesday 10 July,  9.00am – 12.30pm, or
  • Monday 18 November, 1.00pm – 4.30pm

Register via the Professional Development tile in UCPeople.

For more information, visit the Culturally Responsive Pedagogy website here.

These courses will only go ahead if a sufficient number of staff are signed up to each, so register now to avoid missing out.

If you have any further questions, please email Learning and Development.

If something isn’t working, try another browser

If you find that something in a webpage is not working as you expect it should…

Try another browser

Layouts, graphics, tables, forms, downloads and various other webpage elements can behave in different ways depending on the browser you are using. Some browsers handle these things differently to others.

So if things don’t seem right, try another browser.

The University supports:
– Microsoft Edge
– Internet Explorer
– Google Chrome
– Firefox
– Safari.

Thanks to Sue Woodgate for this great tip.

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.

Mental Health Awareness for Heads and Managers

As Heads and Managers you are responsible for the wellbeing of your staff members, and we’re assisting you with the tools to do so through the upcoming Mental Health and Wellbeing Awareness for Heads and Managers course. 

Taking place on Thursday 7 March between 9am – 1pm, this interactive workshop aims to provide participants with fundamental skills to understand and support others who maybe experiencing mental distress and/or mental illness.

Register through your Professional Development tile in UC People, or click here for more information  on the course and Learning Outcomes.


Looking for further Professional Development? The 2019 Learning and Development and Health and Safety workshops are now available.

Email Learning and Development for any queries.