How-to resources

A wide range of 'how-to' articles have been created to support staff in their use of supported software.

Further tools and information can be found at: 

  • Microsoft Office training centre (opens in a new window) offers free online training and support in the Microsoft suite of programs
  • MyIT website (opens in a new window) offers IT related knowledge articles (MyIT icon is also located on your desktop)
  • TRIM training articles are available on the RAMS website (opens in a new window)
  • Western Sydney University staff have access to Lynda.com, a free online training library

To access the 'how-to' resources, all the resources are listed below (more than one page) or simply choose an individual topic from the drop down list below and press Submit.

Browse resources by topic area:

Microsoft Excel

Transpose cells in Excel (Standard Page ) (opens in a new window) - To turn a column into a row or a row into a column, you can use the Transpose function.
Distance & Travel planner (MS Excel Document 25.5 KB) (opens in a new window) - Instead of using Google Maps, this Excel spreadsheet shows directions to go from A to B.
Removing spaces using TRIM (MS Excel Document 13.4 KB) (opens in a new window) - If you receive a spreadsheet from another source, sometimes you find the cell has spaces within it that may affect other formulas.
Upper, Lower and Proper functions in Excel (Standard Page ) (opens in a new window) - If you want to change the “case” of the text in a cell you can by using one of the Upper, Lower or Proper functions.
Using Data in shapes (Standard Page ) (opens in a new window) - Display the contents of a cell in a shape.
Using tables in Excel (Standard Page ) (opens in a new window) - A Table is a range of cells that hold data. You can manipulate the data in a Table independently of other data.
Watermarks in Excel (Standard Page ) (opens in a new window) - Excel has no Watermark option but here are two ways you can create one temporarily.

Microsoft OneNote

8 Ideas for OneNote (Standard Page ) (opens in a new window) - 8 Ideas to get the most out of OneNote
OneNote and the web (Standard Page ) (opens in a new window) - With OneNote you can store, sync or share your workbooks on the Web, using SkyDrive.
OneNote audio and video (Standard Page ) (opens in a new window) - To record audio, you need a microphone and to record video, you need to connect a camera.

Microsoft Outlook

Adding attachments in Microsoft Outlook (Standard Page ) (opens in a new window) - Attached files can be any type of file, e.g. Word documents, Excel spreadsheets, photos etc.
Addressing emails in Microsoft Outlook (Standard Page ) (opens in a new window) - Ensure good management of emails by setting an effective titles status and options.
Adjusting the reading pane settings in Microsoft Outlook (Standard Page ) (opens in a new window) - Incoming messages can be assigned the 'read' icon and will not be bold..
Changing font size in Microsoft Outlook (Standard Page ) (opens in a new window) - There are a few ways to change font sizes in Outlook 2010, depending where you are.
Email Template Shortcuts (Standard Page ) (opens in a new window) - You can create a shortcut to open the email templates.
Email Templates (Standard Page ) (opens in a new window) - If you use the same email format and/or Layout, you can save it as a Template.
Emails Servers and Protocols (Standard Page ) (opens in a new window) - When you set up e-mail account in a mail package, such as Outlook you will be asked for the protocol of each server.
Finding names in Microsoft Outlook (Standard Page ) (opens in a new window) - To use “Find Names” in your new email: click the 'To' button, and the 'Find Names' windows will open.
Importing contacts from Excel to Microsoft Outlook (Standard Page ) (opens in a new window) - Here is a simple way to create a distribution list directly from an Excel spreadsheet.
Importing individual contacts from a text file to Microsoft Outlook (Standard Page ) (opens in a new window) - Data will need to be set up as a Text file, and documents converted into .txt files.
Microsoft Outlook web access (basics) (Standard Page ) (opens in a new window) - Use the Outlook Web Access mail package to access your mail, through a browser, anywhere in the world.
Outlook keyboard shortcuts.pdf (PDF File 26.7 KB) (opens in a new window) - Outlook_keyboard_shortcuts.pdf
Printing a phone directory in Microsoft Outlook (Standard Page ) (opens in a new window) - In Outlook you can create and print a phone directory from your contacts.
Printing contacts in Microsoft Outlook (Standard Page ) (opens in a new window) - Steps on how to print out all your contacts, including filtering the list, and restoring the full list.
Removing auto fill entries in Microsoft Outlook (Standard Page ) (opens in a new window) - When you start to type in the first letter or letters in the 'To' field, Outlook brings up associated email addresses.
Replies with Comments (Standard Page ) (opens in a new window) - Replies with Comments
Saving your signatures in Microsoft Outlook (Standard Page ) (opens in a new window) - If you need to save your Outlook contacts there is a short way of saving them as files.
Sorting emails in Microsoft Outlook (Standard Page ) (opens in a new window) - To sort your emails, you simply click on the header and select your sort option, for example, click on the 'From' header to sort in alphabetical order.
Using the date navigator in Microsoft Outlook (Standard Page ) (opens in a new window) - There are a few ways to use the Date Navigator in Outlook including: single days, adjoining days, and non-consecutive days.

Microsoft PowerPoint

Changing fonts in PowerPoint (Standard Page ) (opens in a new window) - For consistency, this is how to replace all fonts in one go.
Creating Hyperlinks on shapes (Standard Page ) (opens in a new window) - You can use shapes like buttons to Hyperlink to Websites, other slides or documents.
Font and bullet problems in PowerPoint (Standard Page ) (opens in a new window) - How to make your font and bullets consistent.
How to Use Picture Backgrounds in PowerPoint (Standard Page ) (opens in a new window) - This shows you how to use a Picture or Gradient as a background in PowerPoint.
How to use presenter view in PowerPoint (Standard Page ) (opens in a new window) - You can use Presenters View to see your notes at the same time the audience sees the slides.
Inserting a YouTube video (Standard Page ) (opens in a new window) - You can embed and run, YouTube videos into PowerPoint.
Keyboard Shortcuts related documents. (Standard Page ) (opens in a new window) - Keyboard Shortcuts related documents.
PowerPoint Introduction - Short Course.pdf (PDF File 799.7 KB) (opens in a new window) - An OD Short Course on an introduction to the PowerPoint program.
Related Links (Standard Page ) (opens in a new window) - Related Links
Using Animated Picture Backgrounds in PowerPoint (Standard Page ) (opens in a new window) - How to Use Animated Picture Backgrounds in PowerPoint
Using keyboard shortcuts in PowerPoint (Standard Page ) (opens in a new window) - Here are some PowerPoint specific Keyboard shortcuts.

 

Previous  --- Page 3 of 5 ---   Next

Browse more how-to resources 1 2 3 4 5