|
|
|
Excel level 3
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 3 program: |
- Use of Windows operating system and working with files and folders.
- Completion of Excel Level 1 or Level 2 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 3 course.
|
| Schedule: |
| Date: | Monday 28 April 2008 |
| Time: | 9:30am - 4:30pm |
| Venue: | Studio 7, Short Course Centre Bld 51, Clayton campus |
| Apply by: | Friday 18 April 2008 |
|
| Schedule: |
| Date: | Monday 4 August 2008 |
| Time: | 9:30am - 4:30pm |
| Venue: | Studio 7, Short Course Centre Bld 51, Clayton campus |
| Apply by: | Friday 25 July 2008 |
|
| Schedule: |
| Date: | Monday 10 November 2008 |
| Time: | 9:30am - 4:30pm |
| Venue: | Studio 7, Short Course Centre Bld 51, Clayton campus |
| Apply by: | Friday 31 October 2008 |
|
| Cost: |
Monash Staff /Students-$170
Others - $220
|
| Catering: | Morning and afternoon tea will be provided |
| To apply: | On-line application form |
Overview
This course is suitable for more experienced users of Excel 2003 who wish to learn more.
Intended Outcomes
To increase your knowledge of Excel
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.
|
