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

It is very easy to dissect the contents of a cell in Excel using the functions LEFT, MID, and RIGHT. All three functions are easy to learn.

Not all sort tasks in Microsoft Excel begin with the characters to the left, but getting around that issue is easier than you think. Susan Harkins shows you how.

Because there are hundreds of functions to choose from, Excel groups functions into categories to make it easier to find the right function for a particular calculation.