I don't use PIVOT tables anymore... I use this other thing instead!

Рет қаралды 1,192,691

10 ай бұрын

That is right! I no longer use Pivot Tables in Excel. I am now using Power Pivot. In this video, let me show you what Power Pivot is and how to use it with Excel. Plus, you get to meet Chan2 again 😂
⏱ VIDEO TOPICS:
===============
0:00 - What is Power Pivot and how to create one in Excel?
1:12 - Why use Power Pivot instead of regular Pivot Tables?
3:25 - Practical example of Power Pivot & DAX
📺 LEARN MORE ABOUT POWER PIVOT & DAX:
=======================================
Beginner to PRO DAX Lesson with 20+ examples - kzfaq.info/get/bejne/hrdln6R9yaysc4k.html
How to write measures in Excel (another example) - kzfaq.info/get/bejne/r6d3naZmvMWWj4U.html
My Power Pivot playlist - kzfaq.info/sun/PLmejDGrsgFyCm0i58VobdriBr--FA8lYh
Advanced Pivot Table tips & tricks playlist - kzfaq.info/sun/PLmejDGrsgFyAurpKfvdwBsvBsRDsgvr2j
👩‍💻 LEARN MORE ABOUT REGULAR PIVOT TABLES:
==========================================
Introduction to Pivot Tables - Complete Tutorial - chandoo.org/wp/excel-pivot-tables-tutorial/
Introduction to Pivot Tables with 8 examples - kzfaq.info/get/bejne/l9WWpsehz9yvZ6s.html
Pivot Table mistakes you shouldn't make - kzfaq.info/get/bejne/bKdjmJaknr-ml6M.html
6 Pivot Table Tricks to Impress Everyone - kzfaq.info/get/bejne/j7FkfKd435qakpc.html
Creating Pivot Tables when you have lots of data - kzfaq.info/get/bejne/q5qRmL1l2tHWoX0.html
How to use Slicers in Excel - kzfaq.info/get/bejne/kMBdiKp-39rToaM.html
📁 SAMPLE FILE:
===============
Here is an Excel workbook with data for you to practice Power Pivot concepts - chandoo.org/wp/wp-content/uploads/2023/06/power-pivot-demo.xlsx
~
I made a pivot with average sales per day.
It was a mean report 😂
~
#pivottables #excel

Пікірлер: 476

@wirechair 9 ай бұрын

I used to use your forum/ website about 10 years ago to learn a lot about excel. It is amazing how the internet allow you to also come to youtube and do these further explainers and with a little sketch! Thanks for all your work and for being around all this time!

@peggymahabir6108 6 ай бұрын

I appreciate the way you bring across the content as if you are having a conversation, it made what could have been a complex thing to explain quite easy to understand. Thank you!

@stevendipietro2928 9 ай бұрын

This is the best explanation I’ve seen, especially around the mapping. Great job.

@Daithai96 9 ай бұрын

Always loved your website when I was working in IT - great to see you on KZfaq as well - you got me so many brownie-points with your dashboard tutorials. You are in my Hall of Fame of Excel heroes.

@chandoo_ 9 ай бұрын

Wow.. so good to hear that :)

@Daithai96 9 ай бұрын

@@chandoo_ Well, I did not expect a reply! Just wanted to let you know what a great job you're doing, please keep it up - tutorial/example sites like yours are invaluable to so many people

@ArunRajTutorials 10 ай бұрын

Love that you keep it original. Great video. Would help a lot of finance folks.

@ebred76 9 ай бұрын

This is great information and related to a project I want to do to track pieces at work. This is just what I need to track them with data across different table information that I have. Thank you

@benndii 10 ай бұрын

I have been working so much with Power Bi and M over the last few months that I nearly forgot about the excel basics. DAX in Power Pivot? I did not know about that but it gets a really BIG thumbs up from me. Thanks for showing.

@chandoo_ 10 ай бұрын

Great to hear!

@TheRacoon001 8 ай бұрын

Thank you for sharing and making the video! very informative and helpful.

