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

If you are getting the Data source reference is not valid while trying to create a pivot table in Microsoft Excel, see this post for the fix.

In Microsoft Excel, changing the evaluated range on the fly requires a bit of work, but it's definitely possible thanks to the Offset() function.

Up-to-date information can be critical; these 4 tips will add flexibility and increase efficiency when refreshing pivot tables.