| Understand spreadsheet concepts and terminology | |
| Confidently locate and open workbooks on the computer | |
| Customise the Excel environment | |
| Edit existing data including being able to overwrite cell contents | |
| Highlight columns or rows adjacent OR not adjacent to each other | |
| Use copy techniques to duplicate or move content | |
| Create formulas to add, subtract, multiply and divide | |
| Use Functions including SUM, COUNT, AVERAGE, MIN and MAX | |
| Use Relative (B4) and Absolute ($B$4) cell references | |
| Use various formatting functions including Format Painter | |
| Create a series or pattern using AutoFill | |
| Use the Flash Fill feature to extract or combine data | |
| Apply number formatting including currency and percentage | |
| Customise column and row heights and hide columns or rows | |
| Perform number and text column sorting | |
| Apply filters to columns | |
| Print a worksheet, range or entire workbook | |
| Create a basic chart using different chart types | |
