|
|
|
Excel 2007 Level 2
One day program
| Target group: | Academic and professional staff who are interested in learning how to use Microsoft Excel 2007
|
| Group size: | Minimum 5 - Maximum 12 |
| Level 2 program: | 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. Staff are encouraged to complete Excel level 1 before participating in this workshop. |
| Schedule: |
| Date: | Thursday 12 April 2012 |
| Time: | 9:30am - 4:30pm |
| Venue: | Blue Gum Room, Building 2, Level 3, 195 Wellington Road, Clayton |
| Apply by: | Thursday 5 April 2012 |
|
| Schedule: |
| Date: | Thursday 5 July 2012 |
| Time: | 9:30am - 4:30pm |
| Venue: | Blue Gum Room, Building 2, Level 3, 195 Wellington Road, Clayton |
| Apply by: | Thursday 28 June 2012 |
|
| Cost: |
Monash Staff and Students - $185
|
| 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 2007 and wish to learn more.
Intended Outcomes
To further your knowledge of Excel 2007
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
|
