ITS Home
IT Training
- Face-to-Face Courses
- Book a Face-to-Face Course
  - Booking Policy & Training Costs
- Online Courses Office 2007 & Office 2003
  - Microsoft Office 2003
  - Microsoft Office 2007
- Book an Online Course
- Further Information
- Training Staff

ITS Helpdesk
Phone: 8303 3000

Telecommunications
Phone: 8303 3333

Online Education
Phone: 8303 3335

Audio Visual Support
Phone: 8303 3933

Information Technology
Services
Level 9, 9 Gawler Place
The University of Adelaide
SA 5005 Australia

Email
Phone: +61 8 8303 5716
Facsimile: +61 8 8303 4400

Microsoft Excel 2007 Courses

Excel 2007: Level 1
Excel 2007: Level 2
Excel 2007: Level 3
Excel 2007: Level 4
Excel 2007: Level 5
Excel 2007: Level 6
Excel 2007: Level 7

Excel 2007: Level 1

Target Audience

This unit is aimed at staff and students looking for an introduction to Excel 2007.

Prerequisite and Co-requisite Courses

This is the entry level course for Excel 2007. The knowledge and skills covered in this unit will be assumed in the subsequent units.

Course Duration

3.5 hours.

Competencies

At the completion of the course, attendees will be able to:

Explore Excel
Use basic workbook skills
Work with ranges
Create simple formulas
Copy and move data
Print worksheets
Use page setup
Format numbers and text
Work with columns and rows
Get help

Excel 2007: Level 2

Target Audience

This unit is aimed at staff and students wanting to know more about formatting worksheets.

Prerequisite and Co-requisite Courses

This course assumes knowledge of all items covered in Microsoft Excel 2007: Level 1. The knowledge and skills covered in this unit will be assumed in the subsequent units.

Course Duration

3.5 hours.

Competencies

At the completion of the course, attendees will be able to:

Format cells
Use automatic formatting and styles
Get help
Use large worksheets
Work with multiple worksheets
Use range names
Use other functions
Manage data

Excel 2007: Level 3

Target Audience

This unit is aimed at staff and students wanting to increase their skills in working with worksheets.

Prerequisite and Co-requisite Courses

This course assumes knowledge of all items covered in Microsoft Excel 2007: Level 1 and Microsoft Excel 2007: Level 2. The knowledge and skills covered in this unit will be assumed in the subsequent units.

Course Duration

3.5 hours.

Competencies

At the completion of the course, attendees will be able to:

Use AutoFilter
Manage files
Create charts
Format charts
Draw an object
Use additional effects and objects
Use shapes and SmartArt

Excel 2007: Level 4

Target Audience

This unit is aimed at staff and students wanting to advance their skills in working with worksheets and workbooks.

Prerequisite and Co-requisite Courses

This course assumes knowledge of all items covered in Microsoft Excel 2007: Levels 1 to 3. The knowledge and skills covered in this unit will be assumed in the subsequent units.

Course Duration

3.5 hours.

Competencies

At the completion of the course, attendees will be able to:

Use HTML files
Work with comments
Work with tables
Work with advanced filters
Export and import data
Work with outlines
Use advanced charting features

Excel 2007: Level 5

Target Audience

This unit is aimed at staff and students wanting to advance their skills in working with worksheets and workbooks.

Prerequisite and Co-requisite Courses

This course assumes knowledge of all items covered in Microsoft Excel 2007: Levels 1 to 4. The knowledge and skills covered in this unit will be assumed in the subsequent units.

Course Duration

3.5 hours.

Competencies

At the completion of the course, attendees will be able to:

Use conditional and custom formats
Use templates
Use paste special
Customise Excel preferences
Use worksheet protection
Use multiple workbooks
Share workbooks

Excel 2007: Level 6

Target Audience

This unit is aimed at staff and students wanting to advance their skills in working with worksheets and workbooks.

Prerequisite and Co-requisite Courses

This course assumes knowledge of all items covered in Microsoft Excel 2007: Levels 1 to 5.

Course Duration

3.5 hours.

Competencies

At the completion of the course, attendees will be able to:

Work with data series
Use advanced functions
Create and revise pivot tables
Use scenarios and goal seeking
Use data tables
Consolidate worksheets
Solve problems

Excel 2007: Level 7

Target Audience

This unit is aimed at staff and students wanting to advance their skills in working with worksheets and workbooks.

Prerequisite and Co-requisite Courses

This course assumes knowledge of all items covered in Microsoft Excel 2007: Levels 1 to 6.

Course Duration

3.5 hours.

Competencies

At the completion of the course, attendees will be able to:

Work with views
Use auditing tools
Use macros
Record macros
Edit macros
Create macro buttons