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

Design is best, but when you're stuck with an existing data structure, it helps to know how to work around trouble. Susan Harkins explains.

In Microsoft Excel and other popular modern spreadsheet programs, text and numbers are displayed in a rectangular grid of cells. Generally, every cell in a row or column has the same size, so you ...