DON'T Make These 5 Pivot Table Mistakes

Рет қаралды 170,670

Күн бұрын

💥Want to learn ALL of Excel? Go for Excel School - chandoo.org/wp/excel-school-p...
~
Pivot Tables are a staple diet for data analysts all over the world. But are you ruining them with these 5 mistakes? In this video let's understand how 5 silly mistakes can make your pivot tables WRONG.
Video topics ⏱👇:
===============
0:00 - The 5 mistakes you make with Pivots
0:23 - Mistake 1 - Using cell ranges when making pivot
2:08 - Fixing the mistake with tabular data
4:03 - Mistake 2 - Just using default options
5:13 - Mistake 3 - Making a static pivot report
6:35 - Mistake 4 - Pivoting from just ONE dataset
9:43 - Mistake 5 - Not using Power Pivot
11:14 - Learning more about Pivot Tables
📗 Sample Workbooks:
===================
Practice the concepts using the sample workbook data here -
chandoo.org/wp/wp-content/upl...
💻Learn more:
=============
Complete Excel for Data Analysis work - Step by step course 👉Check out my Excel School program to learn and use Excel effectively. chandoo.org/wp/excel-school-p...
Excel Pivot Tables - a complete guide (must read) - chandoo.org/wp/excel-pivot-ta...
Advanced Pivot Tables (playlist) - • Easily link Slicers to...
Getting started with Pivot Tables (make 8 pivots in 10 minutes) - • How to use Pivot Table...
How to make Pivot Tables when you have LOTS of data - • How to make pivot tabl...
Excel for Data Analysis (playlist) - • Beginner to Pro FREE E...
~
What is Ross' favourite Excel feature?
PIVOT, PIVOT, PIVOT!
You have a beautiful day 🌞🌻😃
#Excel #PivotTables

Пікірлер: 210

@OhSugarwastaken 2 жыл бұрын

Whoa...data model. I love this channel.

@chandoo_ 2 жыл бұрын

Glad you enjoy it!

@tonybridgeman 2 жыл бұрын

Mindblown :o

@caraziegel7652 2 жыл бұрын

I'm so glad that you keep showing up on my youtube front page. I have been using pivot tables on and off for decades, and even took a college course on excel in the middle of that . . but sometimes I forget, or features change when I'm not looking. I knew there had to be a way to combine tables and do calcs and change titles, but I was too lazy to look. I love your videos!

@BalrogsHaveWings Жыл бұрын

More great tips, thanks again Chandoo! Random thought: When it comes to naming ranges, I tend to use a prefix to identify what it is... For example, a table name begins with "tbl", or a list name begins with "lst"... I find this helps me sort of categorise my ranges, search and identify them easily.

@stopthink9000 Жыл бұрын

Data models are a game changer. It is best to know details about "single to many" and "many to many" behaviors when building relationships. It would also be good to learn about primary key and foreign key when building out your reports. The data modelling /DAX measures features also come in handy in Power BI.

@terihandrick2333 2 жыл бұрын

Wow I love #4 & 5 and will start using them tomorrow. You always have the best information to share and in the most simplistic manner!! You rock as always. Thank you

@chandoo_ 2 жыл бұрын

Wow Teri.. Thank you so much for your lovely testimonial :)

@BlockFHatter Жыл бұрын

Brilliant refresher on new aspects within excel. Chandoo is so good at communicating in an easy to understand way.

@malaninyirenda1190 2 жыл бұрын

Thanks Chandoo, your lessons are always valuable to me since I started following this Channel I have improved greatly with my Excel skills I enjoy watching all your videos. Looking forward to pay for the Excel school one day.

@chandoo_ 2 жыл бұрын

Thank you Malani. It is my pleasure to share what I learn with all of you :)

@Syed48 2 жыл бұрын

I knew most of these tips. But i know them because i watched your previous videos :) I love your videos, small things -like your transition during repetitive steps, the sound during a shortcut etc., speaks a lot about the effort you put to make your videos interactive and succinct at the same time. Thank you, Chandoo!

@chandoo_ 2 жыл бұрын

Thanks for the lovely comment Syed. 😃

