Often we receive data in a format that is similar to a PivotTable, but that is not conducive to using that data to create a PivotTable to analyze that data. In order to convert the data to a tabular format to create our PivotTable, in this tutorial we will use Power Query to accomplish this.
Tag Archives | PivotTables
This 45 minute tutorial will cover all the basics you need to get started with creating and modifying a PivotTable in Excel. It includes instructions on Slicers, Timelines and PivotCharts, too, and discusses many PivotTable features including Report Connections, locating your PivotTable, changing the data range, Show Report Filter Pages, and much, much more! You […]
Quick Explore is a great tool from Excel that allows you to easily drill down into the details of your PivotTable by creating a modified PivotTable just for those details. However, it will only work in certain versions. So let’s take a look and see how to use Quick Explore in Excel.
Here is a quick tutorial on using PivotTables to count the number of times a date appears in a long list of data, plus how to fix a small quirk in Excel.
Hiere is how you can create a single PivotTable with data from multiple tables without the use of PowerPivot…..
It’s simple to connect several PivotTables to Slicers and Timelines in Excel using Report Connections…..