@senpai.5517 10 ай бұрын

Chandoo, awesome content, as usual. I like the way you have presented it and it was nice meeting Chan2! Good team work.👏

@eldarikus 9 ай бұрын

Not only did I hit the Like button, but I also subscribed, such is the power of POWERPIVOTS!!!!!! and your awesome humorous video style. Good job bro! Well done! You are, in fact, awesome!

@manabsingha8153 10 ай бұрын

I like the sense of humour in you videos. This gives me a boost to see your videos more and more. Keep it up my Excel Master :)

@chandoo_ 10 ай бұрын

Happy to hear that!

@AlabasterClay 8 ай бұрын

Awesome video. You're a great teacher. Thanks!

@dheerajpatel5906 8 ай бұрын

Amazing information Chandoo. Helping me a lot with my daily activities. Thank you for the information!!!❤

@chrism9037 10 ай бұрын

Great video Chandoo. I am also using Power Pivot a lot more, though I still use regular pivot tables for simple analysis.

@chandoo_ 10 ай бұрын

Glad to hear that Chris. :)

@firstname4337 10 ай бұрын

distinct count has been so useful -- makes things so much easier

@prabhathkota107 8 ай бұрын

Beautifully explained in simple terms... learned something new, kudos ❤

@chandoo_ 8 ай бұрын

Glad to hear that

@anandchawda7061 9 ай бұрын

Hi Chandoo, very helpful…good to see your creative and funny side together!

@mandata143 10 ай бұрын

Didn't know Excel has this kind of power. Your content is 💯.

@michaeldruce4536 10 ай бұрын

Thanks Chandoo. I’ve always checked the add to data table box but wondered where or what it did

@amraouigroup Ай бұрын

Hi Chandoo, this is to thank you for the amazing, entertaining, and most importantly, instructive videos about Excel. You've truly succeeded in turning a dull technical subject into a funny and informative one, thanks to your talented humor and your smart and interactive scripts. Be brave and keep up the good work. All the best, my friend 😊👍🏻

@katemedina7123 9 ай бұрын

This is what I'm looking for before. Thank you for sharing this!

@cpajulio 9 ай бұрын

This is a great video. Love the humor too.

@davidingham2216 10 ай бұрын

Excellent video and a great presentation style. Thanks for sharing

@pjelbro3492 9 ай бұрын

Really good. Love the presentation style as well. Thank you

@amaan-the-analyst 3 ай бұрын

Thanks Chandoo bro! Always learning something valuable from your videos.

@davidsonmayck6937 5 ай бұрын

Thank you! You just helped me solve a huge challenge I had.

@broderp 9 ай бұрын

This explained a lot. Thank you!

@patrickwheeler1979 7 ай бұрын

Thanks for putting this together.

@h1tm4st3r5 10 ай бұрын

wonderfull man. Loved your video, you make everything looks easy!!! Congrats!!!

@Cricketer-007 5 ай бұрын

Love it. Thank you, Chandoo. You the best!!

@faridqanet4709 19 күн бұрын

That is awesome! Your teaching skill is on another level.

@lorenakademar5267 2 ай бұрын

Woow...great short and well explained video! thank you

@bondniko 8 ай бұрын

It is so nice to talk to a smart person...

@akashgautam1909 10 ай бұрын

Basically, it acts as an SQL query with join applied 😁

@eleghari 8 ай бұрын

And this data should have been in MSAccess in the first place...

@muralisub6534 7 ай бұрын

Why do we require 20+ years to have related tables

@nelzpelaez8517 10 ай бұрын

This is amazing! Easy to learn and easy to follow plus the antics. lol.

@franksims2037 3 ай бұрын

I love his videos! He is a lot of fun and very informative! 🙂

@SK-di6ti 10 ай бұрын

Thank you for sharing knowledge.

@Ed-zd2qb 7 ай бұрын

Had to click the like button for that, toing toing sound and expression... 😂😂😂

@user-kq3tc5tu1c 9 ай бұрын

