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 can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
In this tutorial you will see how to use PivotTables and other related options to create a simple dashboard such as this:
It will include two PivotTables:
And a PivotChart:
All of these are linked together and will dynamically change as the PivotTables are modified/filtered. Watch the video and see how easy working with PivotTables can be.
Then, take a few minutes and search my website for “PivotTables” to see dozens of other tutorials on a variety of additional features and tips on this powerful and efficient Excel tool!
What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!