PivotTables are one of the most important features available in Microsoft Excel. They simplify data analysis, allowing you to create summaries and reports instantly, and they just got even better. The new Excel data model takes things a step further by letting you connect PivotTables to build out a miniature database. In this course, instructor Jordan Goldmeier shows you how to get up and running with PivotTable basics. Discover an approachable, foolproof way of thinking about PivotTables that allows you to build summaries across different column fields with ease from any dataset. Along the way, learn how to use PivotTable connections to create an interactive dashboard for replication and reuse.