Office Tips & Tricks: 2015 Round-up

Office Tips & Tricks: 2015 Round-up

Rules (7)

It’s almost the end of another year… The perfect opportunity to review the Microsoft Office Tips & Tricks we’ve shared with you during 2015. So grab a cup of tea and mince pie and take a few minutes to read our round-up.

Note: To re-read any of the original posts, just click on the links

Excel Tips & Tricks

  • Conditional formatting is a simple way of adding colours and other visual cues to your spreadsheets to show trends.  In January we looked at using conditional formatting to make better use of Excel spreadsheet data.
  • In April, we looked at Auto Fill and the newer Flash Fill function.  These functions can save you time when filling adjacent cells with data that follows a pattern eg: days of the week.
  • In June, for those new to Excel formulas, we showed how use simple formulas like AutoSum, Average, Max and Min.
  • Saving time was the focus for October when we posted how to add multiple rows or columns in Excel.

Word Tips & Tricks

  • Find and replace is a tool often overlooked in Word.  In March we explained how this handy tool quickly searches your whole document and changes multiple instances of a word/phrase in a flash.
  • In May, dissertation season, we were kept busy giving advice on working with longer documents.  Our blog post focussed on useful tools such as section breaks, numbering and using the show/hide key.
  • Online templates are now more visible in Word: you’ll see them every time you create a new document.  In August, we took a closer look at the templates, which include a volunteer sign-up sheet and event planner.
  • In December, we shared a tip for those of you creating diagrams or models in Word. With SmartArt you can quickly create professional looking graphics: you can also use SmartArt in other Office programs.

PowerPoint Tips and Tricks:

  • In February, we took a look at the little-used hide slides function in PowerPoint.  This function lets you simply hide unwanted slides rather than deleting them when re-purposing a presentation.  It’s just as easy to unhide them afterwards.
  • We know that for many of you, PowerPoint remains a favourite when creating presentations.  In March we showed how to easily reorganise your slides using the Slide Sorter.
  • Images can make for really eye-catching slides in PowerPoint.  In July, we shared how to add an image and format it to make a slide background.  We used a mouth-watering snap of cupcakes taken by our colleague Gemma, to illustrate this post.
  • September, start of the new academic year saw a blog post on using PowerPoint to create an academic poster. This post was jointly created with our colleagues for the NTU Print Services team.  Follow their advice to create a visually effective large format poster for your coursework or conference presentation.

Outlook Tips & Tricks

  • February saw a post about using rules in Outlook to get your mailbox under control.  Rules work by automatically taking action when certain emails arrive in your inbox; such as moving to a folder.
  • For those of you who schedule recurring appointments or meetings, in June we explained how to use Outlook’s recurrence tool. You can recur an appointment daily, weekly, monthly or simply set an end date.
  • Sending emails to large groups of staff or students can take ages.  In August we shared how to set up group contact lists in Outlook.  You can create your own groups and add/delete members as required; great for work groups or projects.
  • Bonfire Night (5th November) saw a post about email templates. Outlook templates are great timesavers if you need to send emails containing the same standard text.  We shared how to create email templates, ready to retrieve and personalise.

Have you tried out any of our Microsoft Office Tips & Tricks this year?  We’d love to know what you found useful, using the comments box below.

6 comments on “Office Tips & Tricks: 2015 Round-up

  • Thanks for this summary! I missed a post about Flash Fill in Excel. I heard about this functionality but never found time to explore it. I’ve just read the post and quickly tried the Flash Fill. This is a great alternative to the CONCATENATE function in Excel – it takes no time to use it at all and it produces the same result. And it is better than CONCATENATE in some instances. E.g. if I want to copy and paste cell value where I used CONCATENATE, I need to make sure that I paste values only. But with a cell that has Flash Fill data, I can just use CTRL+V to paste!

  • I have used the Outlook rules tip to filter a number of email addresses to dedicated thank you for this post.

    • rachel

      Rules are also great for filtering ‘news letter’ style emails into a folder for reading later. Shame Outlook doesn’t remind you to actually do the reading! Unless you create a Task of course…

  • Thanks – I’m going to try the rules in Outlook

Leave a comment

Your email address will not be published.

Required fields are marked with required