Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.

Slicers are a great tool for filtering a data set or PivotTable. Learn how to use one slicer to manipulate more than one PivotTable or PivotChart.