Microsoft Office Courses
Excel Training Courses
Workshop 2 - Up skill to Excel 2003 or 2007
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 for full list
Workshop 3 - 2003/2007 (Intermediate to Advanced)
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 - 2003/2007 (Advanced)
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 for full list
2007 Excel - PivotTables (Intermediate to Advanced)
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....
Download Course Outlin for full list
Other Microsoft Office Courses
McMillan Bird Training offers computer training courses for small and large organizations in Australia, including Microsoft Office training courses:
Some of our clients include:
