Pivot Table Excel in 28 Minutes - Pivot Table Excel in Hindi
In this tutorial, we will learn about in-depth tricks of Excel Pivot Table in 30 minutes for Beginners to Advanced users. Learn everything about Excel Pivot Table in 30 minutes.
Check out our 21 hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
We Covered the following topics:
00:11 Introduction Pivot Table in Excel
00:17 Pivot Table Basics to Advanced Tricks
00:44 Pre-requisite - Data Set Format, Headings
01:24 How to Create Pivot Table
01:46 Why activate Classic Layout?
02:51 Understanding the 4 Layouts
04:21 Mathematical Calculations in Pivot Table
06:30 Pivot Chart using F11
07:04 Grouping (Numbers) in Pivot Table
08:54 Drill-Down in Pivot Table
09:20 Pivot Table Setting: Fill empty cells with 0
10:21 Grouping (Dates) in Pivot Table
11:24 Pivot Table Setting: Show Items with No Data
12:00 How to use Filter in Pivot Table
13:45 How to Move & Rename Headings in Pivot Table
14:39 Grouping (Text) Pivot Table
15:49 Slicers & related Pivot Table Settings
17:15 How to use Timeline in Pivot Table
18:17 Applying Basic Conditional Formatting
18:34 Pivot Table Design & Formatting
20:07 Subtotals in Pivot Table
20:32 Expand Collapse
21:13 Pivot Table Setting: Report Layout
21:43 How to Refresh & Change Data Source in Pivot Table
23:49 Pivot Table Setting: Disable Autofit Column widths
24:28 Creating 100s of Pivot Table reports in less than 1m
26:20 Pivot Table Setting: Disable =GETPIVOTDATA() for formula writing
Check out our 19 hrs. Full Excel Course in Hindi - bit.ly/3hGGsPg
MS Excel - Pivot Table (A-Z) | Pivot Table Tutorials
#Excel #pivottable #excelinhindi
To watch more videos visit: www.excelsuperstar.org/
To Buy an Excel Course visit: www.courses.excelsuperstar.org/
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar
Пікірлер: 566
Check out our 19 hrs. Full Excel Course in Hindi - bit.ly/31UflrO
@ArifuddinMohammed
3 жыл бұрын
Not just 28 minutes every second I learned from you. Few of them I know before. Last trick is the main event. Now I can dominate my seniors in work. Don't think about the time duration I even watch Advertisement without skip only for your video because you don't give us entertainment you give us knowledge. Thank you
@nikhilmathur7265
2 жыл бұрын
Thank you bhai, it could save my career
@PawanSAINI-ng9fq
2 жыл бұрын
Sir can you please provide tally course basic to advanced 🙏🙏🙏
@tanveerdar13
2 жыл бұрын
Can you send the employee list file?
@mihirrpatel7770
2 жыл бұрын
00:00 Intro & Basic info 1:22 Insert Pivot table & its Layout 4:19 Select/Arrange data for pivot table 7:02 Making Groups ( Numbers ) 10:19 Grouping ( Dates ) & Drill down 13:45 Grouping ( Text ) & Rename/Move heading 15:22 Slicer & Timeline 18:00 Design/Formatting/Subtotal 21:45 Refresh & Change data source 23:49 Report Filter Pages
मैने पहले इतने बेहतरीन ढंग से पिवोट सिखाते नहीं देखा किसी के द्वारा, बहुत बहुत धन्यवाद Sir,
Never have I even seen any learning class being so comprehensive and organized ...blessing for every learner ..Thank you so much for this !!Hats off !!!!
apke pivot smjhane ka tarika bohot hi acha he or asani se samajh aane wala he mjhy jo doubt the pehle isme wo clear hogae thanks a lot
Only one thing in my mind - God bless you with good health and happiness in your life... without any tuition fee you are sharing your expertise... good learning experience with your explaination... Thanks alot!!
I've gone through many videos for the Pivot table this was honestly the best, clear and amazing explanation without any confusion.. Amazing work 😁👍
00:00 Intro & Basic info 1:22 Insert Pivot table & its Layout 4:19 Select/Arrange data for pivot table 7:02 Making Groups ( Numbers ) 10:19 Grouping ( Dates ) & Drill down 13:45 Grouping ( Text ) & Rename/Move heading 15:22 Slicer & Timeline 18:00 Design/Formatting/Subtotal 21:45 Refresh & Change data source 23:49 Report Filter Pages
@Shashankbaranwal
10 ай бұрын
🎉😊 Huge 😅Thaaaaaaaank
this is amazing sir...... today felt like i knew nothing abt pivot table..... thnku so much
Hey Rishabh, I was already a fan, but after watching this Video I respect you also, What a video, Holy grail.... Anyone using excel must watch this, shared it with all my friends in Finance, HR, Operations
kya baat hai ,maja aa gaya,video was very informative kahi or jaane ki jarurat hi nahi padi boss ,thanks bro.
Excellent 30 minutes compact learning ,Rishab Ji
بہت عمدہ، سمجھانے کا انداز پسند آیا، کئی ٹرکس مجھے معلوم نہیں تھے۔
Thank you so much for this upload 🙏
Gajab knowledge. Thank you
Bahut achchha laga. Very helpful video. Thanks
Amazing explanation in short span of time, excellent session so far i've viewed.
You are my favourite now. Thankyou!
Very well explained looking forward for more content like this on pivot table itself. THANKS ✌️
Thnx for creating thats kind of vedio's
best 26 minutes utilised today by me through your video.. thanks a lot..
You are a real teacher, the way you explain this in a few minutes I really want to Siluet to you sir. I have learned almost all the 26 steps same as ABC, Thank you very much for your dedication.
Hey hi, God bless you for your great work. You have a excellent knowledge and communication skills. Thank you so much from the bottom of my heart.
Very Important video and channel to learn MS Excel..Best Luck
I must say that you are a quintessential teacher with profound knowledge of excel and you know how to honor your instincts with teaching that to free of cost
Bahut bahut Dhanyavad aapko mere Dost. You have shown today a new direction in my understanding of PivotTable. Thanks for your patient and clear explanations. God bless you.
Maine KZread per bahut Sare channel Dekhe lekin sabse Achcha Excel ka Samjhane Ka Tarika Aapka Hai... Thanks
Great learning.
Best video in youtube. Sir mai mai Am ki taiyari kar raha hun jisme mujhe aapki video se bahut help milti hai .
Unbelievable. Bhai. The mystery of pivot explained so easily. 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻
Excellent Sir...Definitely it's helpful for me... Thank you for your valuable lesson
Excellent way of teaching.And the almighty God has given you nice voice.May God bless you Sir.
I have never seen Pivot table in such a format ........it's amazing
One of the best teachers ever seen. brother I m HR mgr, lost job, practising for intvw. u helped a lot.
The Best Excel Tutor. Sharp, Precise and sure.
@ExcelSuperstar
3 жыл бұрын
Wow, thanks!
Best explanation sir INDIA🇮🇳 Best Mentor
Very informative. Keep update the tricks in excel. Hats off to sharing.
Thank you so much for this video Lots of learning in short period of time Clear and cristel way to explain each points. Big thumps up to you 👍🏻
Awesome Sir, Video is a treasure of pivot table.
Dear Thanks a Lot to explain this one in detail in such a simple way.. now i could proudly say.. i know Pivot Tables.. Thanks buddy..
seriously sir you are the best. i have learnt a lot more deep knowledge from your video. i wish other youtubers could learn your style which is "seedhi baat no bakwaas" because i click these videos for knowledge and not for fun. God bless you and keep growing. I wish all the success to you and to your channel.
Zabardast Bhai, Weldon
Many much new things to know. Thank you so much for such a wonderful learning video. Now I may make my reports more easily and fastly.
Really awesome... Ur teaching style is crisp and to the point!! Kudos to your work
Sir! U have amazing knowledge. From Pakistan
what a great way of education!!
I loved the way of your teaching Rishabh Sir! Thank you
Kya bat hai Sir.. Cha gaye Aap..!!!
Thanks a lot for this video
thank you very much, very well explained in logical and methodical way........
Thank You, your way of explanation is very good.
yaar what a amazing, kamaaaal
@Excel superstar.. Such a clear explanations.. This is really informative and helpful.Keep it up Sir
Thanks a ton brother... It was worth every second... Thanks once again for your time and efforts.
great video. happy to see from Canada.
Excellent elaboration for easy way to understand pivot table...
Very easy and informative video. Thanks a lot !
So simple and easy to understand .... Thank you
Thank you so much sir, What a teaching method. absolutely superb.
Thanks sir , Great
Excellent sir... Single second is usefull
very nice Explanation. Your voice and communication skill is so pure. thank you for this video.
Very helpful this video to know more about pivot table 👍
Thank you so much sir for making us excel junior superstar.
It is very Professional and easily way of learning for every one.
Awesome brother. Crystal clear
Short, to the point and perfect and clear to understand tutorial. I have subscribed to your channel.
It could not get any better. Thank you
Very clear & tricky Lesson. Really great
Yes you're my fav teacher
You explained everything with such clarity. Loved the session and it was worth every second. Thank you.
Great. Thanks for the tricks 🙏
Excellent video and teaching style.
Now I could have learn the Advance pivot, otherwise basic video are only available on utube. Good job👍
Excellent Trick by Excel Superstar.
Very informative video for my office work. Thanks dear ❣️
Super Clear concept Thankyou Sir
Such really very helpful vedio..appriciate
Excellent 👌 ur way of teaching is fabulous
Excellent bro 👍
Superb Sir
from last couple of day, trying to learn povit table on you tube, at least today i found the right person, great man
Excellent sir Thanks for the detailed video 🙏
@ExcelSuperstar
2 жыл бұрын
Most welcome
Wow, great knowledge, thanku sir we keep learning from you sir
It's your wonderful learning pack, thanks
@ExcelSuperstar
3 жыл бұрын
Glad you enjoy it!
Briefly and concisely Explained the basic to Advanced about Pivot Tables
Thank you soo much brother Excellent Teaching of PIVOT Tables
Super. Very nicely explained. Keep up the good work. Loved the lesson. Thanks
Rishabh... Your last advice with regards to removing get pivot data option was very nice....
Thanks alot..👍❤️.. worth watching..
Amaging video and yes your work is appreciable
Honestly, This one of the best video about Pivot table learning.
@ExcelSuperstar
3 жыл бұрын
Glad you think so! Keep learning
Very much informative and detailed video.
explain in very plain language , one can easily understand. big thanks to u.
@ExcelSuperstar
2 жыл бұрын
Thanks and welcome
you're awesome with uniqueness
Your teaching level is defferent Super Sir
Thank you. So helpful.
Sir excellent thank you for your tricks
Great explanation sir🙏
Such wonderful learning. Salute
@ExcelSuperstar
2 жыл бұрын
Thanks a lot
Fantastic Thank you for sharing!!!