Dooh! I really enjoyed clicking on the "Like" button. (Insert Chandoo's eyebrow movements!). Great job on this content. Cheers!😎

@GeertDelmulle 10 ай бұрын

I use both types all the time. One thing I miss in PP is the grouping feature in the rows from std. pvt tables. Building that into PP requires a ‘more advanced’ knowledge of DAX. BTW: DAX as a formula language is quite cryptic IMO, or as Alberto F. puts is: DAX is simple but it’s not easy. Still, the added power of PP is undeniable.

@chandoo_ 10 ай бұрын

Thanks for that. Yes, we are not able to "Group" with Power Pivot tables. I show a trick to get grouping in this video 👉 kzfaq.info/get/bejne/lbBiZtZyrN_epI0.html

@GeertDelmulle 10 ай бұрын

@@chandoo_ Thanks for that referenced video. :-) The thing is: it is not generic enough: I use/need the grouping for creating histograms, which in std. Pivot tables is easy to do,… and to reconfigure on the spot. (Nowadays you can also use dynamic arrays for this, as well.) And I mean: for more than ‘just’ dates. In order to do this dynamically (variable bin size) you need to use more advanced DAX functions (…) If you have a way of doing that (and a video to show it), I’d be happy to watch it. :-)

@chandoo_ 10 ай бұрын

I understand. My preferred method is to use Power Query and create "conditional column" with arbitrary bucket boundaries. If you have Power BI, you can natively group values just like we did in Excel.

@brijeshshah574 10 ай бұрын

Thanks for sharing such amazing knowledge 🙌🙏😇

@kossiviaglee2997 7 ай бұрын

I needed this. Now i know the difference between a simple pivot table and a Power Pivot table. Thanks!

@chandoo_ 7 ай бұрын

Glad it was helpful!

@shivangpant9639 8 ай бұрын

Really great explanation ♥️

@coram6248 10 ай бұрын

You are the funniest excel instructor!

@RFVisionary 10 ай бұрын

👍🏻 Very interesting hint. Funny made clip! 😊

@raimundojs9547 10 ай бұрын

Awesome! Indeed a game changer in Excel! Thanks for sharing.

@dhrumil5811 10 ай бұрын

Excellent . I always learn something from you. 👏🏻

@abhinav10x 10 ай бұрын

awesome! I have little query for creating pivot table is their need "data in range" format or can be create in table format, as previously described data should be in range format, please advise

@RohitSharma-vi8fh 10 ай бұрын

Thanks for Knowledge sharing☺

@agapheputrasusilo741 6 ай бұрын

What a life saver, thanks Chandoo !

@equiwave80 10 ай бұрын

Excellent video. Thanks for sharing!!!

@dkypa 9 ай бұрын

You are the only guy made learn excel made like watching cartoons.

@beesettigopikrishna6161 10 ай бұрын

Thanks Chandoo Sir for sharing such awsome and cool excel tricks.

@silenceofharmony Ай бұрын

:) Besides providing very useful information,I have a lot of fun while watching your videos.

@blanchebayla 10 ай бұрын

Your videos are always amazing Chandoo. Thanks for sharing!

@chandoo_ 10 ай бұрын

Glad you like them!

@moutazeldeib9481 9 ай бұрын

Amazing Chandoo and thank you very much for all your valuable information

@deniseherud 7 ай бұрын

this is mind blowing--thank you!!! i just inherited another role at my company, and the person who designed one of the spreadsheets i'll be using, wasn't a power user...this info is going to be lifesaving for me❤ Is there a limit to the number of columns i can use with power pivot??? i have a dozen or so that i'll be working with on a supercharged coverage file.

@JohnMatthew1 3 ай бұрын

Brilliant, thank you for this, helps a lot.

@shindepratibha31 9 ай бұрын

Thanks for the amazing video. Is there a way to refresh pivot tables on the protected sheet?

@AtulBaluni 10 ай бұрын

Amazing Thanks for sharing.

@MAsif-xc7pb 3 ай бұрын