@ayotundeodunlami8573 Жыл бұрын

Many thanks Chandoo. Your lessons are right on point and very rich.

@user-pz6et7bi5w 11 ай бұрын

I am happy to learn that I was using majority of these features on my day today work. Measures was new to me and few shortcuts are also very helpful. Thanks for this video ❤

@chrism9037 2 жыл бұрын

Excellent, thanks Chandoo!

@godxavier 2 жыл бұрын

This is so useful, especially the relationship between the two tables.

@chandoo_ 2 жыл бұрын

Thank you Salil...

@sujinpelker 2 жыл бұрын

You are such a talented teacher. Thanks for sharing great tips! I always enjoy your content!

@chandoo_ 2 жыл бұрын

You are so welcome!

@keeloraz9452 Жыл бұрын

Yar this is really good. I knew when I found Chandoo's youtube channel it'll be awesome. Love this guy

@excellaleathers5765 Жыл бұрын

Chandoo this is awesome 🌟 Combining two tables in a pivot saves a lot of time

@Ohman401 Жыл бұрын

All those copy paste to next column to find variance is gone from today :) Thank you for the video👏

@timmytesla9655 2 жыл бұрын

This is very insightful. Now, I need to learn how to use data model. Thanks for the video.

@cmyocum 2 жыл бұрын

As always, thank you. Good reminders and learned something new!

@specificgravity-thedancing9700 Жыл бұрын

Chandoo you make excel fun! Thank you!

@EvaDarknes 2 жыл бұрын

Thanks Chandoo, You rock!

@AP-eb8hd Жыл бұрын

Informative as always !! Thanks Chandoo..

@SashaHouseOfFashion Жыл бұрын

Really start loving your videos...thanks for educating us.

@rmmccarthy1240 Жыл бұрын

Thank you, Chandoo!

@salehmuhammad6811 2 жыл бұрын

Great Chandoo these really helpful to whom they just think statically now they have something to go out side the box.

@chandoo_ 2 жыл бұрын

Yes they do

@marceljunioregondi5594 Жыл бұрын

Chandoo thank you big time am learning loads.

@sp-uv6kc Жыл бұрын

Excellent tutorial on relationships. Thank you

@buddhahat 2 жыл бұрын

Fantastic information presented in a crystal clear format, thanks Chandoo!

@chandoo_ 2 жыл бұрын

You are welcome Buddha

@tutsecret499 Жыл бұрын

Thank you very much for the data file so that I can practice it.

@1mmightygyan879 2 жыл бұрын

Thanks for showing relationship creation.

@saaneroa5024 3 ай бұрын

Excellent video Chandoo!

@LizMAlex 2 жыл бұрын

Thanks for sharing these. #4 &#5 for the win!

@TinyMagiq Жыл бұрын

Brilliant learnt connecting 2 table and using measures. Thank you.

@ayobnubbee5428 6 күн бұрын

Thanks Sir Chundoo, with power query, I was getting no joy, build a relationship using the graphics but on the pivot it still gave me totals on all rows. This was quicker and better.

@sebghatulbarykhabaey6680 Жыл бұрын

Your teaching, Mike and Leila are most useful. Thanks for your kind teachings.

@chandoo_ Жыл бұрын

You're very welcome!

@MarcelousTV Жыл бұрын

You are amazing. Here I am thinking I was great at Excel. After your videos, I will be for sure! Thanks!

@shashirajusiddaraju4979 Жыл бұрын

Nice tips Chandoo!, Thanks

@thangaveluraj 2 жыл бұрын

Immensely helpful.. thank you... Keep rocking...

@vramarathnam Ай бұрын

Thank you very much. Very helpful to me. Nice teaching.

@kg.507 2 жыл бұрын

Great, Thanks for this info. Really useful.

@onsenguy 11 ай бұрын

another awesome video chandoo. 👍👍

@hilmansyahbo5492 Жыл бұрын

Hi Chandoo... One thing I don't really like about Table, when the size of table is quietly big, the speed of Pivot Table when refreshed was impacted a lot. I prefer to use a normal range instead of table, but I used dynamic range (name range), so when the data adding, no need to change manually the source of the Pivot Table Range. One thing also I don't like about Table, when we working with macro, when the size of the table is big enough, the running speed of the macro also impacted.

