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

• understand the basic principles of spreadsheets and how they work
• understand how to use a mouse, work with the menu system, shortcut menus, and the desktop
• create, save, open and close workbooks correctly
• us a number of techniques for selecting ranges
• understand basic principles of formulas and how they work
• use the copy and fill procedure
• apply a number of simple functions
• preview and then print a worksheet
• apply headers and footers
• create, modify and print a chart
• exit from Excel 2000 correctly
• understand the relevant health and safety issues relating to computer usage

• work with one or more workbooks at once
• format cells and ranges in a workbook
• adjust a worksheet to better accommodate data
• work with absolute and relative cell references
• use names and labels
• use the various Lookup function
• group cells and use outlines to manipulate the worksheet
• protect data in worksheets and workbooks
• sort data into alphabetical and numerical order
• use autofilter to display data in lists selectively.

• nest functions to create complex formulas
• use advanced filters to analyse data in a list
• use goal seeking to determine the values required to reach the desired result
• create, use and modify data tables
• create and work with scenarios and the Scenario Manager
• create, modify and work with PivotTables
• combine data in separate worksheets or workbooks using consolidation
• use linking to create more efficient workbooks
• publish workbooks and worksheets for the web
• create recorded macros in Excel
• use the macro recorder to create a variety of macros.