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