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

Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

You can use the VLOOKUP function in Microsoft Excel to efficiently find corresponding data for a specific value.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Microsoft Excel affords considerable control over the data your store in it. VLOOKUP is a great way to find and return data, which can then be presented in various other ways.

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Learn how to Circle Invalid Data in Excel. We also show you how to remove Invalid Data, and validate and approve the circled data.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.