Microsoft Excel Tips and Tricks - Computergaga

Home / Archives for Formulas

The GETPIVOTDATA Function in Excel

The GETPIVOTDATA function in Excel is used to query and extract data from a PivotTable. It is essentially a PivotTable lookup formula.

This function can be extremely useful. When your PivotTable updates, it may grow or reduce in size, or the field items may change order – GETPIVOTDATA will continue to extract the correct data.

In this blog post, we will show why the GETPIVOTDATA function in Excel is useful with an example, but then show an example of when we do not want it, and how we can turn the feature off.

[Read more…] about The GETPIVOTDATA Function in Excel

Excel CHAR Function with Examples

The CHAR function in Excel returns a character specified by a code, from the character set of your computer.

In this blog post, we look at why you might want to use the CHAR function, and some examples of it in action in Excel.

The CHAR function is typically used to insert, or to find, a character which you ordinarily cannot type from your keyboard.

To use it you will need to find out what the code is for the character you want to use.

You can search online for a full list of these character sets so that you know each code (or at least the one you need at the given time). These character sets differ between the Windows and Mac computers, and are also dependent upon the language used.

[Read more…] about Excel CHAR Function with Examples