Skip to content | Change text size
 

Excel 2010 Level 3

One day program

Target group:

Academic and professional staff who are interested in learning how to use Microsoft Excel 2010

Group size:Maximum 12 - Minimum numbers apply
Level 3 program:

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 3 course. Staff are encouraged to complete Excel level 2 before participating in this workshop.

Schedule:
Date:Wednesday 20 June 2012
Time:9.30 am - 4.30 pm
Venue:Blue Gum Room, Building 2, Level 3, 195 Wellington Road, Clayton
Apply by:Wednesday 13 June 2012
Schedule:
Date:Thursday 9 August 2012
Time:9.30 am - 4.30 pm
Venue:Blue Gum Room, Building 2, Level 3, 195 Wellington Road, Clayton
Apply by:Thursday 2 August 2012
Schedule:
Date:Monday 10 September 2012
Time:9.30 am - 4.30 pm
Venue:Blue Gum Room, Building 2, Level 3, 195 Wellington Road, Clayton
Apply by:Monday 3 September 2012
Schedule:
Date:Tuesday 13 November 2012
Time:9.30 am - 4.30 pm
Venue:Blue Gum Room, Building 2, Level 3, 195 Wellington Road, Clayton
Apply by:Tuesday 6 November 2012
Cost: $ 195
Catering:

Morning and afternoon tea will be provided

To apply:Online Application Form

Overview

This course is suitable for more experienced users of Excel 2007 who wish to learn more.

Intended Outcomes

To increase your knowledge of Excel 2010

Course Content

Course Content

On completion of this course participants will be able to:

  • nest functions to create complex functions
  • use advanced filters to analyse data in a list
  • use a variety of data validation techniques
  • create, use and modify data tables
  • create and work with scenarios and the Scenario Manager
  • create, modify and work with PivotTables
  • combine data in separate worksheets or workbooks using consolidation
  • use linking to create more efficient workbooks
  • create recorded macros in Excel
  • use the macro recorder to create a variety of macros
  • confidently open workbooks that contain macros

Learning Approach

  • Hands-on workshop
  • Practice exercises

Handouts

A booklet of notes will be provided