Advanced formulas, functions, and arrays
Text functions
Information functions
Using array formulas
Labels

Advanced editing and formatting
The Paste Special command
The Go To Special dialog box
Advanced formatting features

Advanced graphics
Creating a custom chart
Working with pictures

Analyzing data
Using add-ins
Solver models and reports
Statistical analysis tools

Sharing information
Embedding and linking
Working with other users

Advanced customization
Custom lists
Changing default settings
Automating Excel
Arranging and splitting windows