Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
PART 1: https://www.excelcampus.com/charts/pivot-tables-dashboards-part-1/
WATCH PART 2: https://www.youtube.com/watch?vg530cnFfk8Y
Download file used in the video: https://www.excelcampus.com/pivot-table-checklist-yt
In this video series, you'll learn how to create an interactive dashboard with PivotTables and PivotCharts.
Works with Excel 2003, 2007, 2010, 2013 for Windows and Excel 2011 for Mac
If you've never created a pivot table before, don't worry. I'll cover the basics of formatting your source data and creating your first PivotTable. You'll also see an add-in I developed called PivotPal that makes it easier to work with some aspects of PivotTables.
Download the files to follow along from the following link.
http://www.excelcampus.com/pivot-table-checklist-yt
I have another video that shows how to reformat the pivot chart in Excel 2010. In the video above I am using Excel 2013 and the menus are different from Excel 2007/2010. Here is the link to that video. http://www.youtube.com/watch?vJt_QqG-vRRw
Download PivotPal: https://www.excelcampus.com/pivotpal
Free webinar on the 5 secrets of understanding pivot tables: https://www.excelcampus.com/pivot-webinar-yt
Subscribe to my free newsletter: https://www.excelcampus.com/newsletter
Please take the opportunity to connect and share this video with your friends and family if you find it helpful.