Introduction to Pivot Tables, Charts, and Dashboards in Excel

Introduction to Pivot Tables, Charts, and Dashboards in Excel

In this video series, you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac.

Don't worry if you have never created a Pivot Table before, I cover the basics of formatting your source data and creating your first Pivot Table as well. You will also get to see an add-in I developed named pivotal that makes it easier to work with some aspects of Pivot Tables. 

have another video that shows how to reformat the pivot chart in Excel 2010. In the video above I'm using Excel 2013 and the menus are different from Excel 2007/2010. Here is the
Download also:

• Project Tracker Excel Template
• Project Timeline Excel Template
• Cash Flow Statement Excel Template
• Cost & Schedule Risk Analysis Excel Template
• Milestone and task project timeline excel template
• Monthly Budget Accessibility Guide Excel Template

Download file used in the video