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:

Images and graphics

Related Links (Standard Page ) (opens in a new window) - Related Links
Using images (Standard Page ) (opens in a new window) - Tips for adding documents to your desktop, as well as your Microsoft Office programs.
What are vector and raster images? (Standard Page ) (opens in a new window) - What is the difference between Raster and Vector diagrams?
What is a graphic? (Standard Page ) (opens in a new window) - A graphic is an image that is used to enhance the presentation of information or support content.

Microsoft Excel

Accumulated flex on timesheets (MS Excel Document 1.2 MB) (opens in a new window) - This Excel file provides an example and explanation of how accumulated flex is entered and taken in your UWS timesheet.
Adding a calculator to Excel (Standard Page ) (opens in a new window) - One off calculations are easy with the Excel calculator feature.
Adding a command to a ribbon in Excel (Standard Page ) (opens in a new window) - It is possible to add a command to a ribbon in Excel, but first you need to create a new group to hold it.
Camera Tool in Excel (Standard Page ) (opens in a new window) - To avoid continuously changing worksheets to look at a specific data, you can use the Camera tool.
Chart effects in Excel (Standard Page ) (opens in a new window) - Make charts look more impressive.
Conditional Formatting explained (MS Excel Document 134.9 KB) (opens in a new window) - How to use the Conditional Formatting options
Counting data in Excel (Standard Page ) (opens in a new window) - Count the number of unique and duplicate data entries in an Excel worksheet.
Creating a drop-down list. (Standard Page ) (opens in a new window) - Make entering the same data easier by using a list (Drop down) to choose data from, so when you go to the cell, a drop-down arrow appears with a list attached.
Creating a quiz in Excel (Standard Page ) (opens in a new window) - Excel has a quiz feature that can track correct and wrong answers, and keep a running total.
Creating pop-ups in Excel (Standard Page ) (opens in a new window) - To create a pop-up when a spreadsheet is opened, you need to use a VBA code.
Date and time formats in Excel (Standard Page ) (opens in a new window) - This is all about Date and Time formatting in Excel
Define a scroll area in Excel (Standard Page ) (opens in a new window) - If you wish to restrict the Excel worksheet to a specific range, you can simply set the scroll area.
Excel functions - full list (PDF File 150.6 KB) (opens in a new window) - A full list including mathematical, statistical and trigonometry functions.
Most common Excel functions (PDF File 136.5 KB) (opens in a new window) - A list of the most common Excel functions, including DATE function and PRICE function.
Keyboard shortcuts in Excel (PDF File 37.6 KB) (opens in a new window) - A full list of Excel keyboard shortcuts.
Expanding Charts Automatically (MS Excel Document 12.0 KB) (opens in a new window) - You create a chart (graph) that automatically expands as you add more data.
Graph paper in Excel (Standard Page ) (opens in a new window) - If you need a sheet of graph paper, you can print it from Excel.
Increase the value of a cell in Excel (Standard Page ) (opens in a new window) - Example for increasing values by a percentage.
Using the INDEX Function (MS Excel Document 18.6 KB) (opens in a new window) - This shows you how to use the INDEX function, with a simple example and a more advanced example
Instructional text in cells in Excel (Standard Page ) (opens in a new window) - Adding instructional text that disappears when any data is entered and will revert back to the default text when deleted.
Joining Formulas (MS Excel Document 21.5 KB) (opens in a new window) - Joining formulas (called Nested formulas) allows you to combine functions into one cell, instead of using separate cells.
Counting characters using LEN (MS Excel Document 12.7 KB) (opens in a new window) - If you need to count characters within a cell you use the LEN formula.
Macros -1 Setting up (Standard Page ) (opens in a new window) - These notes shows the user how to set up a Macro in Excel
Macros -2 Running (Standard Page ) (opens in a new window) - These notes show the users how to run a Macro.
Macros -3 Copying (Standard Page ) (opens in a new window) - These note show the user how to copy a Macro from one workbook to another
Paste options in Excel.pdf (PDF File 111.6 KB) (opens in a new window) - Paste_options_in_Excel.pdf
Removing Duplicates (Standard Page ) (opens in a new window) - Removing Duplicates
Excel short course 1 (MS Word Document 132.9 KB) (opens in a new window) - A useful how-to guide that covers the creation of basic formulas, copying formulas, and using functions.
Excel short course 2 (MS Word Document 521.1 KB) (opens in a new window) - A useful how-to guide that covers working with charts, graphs and ribbons.
Excel short course 3 (MS Word Document 29.2 KB) (opens in a new window) - A useful how-to guide that covers working with "if" functions.
Excel short course 4 (MS Word Document 544.8 KB) (opens in a new window) - A useful how-to guide that covers naming cell references, creating drop-down lists, and using the Vlookup formula.
Showing the last entry (MS Excel Document 11.0 KB) (opens in a new window) - This spreadsheet shows, with an example, how to use the INDEX and COUNT functions together, to find the last entry in a list.
Split a number and decimal (Standard Page ) (opens in a new window) - How to split a number and it’s decimal to two separate numbers (cells).
Splitting and joining text (Standard Page ) (opens in a new window) - Joining cells together in one cell (merging text) and splitting text from a single cell to multiple cells (data/text to columns).
Using Substitute (MS Excel Document 14.0 KB) (opens in a new window) - The Substitute formula allows you to replace words in a cell.
Using Sumproduct (MS Excel Document 14.1 KB) (opens in a new window) - Sumproduct returns the sum of the products of corresponding ranges or arrays.

 

Previous  --- Page 2 of 5 ---   Next

Browse more how-to resources 1 2 3 4 5