Tel: 1300 TO TRAIN

Email: info@advancedtraining.com.au

IT Training with Advanced Training



EXCEL 2007 Level 3 (Advanced Data Analysis with Microsoft Excel)


Course Description

Microsoft Excel 2007 Level 3 focuses on the more advanced features of Excel 2007. Advanced anaylsis tools, especially pivot tables, Solver, outlining and summarising are covered, as are some key automation features such as Macros. Microsoft Excel 2007 Level 3 assumes a good general understanding software and experience in the construction and modification of workbooks. The student should be able to copy within Excel, create charts, and create basic formulas.

Outcomes

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



User Reviews

Good Stuff (Rating based on 61 reviews)

97%
of respondents recommend this course to a friend.


Click here to Read Reviews

Course Info


Next Step

Enquire Now
Tell a Friend
Email Course Outline

Course files