At the completion of this level students will be able to:

• understand the origins of and basic uses for spreadsheets
• start Microsoft Excel, navigate workbooks, and exit correctly
• create, modify, save, and close a simple workbook
• select ranges of cells in a workbook
• create formulas that perform calculations in a workbook
• copy and fill data in a workbook
• create and work with functions in a workbook
• print data in a workbook
• create a variety of charts (graphs) in Excel
• access and use the help system and work safely with your computer.

• work with one or more workbooks at once
• use a range of techniques to work with worksheets
• adjust the sizing of columns and rows in a workbook
• use a variety of viewing techniques to view worksheets
• format cells in a workbook
• understand and use absolute referencing in a workbook
• use the fill technique to enter data into cells
• use names and labels
• use a range of logical functions
• use the various Lookup functions
• sort data in lists in a workbook
• use autofilter to display data in lists selectively.

• 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.