Microsoft Excel 2003 - Level 2

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

This course shows you how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and to use the sorting and filtering features to manage and analyse data.

Who Should Attend: 

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.
Students should have already completed Excel Level 1 course or know how to create and save an excel workbook, enter simple formulas and print and chart data.

Course Pre-requisites: 

This course is aimed at participants with a working knowledge of Microsoft Excel who wish to extend their understanding of the automated and time saving features of the application.

Course Objectives: 

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

  • Work with one or more workbooks at once
  • Use a range of techniques to work with worksheets
  • Adjust the sizing of columns and rows in a workbook
  • Use a variety of viewing techniques to view worksheets
  • Format cells in a workbook
  • Understand and use absolute referencing in a workbook
  • Use the fill technique to enter data into cells
  • Use names and labels
  • Use a range of logical functions
  • Use the various Lookup functions
  • Sort data in lists in a workbook
  • Use autofilter to display data in lists selectively.
Course Content: 
  • Working With Workbooks
  • Working With Worksheets
  • Adjusting a Worksheet
  • Viewing Worksheets
  • Absolute Referencing
  • Filling Series
  • Labels and Names
  • Logical Functions
  • Lookup Functions
  • Sorting
  • AutoFilter

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.