Microsoft Excel 2007 - Level 2

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

This course shows you how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, and 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 2007 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:

  • use the fill operations available to fill a data series
  • move the contents of cells and ranges within and between workbooks
  • use a range of formula techniques
  • use a range of logical functions
  • apply a range of number formatting techniques to data
  • apply conditional formatting to ranges in a worksheet
  • apply borders to cells and ranges
  • work with various elements of a worksheet
  • use a range of techniques to work with worksheets
  • use a range of find and replace techniques
  • apply a variety of page setup techniques
  • sort data in a list in a worksheet
  • filter data in a table
  • use a range of techniques to enhance charts
  • apply formatting techniques to text on charts
Course Content: 
  • Filling Data
  • Moving Data
  • Formula Techniques
  • Logical Functions
  • Number Formatting Techniques
  • Conditional Formatting
  • Applying Borders
  • Working with a Worksheet
  • Worksheet Techniques
  • Finding and Replacing
  • Page Setup
  • Sorting Data
  • Filtering Data
  • Charting Techniques
  • Chart Text Formatting

Course Calendar

Contact Learning Lab for information on course dates.

For more information

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