How to Change Series Data in Excel. To update your Microsoft Excel worksheet, you can add a data series to the source data and also update the worksheet chart to make your data meaningful to your ...

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.

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

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.

A couple of easy changes can greatly enhance the visual impact of a slicer. This walk-through shows you how.