WATCH PART 2:

Download file used in the video:

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 PivotPal that makes it easier 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:

Nguồn: https://intecexpo.com/

Xem thêm bài viết: https://intecexpo.com/category/cong-nghe

Very good presentation. Insightful and value added.

I am going to follow the rest of the tutorials. thanks

Very Good video – thank you!

Just starting and already impressed

Amazing tutorial but I can't find the part where he explains how to create the trend chart

thanks a lot it was very helpful.

It is very easy to follow, thank you!

This is an excellent tutorial.

Thank you the time is good, the explanation too

thank you so much! easy to follow, clear explanation 😉

I am so impressed with how you are explaining stuff. This will help me so much with a new role I am hoping to get. do you have video on more advanced stuff like index matching and using formulas in conjunction with each other ie If and vlookup.

I was just going to take a course on that, it helped quit big, thank you for your video

this is so helpful

thank

Well done! You are very clear, and easy to understand. Thanks

Thank you for this video! 🙂

Best one ! Thanks Man ! Love it.

Woow, Amazing

Just came across this, and already super impressed.

what if you don't want the sum of something but you want all of the numbers listed in a table?

Thanks a lot but please what do you mean about dashboard

Enkosi

I usually get the end product of excel reports and this video opened my eyes to a whole new world. Thank you

Excellent presentation!!!

So… for whatever reason, I see many job offers present handling pivot tables as "advanced" usage of Excel. I have even seen some that say things like "Options: begginer (formulas), Intermediate (Macros), advanced (Pivot tables)". There are employers out there who think that MACROS are more basic than Pivot tables? what am I missing here?.

Where can you find chart elements 10:14 in Mac excel? Thanks!

i cant find the excel file you used to download

Great video!!!

Good job bro…

Very nice!

Killing it my man. Great job.

Wow! This was an amazing video! Why are there so many dislikes on this video? I don't understand!

I built a tracker using this video series a few years ago that became very popular at my job as a result, and that i still regularly maintain. Looking back now, it's amazing how much of this is superfluous by using Power Pivot and DAX to insert charts based off the data model. Nevertheless, I credit this video series with helping me learn what I needed to get me where I am today!

Very helpful- thank you!

I'm watching this in 2019 and it's been very helpful. I'm going to use it to analyze data for my final year project. Thank you so much.

The video was helpful however, I didn't really how dashboards is tied to this.

One of the best tutorial that I have seen.

Thank you for this help! The tutorial and corresponding excel data sheet was so helpful!

Excellent…