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