Create Pivot Tables In Excel | Use of Pivot Table

Create Pivot Tables In Excel | Use of Pivot Table - Pivot Table Tutorial

Рет қаралды 155,952

Күн бұрын

In this video, will learn about pivot tables in Excel. What is a pivot table, what is the use of a pivot table, how to use a pivot table and advanced functions or options in a pivot table.
We have taken a sample data to create a pivot table i.e pivot table example to help you understand the topic in a better way.
Topic: Create Pivot Tables In Excel | Use of Pivot Table - Pivot Table Tutorial
Pivot Practice Data (download link): bit.ly/3BbEyRJ
Timestamp:
0:00 Intro: pivot table & use
0:33 Pivot use case
1:09 Create pivot table
8:14 Advance pivot
Key keywords: what is pivot table, how to use pivot table, pivot table excel tutorial, create pivot table in excel, pivot table in hindi, free online excel course
➖➖➖➖➖➖➖➖➖➖➖➖➖
Instagram id: rishabhnmishra
Linkedin: / rishabhnmishra
Twitter - / rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
If you like this video I highly suggest you to check out some other fun videos on this channel 😉
■ How to Become Data Analyst in 2022 | Data Analyst Roadmap
• How to Become Data Ana...
■ Microsoft Excel Tutorial for Beginners - FREE Online Excel Course | Excel Tutorial Part 1
• Microsoft Excel Tutori...
■ Microsoft Excel Tutorial for Beginners - FREE Online Excel Course | Excel Tutorial Part 2
• Microsoft Excel Tutori...
➖➖➖➖➖➖➖➖➖➖➖➖➖
Comment your doubts and queries, so that we can answer them.
SUBSCRIBE to stay tuned to more fun and informative content, consider hitting LIKE button on this video for the sake of KZfaq Algorithm!! Have a great day!
#pivottable #PivotTableTutorial #exceltutorial

Пікірлер: 110

@dhanashrichougule7002 6 ай бұрын

Very helpful for beginner especially who all are coming from non IT background

@RishabhMishraOfficial 6 ай бұрын

Glad you liked it ✅️

@danishshaikh8295 24 күн бұрын

ms-excel not only for IT industry but also for all industry especially for data & numerical data

@kinjalmakwana2749 10 ай бұрын

I am a Fresher truly enjoyed your teaching skills .Thank you so much for the video.

@RishabhMishraOfficial 10 ай бұрын

Glad you liked it ✅️

@tyson5518ify 5 ай бұрын

Thanks sir for such informative it has been a great help

@MoNiKa-29-RN Жыл бұрын

very useful video. thanks

@paravjain8139 4 күн бұрын

Just amazing brother u r giving wonderful knowledge in such a easy way thnks a lott

@AjaySharma-tv6qz Жыл бұрын

Greate Rishabh Bhai aapne sab doubt Clear kardeye thanks bhai very helpful vedio Jio Bhagwani ji aapke ammi ku kush or safe rakhe

@guddikilifestyle5542 6 ай бұрын

Lots of love to you sir..... thank u sir

@Rich10MnFc 9 ай бұрын

Excellent 🎉

@AmitKumar-pz7tu Ай бұрын

Thank you so much for creating this video it helps a lot.

@happymoji5817 2 ай бұрын

Very well explained sir ji

@prashantrokka4057 Ай бұрын

Thank you, brother.

@ihgamingfun6295 Жыл бұрын

Thanks a lot👍🏼👍🏼👈

@theshort.101 4 ай бұрын

❤❤ nice video bro ✨

@shubhamanand2983 2 жыл бұрын

Quite helpful for beginners

@RishabhMishraOfficial 2 жыл бұрын

Thank you bhai 😃

@shabbirbagawan7013 3 ай бұрын

Thank You Sir

@ayushsingla5140 12 күн бұрын

Well Explained!

@ankitlakshcar-z2g 10 ай бұрын

truly enjoyed your teaching skills .Thank for the video.

@RishabhMishraOfficial 10 ай бұрын

