Excel has a surprising limitation that you may not discover until you try to enter more than 15 digits in a cell. The application can only store numbers with15 digits of precision.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.

Whether you prefer Excel, Numbers, or Google Docs, here's what you, the savvy spreadsheet user, should know how to do.