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 CHOOSE and LOOKUP |
|
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 |
|