Glad you liked ✅️

@the_spin_guy338 Ай бұрын

Very helpful sir

@parthsoni1847 3 ай бұрын

Thanks for improving my Excel knowledge ❤️

@RishabhMishraOfficial 3 ай бұрын

Happy to help! ✅️

@anilani9331 2 жыл бұрын

Super bro

@sadamhussain-rm2lw 12 күн бұрын

Thank you so much for your effort 😊

@janniferroy9807 9 ай бұрын

I am really enjoying the videos, all the concepts are really clear

@RishabhMishraOfficial 9 ай бұрын

Glad it was helpful ✅️

@sankalansen8146 2 ай бұрын

ThankYou

@snehalgajbhiye1454 29 күн бұрын

Amazing explaination I belong to non technical field..but its quite easy now after watching ur videos..Thank u so much😊

@RishabhMishraOfficial 28 күн бұрын

Glad you liked ✅️

@fitmediafactory 5 ай бұрын

Ty❤

@MyGovQuiz 2 жыл бұрын

Too much good... I Subscribed Your Channel.👍

@RishabhMishraOfficial 2 жыл бұрын

Thanks for the sub! 😃

@mrinalmondal1890 Жыл бұрын

If you think any further excel learning/ concepts are required for data analyst then add it in your Excel playlist.

@12krati 5 ай бұрын

Very nicely explained. Thank you

@RishabhMishraOfficial 5 ай бұрын

Glad you liked it ✅️

@meghangowdajs9441 Жыл бұрын

VERY INFORMATIVE VIDEO

@RishabhMishraOfficial Жыл бұрын

Glad you liked ✅️

@nidhiyadav6212 6 ай бұрын

Very helpful video thank you sir.

@RishabhMishraOfficial 6 ай бұрын

Happy to help ✅️

@Techinfokannada21 Жыл бұрын

very useful sir Thanks for making this series I have following your analysis road map

@RishabhMishraOfficial Жыл бұрын

All the best 👍

@Techinfokannada21 Жыл бұрын

@@RishabhMishraOfficial tq sir

@visitcmmubeenyt5087 Жыл бұрын

amazing information h sir

@RishabhMishraOfficial Жыл бұрын

Glad you liked it ✅️

@bharatkothari7396 8 ай бұрын

Very helpfull for fresher your teaching skill is Awesome sir

@RishabhMishraOfficial 8 ай бұрын

Glad it was helpful ✅️

@mohammadadnanhayat8343 Жыл бұрын

Thank you so much...

@RishabhMishraOfficial Жыл бұрын

Glad you liked it ✅️

@mkmarkam3902 5 ай бұрын

Very very helpful video sir ji 🙏

@RishabhMishraOfficial 5 ай бұрын

Glad it's helpful ✅️

@mandharsm9915 3 ай бұрын

Explained very well👍

@RishabhMishraOfficial 3 ай бұрын

Glad you liked it ✅️

@shekharkumar4659 3 ай бұрын

Thanku sir, it helped me a lot before my interview

@RishabhMishraOfficial 3 ай бұрын

Glad it was helpful ✅️

@syedabdulmuneem6976 2 ай бұрын

🙂 just I like one information between explanation as generally Females are leading in studies, but most of Famous scientist was Male Ex.Albert Einstein and many more.., but in general i accept your statement. Very Nice explanation and really appreciated the way you explain is easy to understand in our Language.

@RishabhMishraOfficial 2 ай бұрын

Glad you liked it

@Sbk_Tech Жыл бұрын

👍👍

@skilledguy1605 Жыл бұрын

Lots of respect and appreciation from Pakistan

@RishabhMishraOfficial Жыл бұрын

Glad you liked it ✅️

@kgbbsm005 7 ай бұрын

Nice sir good material

@RishabhMishraOfficial 7 ай бұрын

Glad you liked it ✅️

@anuragsinghchoudhary Ай бұрын

thanks a lot sir

@RishabhMishraOfficial Ай бұрын

