Excel 2007

The following units are recommended for Microsoft Certified Accreditation Specialist certification:
Excel 2003: Level 1
Excel 2003: Level 2
Excel 2003: Level 3
Excel 2003: Level 4
Excel 2003: Level 5
Excel 2003: Level 6
Excel 2003: Level 7

The sample files used in all general Microsoft Office courses are available for download by clicking here. Our licence agreement restricts access to staff and students who have completed the relevant courses.

Excel 2007: Level 1

Target Audience

Prerequisite and Co-requisite Courses

Course Duration

Competencies

1. Explore Excel and learn about new Office 2007 features.
2. Use basic workbook skills.
3. Work with ranges.
4. Create simple formulas.
5. Copy and move data.
6. Print worksheets.
7. Use page setup.
8. Format numbers and text.
9. Work with columns and rows.
10. Get help. 

Excel 2007: Level 2

Target Audience

Prerequisite and Co-requisite Courses

Course Duration

Competencies

1. Format cells.
2. Use automatic formatting and styles.
3. Get help.
4. Use large worksheets.
5. Work with multiple worksheets.
6. Use range names.
7. Use other functions.
8. Manage data.

Excel 2007: Level 3

Target Audience

Prerequisite and Co-requisite Courses

Course Duration

Competencies

1. Use AutoFilter.
2. Manage files.
3. Create charts.
4. Format charts.
5. Draw an object.
6. Use additional effects and objects.
7. Use shapes and SmartArt.

Excel 2007: Level 4

Target Audience

Prerequisite and Co-requisite Courses

Course Duration

Competencies

1. Use HTML files.
2. Work with comments.
3. Work with tables.
4. Work with advanced filters.
5. Export and import data.
6. Work with outlines.
7. Use advanced charting features.

Excel 2003: Level 5

Target Audience

Prerequisite and Co-requisite Courses

Course Duration

Competencies

1. Use conditional and custom formats.
2. Use templates.
3. Use Paste Special.
4. Customise Excel preferences.
5. Use worksheet protection.
6. Use multiple workbooks.
7. Share workbooks.

Excel 2007: Level 6

Target Audience

Prerequisite and Co-requisite Courses

Course Duration

Competencies

1. Work with data series.
2. Use advanced functions.
3. Create and revise pivot tables.
4. Use scenarios and goal seeking.
5. Use data tables.
6. Consolidate worksheets.
7. 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 and to learn about using macros.

Prerequisite and Co-requisite Courses

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

Course Duration

3.5 hours.

Competencies

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

1. Work with views.
2. Use auditing tools.
3. Use macros.
4. Record macros.
5. Edit macros.
6. Create macro buttons.