Pivot Tables and Data Modeling

Pivot Tables are one of the most important features in Excel. They let you create summaries and reports instantly. Excel’s new data model takes this a step further by letting you connect Pivot Tables to create a mini database. This course will start with Pivot Table basics. We’ll go through a fool-proof way of thinking about Pivot Tables that will allow you to build summaries across different column fields from any dataset. Once we know how to work with Pivot Tables we’ll see how to connect them. Ultimately, we’ll use these connections to create an interactive Dashboard.