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

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

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.

Learn how to create Excel dynamic total rows that adjust automatically with your data. Save time and simplify data management with these ...

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

Microsoft Excel’s mobile app lets you to take a picture of a table and paste the data directly into your spreadsheet. Here's how to use it.

A. Excel’s TRIMRANGE function and trim references help users quickly tidy up datasets. This makes for a cleaner, easier-to-follow, and more efficient spreadsheet.

Microsoft expands Excel's real-time "data types" by adding support for your data, as well as hundreds of sources from Wolfram Alpha.