@vijayarjunwadkar 2 жыл бұрын

Hi Five 🙌 to Chandoo, for the "five" mistakes highlighted with resolutions and it is super useful for sure! 😊👍

@chandoo_ 2 жыл бұрын

Glad it was helpful!

@jobazooka8634 2 жыл бұрын

OMG... at 05:18... the 'banded rows' option.... I never knew this one! Thx a bunch... that's awesome! :D

@muhammadakteruzzaman2299 2 жыл бұрын

@Chando you are my hero, please keep it up your good work-rest will be followed

@surajbhardwaj428 2 жыл бұрын

Pivot table makes data understandable in quick way... Today I learnt new tricks in pivot table...Thank you Sir...😀🙏

@christopherstich1009 2 жыл бұрын

I’ve been diving into measures in Power BI, but I had no idea they were available inside of pivot tables. Tip #5 will change the way I work!

@chandoo_ 2 жыл бұрын

YES!!! Power Pivot in Excel opens a whole other world of possibilities.

@abhishekshukla9866 Жыл бұрын

glad to have landed on to this page

@ChasingCapella Жыл бұрын

Great tips, thanks for sharing.

@harishpoalampalli9637 2 жыл бұрын

Incredible chandoo !! you are awesome !!

@chandoo_ Жыл бұрын

Thank you so much 😀

@kamransiddiqui2091 Жыл бұрын

I love your videos. The videos played a vital role in excelling my skills. Some time ago I watched a short duration refresher video some where it says Exam or Test. Could you share the path or upload it again. Regards always

@kiraal3619 Жыл бұрын

Very informative!!

@FirestormT 2 жыл бұрын

Awesome as always

@pgkannan 2 жыл бұрын

Excellent. Thank you ❤️

@emoneheart436 2 жыл бұрын

Wow! Thank you Very much Sir! You made my Day ❤️❤️❤️❤️

@PainfullySubjective 2 ай бұрын

awesome. learned something new

@jackeroo75 2 жыл бұрын

Love you video editing skills!

@quills9900 2 жыл бұрын

Thanks Chandoo Gaaru ... This is fantastic , so easily explained. I had about 10 sheets (each 100 of records) with separate tables , I could manage to apply this data modelling and relationships to generate summarized reports to make few critical decisions on purchasing... thanks a lot again..

@chandoo_ 2 жыл бұрын

That is AWESOME 😎

@elfridhasman4181 Жыл бұрын

Love it, thank you ❤️

@richaagrawal376 2 жыл бұрын

I love this channel!! Thanks chandoo!! I am starting my sql journey. Can u plz share some good resources for learning sql.

@sakeobulesu7130 Жыл бұрын

Awesome tips chandoo garu 🙏🙏

@AVNISHS1981 Жыл бұрын

Superb bro...Useful... thanks..

@karimallahwala7022 2 жыл бұрын

Thank very much, very helpful informations

@sendianelake7144 Жыл бұрын

Awsome ! God bless you bro

@nirmalabolar1382 2 жыл бұрын

Thank you for your valuable input explained so beautifully and very to understand, will help so many of us.

@chandoo_ 2 жыл бұрын

You are always welcome Nirmala...

@dhikeshmm620 Жыл бұрын

Your videos are awesome, I learned so many things than any course which I done previously....still want to know how to arrange the pivot table out put layout...

@mvanvelsen 2 жыл бұрын

This was really great - tip 5 is something I really struggled to find.

@chandoo_ 2 жыл бұрын

Glad you found this helpful. More power to you Maarten ⚡⚡⚡

@sivareddy3745 Жыл бұрын

Thanks chandoo Anna.

@meghanadighe6421 2 жыл бұрын

Very nice tips thanks 👍

@mitchielicious1212 2 жыл бұрын

How i wish i have known your channel before. How i wish i could hit like on all of your videos in just 1 click. All your videos are very helpful. Thank you so much

@krupanarvekar Жыл бұрын

Thank u so much sir 🙏🙏🙏 god blessed you ❤️

