Tag Archives: Efficiency

Select Non-Consecutive Paragraphs and Format Them

When you’re formatting a long and unwieldy Word document (or email), it is useful to know some tricks that make the job  easier. One of these is selecting non-consecutive paragraphs and applying formatting to only those paragraphs.

To select non-consecutive paragraphs:

    1. Select your first paragraph
    2. Press the Ctrl key (hold it down)
    3. Select your next paragraph
    4. Keep the Ctrl key held down
    5. Select your next paragraph

Now apply formatting, being careful not to de-select the selected paragraphs.

Only the paragraphs you selected will be formatted.


For 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.

Tech Tip: How Efficient!

What are the Top 5 things you can do to be more productive in Word, Excel, Outlook, etc?

Look up Being more efficient with your technology to find out!


For other great time-saving tips, look up:
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.

The Crucial Shortcut to PowerPoint’s Slide Show View

Yesterday I had to make a last-minute emergency edit to a PowerPoint presentation after the audience had already come into the room. I managed to get it done but the wireless mouse wasn’t working properly, so getting back into Slide Show view in a hurry was proving to be a nightmare!

F5 key to the rescue!

Pressing F5 or Shift+F5 will take you straight into presentation view.

F5 starts the slide show from the beginning (ie, from the first slide)
Shift F5 starts the slide show from the current slide.

Write them down and stick them to your laptop because you WILL be grateful!


For 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.

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.