Most welcome

@vijaykumarboylapalli7703 5 ай бұрын

very good sir

@amrutabalekundri9745 9 ай бұрын

Thank you 🙌

@RishabhMishraOfficial 9 ай бұрын

Happy to help ✅️

@bhawanathakwani4834 4 ай бұрын

Very helpful 😃

@RishabhMishraOfficial 4 ай бұрын

Glad it was helpful! ✅️

@occasionevent 8 ай бұрын

I watched your playlist all Excel Tutorial video so your all content are enough for work in Medical Industry?

@user-vs2em9xe7v Ай бұрын

👍

@PankajKumar-bb6ys Ай бұрын

Sir please help me in my pivot table redundant data is getting ignored which I do not want since it is a financial transaction. How to solve it ?

@sujit2199 2 ай бұрын

Sir i am requesting you, Please make this video " How to analysis the data without using pivot ".

@khushboobaghel6379 Жыл бұрын

blank row is created after create a pivot table. How to remove that?

@rutikdige9896 Ай бұрын

Plz make a video how to collate the 2 sheets

@visitcmmubeenyt5087 Жыл бұрын

Sir create a complete course on pivot table which help data analysts to analyze data.

@RishabhMishraOfficial Жыл бұрын

Okayy noted ✅️

@divyanshuranjan6984 2 ай бұрын

Thankyou Rishabh bhai ! means a lot

@RishabhMishraOfficial 2 ай бұрын

Glad you liked it ✅️

@mrinalmondal1890 Жыл бұрын

Please provide us the dataset also to practice. If possible provide multiple dataset to practice these concepts

@RishabhMishraOfficial Жыл бұрын

Okayy noted ✅️

@CricketFanClubvm1wy 8 ай бұрын

Hello sir , Sir actually mere data separate colum mei nhi aa raha hai and aapko jese house name show ho raha hai mera nhi ho raha hai

@prajjwalsharma7895 6 ай бұрын

hey bro, same happening with me. did you find the hack how to fix this??????

@bhoomika2002 Жыл бұрын

In interview what kind of questions can we expect ?

@RishabhMishraOfficial Жыл бұрын

mostly on advance excel: pivot, functions n vba

@jiaulsk3744 Жыл бұрын

sir pivot table me ek hi field ko dobara use kar sakte he keya, ek bar sum karne ke liye dusra bar count karne ke liya

@RishabhMishraOfficial Жыл бұрын

Hi Jiaul, same field ko do bar (2 times) drag and drop karo under - Values

@jiaulsk3744 Жыл бұрын

@@RishabhMishraOfficial ok, let's try it and thanks for reply. And I have one more question 2 cell do alag alag number he tisra cell me multiple karna he agar multiple 0 ho to 0 naahi blank dikhna chahiye, kaise kare

@RishabhMishraOfficial Жыл бұрын

@@jiaulsk3744 You can try Find and Replace function

@jiaulsk3744 Жыл бұрын

@@RishabhMishraOfficial but it's not work instant at first doing multiple then find & replace, I think it's not a proper way.

@theuzairalam Жыл бұрын

Rishabh bhai konsa version use krte ho AAP m 2010 m practice krra hu to pivot table m filter wala part nahi Mila aese hi slicer ko use krne m issue aya

@RishabhMishraOfficial Жыл бұрын

2013 excel

@visitcmmubeenyt5087 Жыл бұрын

lekin aik full course bna dain pivot table pr jo data analysts k lia helpful ho, Thanks in advance sir.

@RishabhMishraOfficial Жыл бұрын

Okayy noted ✅️

@divyadivakaran5679 10 ай бұрын

Sir please create a video for power query and power pivot

@RishabhMishraOfficial 10 ай бұрын

Okayy noted ✅️

@Thecartoonist_ 2 ай бұрын

Sir please answer my one question -------> is data structures and algorithms asked in data analyst interview from freshers????? As a fresher Should I learn data structures and algorithms also for interview????

@ritikdeshmukh7552 19 күн бұрын