Skip to content | Change text size
 

Excel level 2

One day program

Target group:Academic and general staff who are interested in learning how to use Microsoft Excel 2003
Group size:Minimum 5 - Maximum 12
Level 2 program:
  • Use of Windows operating system and working with files and folders
  • Completion of Excel Level 1 or similar knowledge

Skills review quiz

It is encouraged that staff complete this quiz. The aim of the quiz is for staff to verify that they have the fundamental knowledge expected of them before undertaking the Excel level 2 course.

 

Schedule:
Date:Friday 11 April 2008
Time:9:30am - 4:30pm
Venue:Studio 7, Short Course Centre Bld 51, Clayton campus
Apply by:Thursday 3 April 2008
Schedule:
Date:Monday 23 June 2008
Time:9:30am - 4:30pm
Venue:Studio 7, Short Course Centre Bld 51, Clayton campus
Apply by:Friday 13 June 2008
Schedule:
Date:Wednesday 17 September 2008
Time:9:30am - 4:30pm
Venue:Studio 7, Short Course Centre Bld 51, Clayton campus
Apply by:Tuesday 9 September 2008
Schedule:
Date:Tuesday 14 October 2008
Time:9:30am - 4:30pm
Venue:Studio 7, Short Course Centre Bld 51, Clayton campus
Apply by:Monday 6 October 2008
Schedule:
Date:Wednesday 15 October 2008
Time:9:30am - 4:30pm
Venue:Studio 7, Short Course Centre Bld 51, Clayton campus
Apply by:Tuesday 7 October 2008
Cost: Monash Staff /Students-$170
Others - $220
Catering:Morning and afternoon tea provided.
To apply:On-line application form

Overview

This course is suitable for those users who have a working knowledge of Excel 2003 and wish to learn more.

Intended Outcomes

To further your knowledge of Excel  

Course Content

On completion of this course participants will be able to: 

  • work with workbooks
  • format a workbook to make it more visually appealing
  • insert and delete rows and columns
  • create formulas containing absolute references
  • create and use range names to speed up workbook operations
  • take advantage of the various Lookup functions
  • generate automatic and manual data outlines
  • protect worksheet cells and workbooks from unauthorised changes
  • sort data in a worksheet
  • filter data in a worksheet

Learning Approach

  • Hands-on workshop
  • Practice exercises

Handouts

A booklet of notes will be provided.