Microsoft Excel 2003 - Level 3

Duration: 
1 Day
Class Size: 
Max 10 Students
Time: 
9.00am – 4.30pm
Price: 
$350 incl GST
Microsoft Excel 2003

This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with workbook automation and productivity features. It includes areas such as workbook and worksheet consolidation and linking, data analysis tools and automating workbook operations using macros.

Who Should Attend: 

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks.
Students should of already completed Excel Level 1 & 2 courses or should know how to create and save excel workbooks, create formulas, use functions and perform simple formatting of the data before doing this course.

Course Pre-requisites: 

Good working knowledge of Microsoft Excel to an intermediate level. Students should already know how to create and save workbooks, create formulas, use functions and perform simple formatting.

Course Objectives: 

At the completion of this course participants will be able to:

  • Nest functions to create complex formulas
  • Use advanced filters to analyse data in a list
  • Use a variety of data validation techniques
  • Use goal seeking to determine the values required to reach a desired result
  • Create, use and modify data tables
  • Create and work with scenarios and the Scenario Manager
  • Create, modify and work with PivotTables
  • Use linking to create more efficient workbooks
  • Combine data in separate worksheets or workbooks using consolidation
  • Publish workbooks and worksheets for the web
  • Summarise data using subtotals and relative range naming
  • Confidently open workbooks that contain macros
  • Create recorded macros in Excel
  • Use the macro recorder to create a variety of macros.
Course Content: 
  • Lookup Functions
  • Nesting Functions Workshop
  • Advanced Filters
  • Validations
  • Goal Seeking
  • Scenarios
  • Summarising Data
  • PivotTables
  • Consolidation
  • Macro Virus Control
  • Recorded Macros
  • Data Tables
  • Excel On The Web
  • Recorder Workshop

Course Calendar

Contact Learning Lab for information on course dates.

Student Handbook

To access the student handbook please click the following link. Student Handbook.

For more information

Please call 02 9318 1222, or contact our Support Team online. Alternatively, use our contact form to send us an email.