Tag Archives: Learning & 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.

Paste text in Bold

Did you know….

Pressing Ctrl B prior to paste gives you a bold paste.

If you are copying and pasting text in an email, or in Word, PowerPoint, or Excel, you can paste it in bold simply by pressing CTRL+B first, and then pasting. The text you are pasting will then paste in bold.

(The same applies for italics, underline, and non-bold.)

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.

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.

Open PowerPoint Directly Into Presentation Mode

Want to make a good impression when giving a PowerPoint presentation in front of an important audience?

Open your PowerPoint file directly into presentation mode!

Here’s how:
1. Access the file on a USB/memory stick or in File Explorer
2. Right-click the file
3. Select Show rather than Open

Your PowerPoint file then opens directly into presentation mode.

Thanks to ACE computer training for this 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.