Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

Sparklines are small charts that fit into a single Microsoft Excel cell. But if you're tracking non-numeric data, they can exhibit weird behavior. Learn how to avoid problems when using sparklines.