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