Excel Pivot Tables Tutorials
Learn how to use Pivot Tables to analyze lots of data and create awesome reports with drag & drop ease.
Pivot Tables in Excel are one of the most powerful features within Microsoft Excel. A Pivot Table allows you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, “pivot”/change the report layout with the ease of dragging fields around, highlight key information to management and include Charts & Slicers for your monthly presentations.
Read on for the top things you can learn about Excel Pivot Tables!
Top 10 Tutorials
- 50 Things You Can Do With Excel Pivot Tables– I have compiled an interactive tutorial on the 50 different things you can do with an Excel Pivot Table.Read more
- Use An External Data Source To Import Data Into An Excel Pivot Table– When creating an Excel Pivot Table, what happens if your data source is in another location? You can simply use the External Data Sources feature in your Pivot Table and Excel will magically import the data for you!Read more
- Connect Slicers to Multiple Excel Pivot Tables– What about if you had multiple Pivot Tables from the same data set and wanted to connect a Slicer to all of the Pivot Tables, so when you press a button all the Pivot Tables change?Well this is possible with the Report Connections (Excel 2013, 2016, 2019 & Office 365) / PivotTable Connections (Excel 2010) option within the Slicer.Read more
- Group By Month With Excel Pivot Tables– Before I was a Pivot Table guru, I had to get individual rows of daily sales and group them into a report showing the monthly sales during the year. Thankfully there is the Pivot Table way (I wish I had known this back then), which is quick and reduces the risks of making any errors.Read more
- Customize an Excel Slicer– Excel Slicers are very boring looking and there are only 14 different Slicer Styles to choose from, ranging from Light to Dark and with a few colors to choose from. Read on if you want to create your own Slicer using your creative mind with super cool colors and fonts!Read more
- A PivotTable report cannot overlap another PivotTable report – Ever had the scenario wherein you updated your Pivot Table data source, then tried refreshing your Pivot Table, and this error shows up: “A PivotTable report cannot overlap another PivotTable report.” Keep on reading!Read more
- Show Averages With an Excel Pivot Table– A Pivot Table is the most powerful feature within Excel as it allows you to analyze your data in many different ways, all with a press of a button. The Summarize Values By option allows you to choose a type of calculation (Sum, Count, Average, Max, Min, Count Numbers Product, StdDev, StdDevp, Var, Varp) to summarize data from the selected field.Read more
- The Ultimate Guide to Excel Pivot Table Slicers– Pivot Table Slicers are a visual filter in the form of an interactive button. There are several cool things that you can do with Pivot Table Slicers, like customize them, filter them, connect them to multiple Pivot Tables plus much more!Read more
- Lock the Excel Pivot Table but not the Slicer– Sometimes when you are sharing an Excel Pivot Table with your colleagues you do not want the other user(s) to mess with your Pivot Table layout and format. What you can do is lock the Pivot Table and only allow the user(s) to select the Slicers, making your report interactive and secure from Excel novices like your boss.Read more
- Top 3 Excel Pivot Table Issues Resolved– I have shown my Free Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table. Read on to see the top 3 Excel Pivot Table issues resolved.Read more