Well explained. thanks and regard.

@WAIT4GOD 7 ай бұрын

Awesome video, love it!!!!

@alfredtomiamubiaya3330 10 ай бұрын

Always awesome Chandoo. Thanks for awesome video always.

@user12345654 7 ай бұрын

1:11 Even Superman looks like a normal dude until he puts on the underpants on top. Amazing quote ! 🤣 👍

@hamzahsayap8844 6 күн бұрын

Greatest explanation❤

@namy1557 10 ай бұрын

Beautifully explained with some interesting video creativity, Learning while enjoying watching videos is great fun.. Keep it up Chandoo.. 😇✌🏻

@andrewoconnor2760 8 ай бұрын

Love your work :-D

@shilpatadas7152 8 ай бұрын

Amazing 👏👏👏💡🙏

@nadidecifci4533 10 ай бұрын

Awesome 👏 👏👏please do more videos about power pivot 🙌

@manndipp 9 ай бұрын

Thanks for helping us to increase our knowlege

@DharshaniRajendran 10 ай бұрын

Your videos are mind blowing like always.. I have a doubt.. can we extract data from web which is in bar chart form?

@soumyajeetmitra6958 3 ай бұрын

Wow! great learning from you!

@sivakumars8920 2 ай бұрын

Nicely presented sir, and explained in simple language..

@danielnichols3594 10 ай бұрын

I still use Power Pivot every day even though I've moved on to Power BI. Measure portability and the advantage of DAX measures over calculated fields/calculated items in standard Pivot Tables are key selling points of Modern Excel, aka Power Pivot. And Power Query gives you reusability of data transformations so you spend less time manipulating data & more time analyzing your operations.

@chandoo_ 10 ай бұрын

AWESOME points... With "Analyze in Excel" you can build your models in Power BI and still have them available in Excel for reporting.

@indrajaravi6945 10 күн бұрын

Why did you move to Power BI?

@PedroMartins-bi9bl 8 ай бұрын

congrats to you great video!

@leilabardien7582 8 ай бұрын

This was really good 😂

@chinyerenwigwe5166 10 ай бұрын

I know I discovered gold the first day I subscribed to your channel!!!

@sergioancaojr 10 ай бұрын

Awesome content.. very useful for us basic users of excel.. keep it coming dude. I love your humble approach on technical issues with 2 personality acting! I like the superman analogy..😂😂😂

@chandoo_ 10 ай бұрын

Thank you :)

@chrishorn9372 2 ай бұрын

Thanks. Learn't something new about Pivot tables. Much appreciated.

@chandoo_ 2 ай бұрын

You are welcome. Thanks for the super ❤

@aicx40 10 ай бұрын

Awesome! Thanks for sharing.

@xxxxxfirefoxxxxx 9 ай бұрын

wow you earned my subscribe. Very very useful, I'll be using this for work

@patrickcardon1643 Ай бұрын

First time someone managed to stuff underpants into power pivot tables ... super!

@FranFerioli 9 ай бұрын

Power Pivot and Power Query are very powerful indeed. My complaint is that it's a lot of clicking and submenus. Almost immediately you get into DAX (for Power Pivot) and M language (for Power Query). Alternatively, you can use Python to clean your data, calculate what you need and write an excel file for plotting and sharing. At the end it's a matter of personal preference, but I find Python applicable to a wider set of problems although it does not fully substitute excel (for me at least).

@shadowlynxv6082 8 ай бұрын

Wait. Can you stick Python into Power Pivot. And if so, 1:06 is it better than Dax or M?

@FranFerioli 8 ай бұрын

@@shadowlynxv6082 I don't think so and it is not what I meant. I use Python to format the data and write a table/excel file. It is then very easy to import clean data with power query in an excel file I use for visualisation (copy-paste also works for relative small sets). The problem with power query/pivot is that it becomes exponentially more difficult if you have to manipulate data.

@shadowlynxv6082 8 ай бұрын

@@FranFerioli oh. I see.