| Working with Large Worksheets |
List Management |
| Viewing options |
Working with lists |
| Hiding and displaying data |
Sorting and filtering lists |
| Printing large worksheets |
Advanced filtering |
| Multiple Worksheets and Workbooks |
Advanced Formatting |
| Using multiple worksheets |
Borders and shading |
| Linking worksheets by using 3-D formulas |
Using special number formats |
| Consolidating data |
Working with dates |
| Linking workbooks |
Working with styles |
| Managing workbooks |
Other advanced formatting |
| Customising Excel |
Using Templates |
| Changing options |
Built-in templates |
| Customising toolbars and menus |
Creating and managing templates |
| Advanced Charting |
Documenting and Auditing |
| Chart formatting options |
Comments and text boxes |
| Creating combination charts |
Auditing features |
| Using graphic elements |
Protection and collaboration |
