# Pivot Tables Power

Next masterclass: Pivot Tables Fundamentals – How Excel Pivot Tables Truly Work

# What numbers (e.g. top 10 products, sales by week, students performance by subject, etc.) do you want to watch using Pivot Tables? Join the conversation below…

• Sue Brems

This was really helpful. I am new to pivot tables and management requests them all the time. I would love to see more videos to help me become proficient at this. Thanks!

• MAHMOUD

Thank you

MY Guru
The presented material should be considered as a bible or a Roadmap for learning of Pivottable. Before, I dealt with PVT, but that was just trial and error to get what i want.
But now, I really appreciate putting me on the right track to deal with PVT,
Thanks a lot John

• Mukesh

I like ur this great think.
I have no word to say u thank u

• Gautam Shastry

God bless you John. Will be following your emails and other lessons of Pivot tables. Will ask questions when I complete all your videos for Pivot Tables. Thank you again for sharing the videos .

• John Franco

Thanks Gautam!

I am late replying to you because I have been busy preparing the next lessons and the in-depth “Pivot Tables Domination” course (coming in a few days). Looking forward to your questions

Dear John
As usual , perfect videos. you have presented the subject in an attractive way.
just, would you please provide us with the excel files, that used in Videos, to give us a chance to practice.
Regards

• John Franco

Practice files are coming on lesson 3

• Trevor R Bird

Video hangs are running 5 seconds – has been doing this for the past 3 days in over 10 attempts to watch it:-(

• Ray

Video hangs part way through.
Left it a very long time but no progress.

• Ramakrishna S

Very helpful to analyse the big data

• John Franco

Yes Ramakrishna! Pivot Tables are especially useful to deal with big data. E.g. you can analyze the crucial patterns that are in a 100k rows table without bringing Excel to its knees. Analyzing big data can also be done using VLOOKUP, Array Formula, SUMIF, etc., but there is a point when they become painful to write and maintain, and they do bring Excel to its knees.

The third masterclass will show some Pivot Table analysis blueprints to show some of the most typical metrics and we’ll use a big 50k rows file as an example. Stay tuned!

• William Dougherty

John ,
Right is spelled wrong in your presentation. I know this a small point of information but
it really turns people off to have such good info and have a mispelling right from the start. Please fix it.
thanks
Guiliermo

• John Franco

Thanks William for letting me know of the error. I fixed it!

• Ignacio De BustamaIInte

very interesting

• Mike

Pivot tables are a great tool.

• James

Video still not streaming….

• Terry Watanabe

For some reason or another the pivot lesson #1 is not progressing

• John Franco

Terry, please wait some seconds until the video buffers. It will play then.

• Terry Watanabe

How long will it take to buffer? It’s been hanging there for about 5 minutes

• John Franco

Normally it takes some seconds. Try some of these solutions: refresh the page, stop any other activity such as downloads, etc., wire your computer to the Internet network, update your Flash version, update your browser to the latest version

• Stanley Falinski

That was very inspiring. I tried Pivot Tables before and gave up. But now I will concour then because now I can see the power. I am a boss.

• John Franco

Great to hear that Stanley! Stay tuned for the next lesson because it will show you the Pivot Tables Fundamentals such as the relationships that lie hidden in your data, how Pivot Tables organize and store those relationships, and so much more! If you master these fine aspects of Pivot Tables, you will be able to take full advantage of PTs power.

• Leslie Glasser

Video just hangs!

• John Franco