Microsoft Excel 2007 Level 3

Who should do this course?

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 and 2 courses or have equivalent skills.

About the course:

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.

Learning outcomes:

Upon successful completion of this course, students 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