Microsoft Excel 2003 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 areas such as workbook and worksheet consolidation and linking, data analysis tools and automating workbook operations using macros.

Learning outcomes:

Upon successful completion of this course, participants will be able to:

• Nest functions to create complex formulas
• Use advanced filters to analyse data in a list
• Use a variety of data validation techniques
• Use goal seeking to determine the values required to reach a desired result
• Create, use and modify data tables
• Create and work with scenarios and the Scenario Manager
• Create, modify and work with PivotTables
• Use linking to create more efficient workbooks
• Combine data in separate worksheets or workbooks using consolidation
• Publish workbooks and worksheets for the web
• Summarise data using subtotals and relative range naming
• Confidently open workbooks that contain macros
• Create recorded macros in Excel
• Use the macro recorder to create a variety of macros.