The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions. Sometimes you need to know the number of actual data points without counting blank cells.

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.

Excel gives you quite a few options to choose from under Number > Date in the Format Cells dialog (which, again, you get to by pressing Ctrl-1 or Command-1 on the Mac).

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

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

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

We'll dive deep into Excel workbooks in this guide, starting with the basics and diving straight into powerful three-dimensional workbooks.