@rajeswararaosimma7976 2 жыл бұрын

Thanks for valuable class. Could you please explain that auto generation of individual list of things based on one market in one pivot table

@ksumar Жыл бұрын

Nice work Chandoo.💯. 😊 Wishing you a pleasant weekend 🏡.

@sivakumarannam 2 жыл бұрын

🙏🏽Guru

@tutsecret499 Жыл бұрын

Excellent!

@karenholden5740 Жыл бұрын

i admit 5th mistake... This is very informative. Thank you..

@vargheseantony5677 Жыл бұрын

Thank You ❤️

@eryabolonha 2 жыл бұрын

Amazing ❤️ Thank you

@mohammadalbizri2013 2 жыл бұрын

Highly appreciated...

@ATInstitute 2 жыл бұрын

Woahh.............. this is superb

@ank1209 2 жыл бұрын

Very informative video! This data model relationship will work if we have data in different sheets?

@vikastaneja7923 Жыл бұрын

Great video. 👌

@leosaghathan2895 Жыл бұрын

Thank you so much bro

@sreenivasaraopanchireddi168 2 жыл бұрын

Outstanding Bro, i loved it :)

@tregoaleid7684 Жыл бұрын

Good stuff!

@tunbakyu 2 жыл бұрын

New sub from Myanmar .. love Ur contents

@shriram8088 2 жыл бұрын

Thanks chandoo for this video💖.These mistakes we do everyday. 😀Thanks for correcting us. Chandoo i missed your live session on automation in excel. That was so important for me. How can I get that video.

@canirmalchoudhary8173 2 жыл бұрын

I learnt Power Pivot thru this video. 💪

@PremKumar-rf3mo Жыл бұрын

Power query data model... My favorite. Thanks You So Much for your kind explanation... Anyway I'm so enjoyed your video.... And today I'm get what I'm looking for... Yes editing in pivot tables.. variance column... Hehe

@RajaBabu-qj3gn 2 жыл бұрын

Tum bht mast kaam karta hai chandoo Bhai..Lots of Love from India

@chandoo_ 2 жыл бұрын

Thanks you Raja ji.. :)

@tajumir48 Жыл бұрын

Wow that is sick ❤❤❤❤

@arbazahmad7177 2 жыл бұрын

Always Awesome 👌

@mohammedehsan5533 Жыл бұрын

Hi Chandoo, I like your videos. You are a great instructor. Could you please tell me if there is any way I can put comment in the cells inside a pivot table. Thanks

@u87626 2 жыл бұрын

Thanks Chandoo a lot for sharing knowledge. I got a lot from your videos as I have an interest in Excel but I am also stuck with Microsoft's application i.e, Access. I am also interested in learning that application. So can you also help me or guide me to learn this one. Thank you.

@s_bottlerocketfirecracker8828 2 жыл бұрын

“Hi , I think you’re making your pivot tables wrong” - this man knows me; he should be my therapist …

@chandoo_ 2 жыл бұрын

😂

@sjallmyfandoms9044 2 жыл бұрын

🤣 right?!

@himajadeevi1466 2 жыл бұрын

Hi Sir, could you please guide in how to connect jira with power bi using rest api and without any usage of plug-ins... that would be of great help..

@Roy-oo5pk 2 жыл бұрын

Thanks!

@chandoo_ 2 жыл бұрын

Thank you Roy for the SUPER 😍

@MrLucek73 Жыл бұрын

YOU ARE THE BEST

@Pawar154 2 жыл бұрын

Very helpful video sir. Plz suggest do we have to have a good knowledge of excel before jumping into power BI

@chandoo_ 2 жыл бұрын

Hi Jyoti.. You don't always need Excel skills to use or work in Power BI. I made a video comparing both skills for data people. Watch it here - kzfaq.info/get/bejne/pLWHrdN7mc25e6M.html

@mahmoudmohsen8105 Жыл бұрын

Just wholesome!

@user-iz3tx3jo3v Жыл бұрын

Hi, love your videos so much, they have a lot of usefull tips. I have a question. Maybe you can clarify, why in the example with staff, after refreshing you must have 259 employes but pivot table shows 255?