Microsoft Excel 2007 - Level 3

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

This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with workbook automation and productivity features. It includes advanced analysis tools, especially pivot tables, Solver, outlining and summarising 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:

  • use a range of lookup and reference functions
  • modify Excel options
  • create and use labels and names in a workbook
  • protect data in worksheets and workbooks
  • summarise data using subtotals and relative range naming
  • use data linking to create more efficient workbooks
  • use the Data Consolidation feature to combine data from several workbooks into one
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • use goal seeking to determine the values required to reach a desired result
  • group cells and use outlines to manipulate the worksheet
  • use Solver to solve more complex and intricate problems
  • create recorded macros in Excel
  • use the macro recorder to create a variety of macros
Course Content: 
  • Lookup Functions
  • Setting Excel Options
  • Chart Object Formatting
  • Labels and Names
  • Protecting Data
  • Summarising and Subtotaling
  • Data Linking
  • Data Consolidation
  • PivotTables
  • PivotTable Techniques
  • PivotCharts
  • Goal Seeking
  • Grouping and Outlining
  • Solver
  • Recorded Macros
  • 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.