Microsoft Office Courses

Excel Training Courses

Workshop 2 - Excel 2003 or 2010

Duration: 1 day

Course Aim:

The aim of this Excel course is for the attendee to learn how to create, format and print a spreadsheet data model that contains text, values and calculations efficiently and effectively.

This important workshop is the foundation course for workshops 3 and 4 and is ideal for those that are self taught and wish to up skill.

Topics include creating formulas, inserting functions, multiple page printing, views, filling numbers, text and formulas, plus more....

Download Course Outline

Workshop 3 - Excel 2003 or 2010

Duration: 1 day

Course Aim:

The aim of this Office Excel workshop is to cover the tools and functions that will equip the attendee to develop spreadsheet data models that contain complex formulas and functions that link multiple worksheets\workbooks and to generate detailed reports from lists of data.

This course is ideal for those that have completed Excel Workshop 2 and are ready to learn more advanced features.

Topics include absolute formulas, linking worksheets and workbooks, fixing errors, advanced functions, filtering data, pivot tables, plus more....

Download Course Outline for full list

Workshop 4 - Excel 2003 or 2010

Duration: 1 day

Course Aim:

The aim of this Microsoft Office Excel course is for the attendee to learn about the advanced features of Excel that help automate and customise a single or multi-user spreadsheet environment.

This course is for users that have completed Excel Workshop 2 and Excel Workshop 3 or have a good working knowledge of Excel.

Topics include advanced filtering, histogram tool, database functions, templates, data validation, scenario manager, plus more....

Download Course Outline

Excel - PivotTables 2010

Duration: ½ day

Course Aim:

The aim of this Excel workshop is to enhance the attendee's skills and knowledge of Excel to summarise large amounts of data and to analyse it in a variety of ways.

Topics include creating, modifying and updating pivot table fields, grouping and ungrouping pivot table data, performing calculations within pivot tables, plus more....

Some of our clients include:

Lend Lease Hornsby Shire Council Skillgate Bovis Lend Lease