A Novice's Approach to Using Excel

Intended Audience:

University staff interested in improving or consolidating their understanding of the use of Microsoft Excel 2003 as a productivity tool for managing, analysing and interpreting data.

Workshop Description:

A Novice's Approach to Using Excel is designed to enable participants to better understand the essential concepts of spreadsheets and to enable them to demonstrate their ability to use a spreadsheet application on a personal computer. Participants will practice developing, formatting and using a spreadsheet as well as be able to accomplish standard mathematical and logical operations using formulas and functions. Participants will gain experience in using some of the more advanced features of a spreadsheet application such as importing objects, and creating graphs and charts.

Intended Outcomes:

After completing this workshop, participants should be able to:

• Open, make changes, save and close a spreadsheet
• Enter/modify numbers, symbols, text or formulas into a cell
• Create and use basic formulas and functions
• Use help
• Select cell or range of adjacent and non-adjacent cells
• Use copy, cut and paste to duplicate/move cell contents
• Use the autofill tool/copy handle tool to copy or increment data entries
• Insert/delete rows, columns and cells
• Modify column width and row height
• Sort content in ascending/descending order
• Understand and use cell referencing in formulas or functions
• Format cells and cell ranges to desired styles
• Produce and modify different types of charts and graphs from spreadsheet figures to analyse data, e.g. pie charts, column charts, bar charts
• Use basic print options

Key Activities:

• Hands-on exercises that allow participants to practice spreadsheet skills
• Discussion and problem solving

Duration:

3 hours

Dates and Times:

• Workshop 1: Tuesday 24 February 2009: 9:30am - 12:30pm [FULL]
• Workshop 2: Thursday 12 March 2009: 9:30am - 12:30pm [Repeat Offering]
• Workshop 3: Wednesday 8 April 2009: 9:30am - 12:30pm [FULL]
• Workshop 4: Thursday 21 May 2009: 9:30am - 12:30pm [FULL]
• Workshop 5: Tuesday 21 April 2009 9:30am - 12:30am [FULL]
• Workshop 6: Tuesday 18 August 2009: 9:30am - 12:30pm [FULL]
• Workshop 7: Thursday 18 June 2009 9:30am - 12:30pm
• Workshop 8: Thursday 5 November 2009: 9:30am - 12:30pm [FULL]

Venue:

• Sanders Building, Myer Street, Room 1.01

Facilitator:

Kenn Martin, Organisational and Staff Development Services, UWA

Cost:

UWA staff members and UWA affiliates will receive priority in gaining access to this session. Participant enrolment in this workshop will be confirmed following the closing date for applications. Please note a cancellation fee may apply for non-attendees. We also welcome enrolment by non-UWA participants, subject to availability. The commercial fee for non-UWA attendees is calculated at $100 per hour of attendance. Staff working in other universities will receive a 20% discount on the commercial fee.

Number of Places:

12

Closing Dates:

• Workshop 1: Registration for this workshop closed on Monday 9 February 2009 [FULL] .
  
• Workshop 2: Registration for this workshop closed on Wednesday 25 February 2009 .
  
• Workshop 3: Registration for this workshop closed on Wednesday 18 March 2009 [FULL] .
  
• Workshop 4: Registration for this workshop closed on Wednesday 1 April 2009 [FULL] .
  
• Workshop 5: Registration for this workshop closed on Monday 6 April 2009 .
  
• Workshop 6: Registration for this workshop closed on Thursday 9 April 2009 [FULL] .
  
• Workshop 7: Registration for this workshop closed on Friday 12 June 2009 .
  
• Workshop 8: Registration for this workshop closed on Tuesday 25 August 2009 [FULL] .
  

TRIM Number:F21381