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