wordpress related posts

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

Posted On April 28, 2019 at 7:35 am by / No Comments



WATCH PART 2:
Download file used in the video:

In this video series you will learn how to make 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 made a Pivot Table before, I cover the basics of formatting your source data and making your first Pivot Table as well. You will also get to see an add-in I developed named PivotPal that makes it simpler to work with some aspects of Pivot Tables.

Download the files to follow along at the following link.

I 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 link to that video.

Get PivotPal:

Free webinar on The 5 Secrets to Understanding Pivot Tables:

Subscribe to my free newsletter:

source

Leave a Reply

Your email address will not be published. Required fields are marked *

Translate ยป