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 |
|
Use custom fill lists and Flash Fill extraction techniques |
|
Insert, copy, rename, and hide worksheets |
| Use Print techniques to customise how content is printed |
|
Adjust default page margins and page layout options |
|
Use Page Breaks |
|
Apply borders |
|
Create and use IF functions |
|
Create more complex Formulas including SUMIF and VLOOKUP |
|
Copy and use Nested Formulas |
|
Use Date and Time formulas including TODAY, NOW, and DATE |
|
Define Names for a range of cells |
|
Create Custom Number Formats |
|
Use Conditional Formatting to apply formatting rules |
|
Use the Quick Analysis Tools |
|
Create and work with Tables |
|
Create and customise Sparklines |
|
Apply data protection to a worksheet or entire workbook |
|
Import data from other types of files including .txt, .csv, .accdb |
| Work with Connected Data |
|
Export data to other formats |
|
Link data between worksheets and workbooks |
|
Create an Automatic Outline |
|
Create a Manual Group |
|
Create a Subtotalled Worksheet |
|
Create, display and merge Scenarios |
|
Define a PivotTable structure |
|
Use PivotTable Grand Totals |
|
Create Calculated fields in a PivotTable |
|
Use Advanced Filters |
|
Use Data Validation techniques |
|
Create a worksheet with Controls |
|
Share workbooks and use Track Changes |
|
Record, view and edit a Macro |
|