Тёмный

3 Hidden Pivot Table Option & Settings 🕵️ 

Excel Superstar
Подписаться 385 тыс.
Просмотров 18 тыс.
50% 1

Learn about Hidden Pivot Table Options and Settings in Excel. Check out our 23+ hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
We covered the following topics:
00:00 Introduction to Excel Pivot Table
00:26 How to use Custom List Sorting in Excel Pivot Table
02:27 How to use Show items with no data in Excel
03:29 How to use For empty cells show zero in Excel Pivot Table
Pivot Table Excel in 28 Minutes [Basic to Advanced]
• Pivot Table Excel in 2...
3 Hidden Pivot Table Option & Settings 🕵️
#Pivottable #hiddentricks #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

Опубликовано:

 

14 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 51   
@ExcelSuperstar
@ExcelSuperstar 2 года назад
*Register now for the Pivot Table Webinar* - bit.ly/3KPBiNq
@BouncewithLife_1
@BouncewithLife_1 Год назад
I was looking for that 3rd setting..Yah! Thanks Rishabh.
@pujakayastha2971
@pujakayastha2971 2 года назад
Nahi kuch naya sakhane ko mila thank you sir
@keshariprasad1992
@keshariprasad1992 7 месяцев назад
I know all these. Please make more videos on Power query . I have seen ur power query video which is very informative 👍 .
@dattatrayshirke3479
@dattatrayshirke3479 2 года назад
Second and third wala use Kiya tha, 1st wala new tha mere liye.🙏
@arvindk7561
@arvindk7561 2 года назад
Thanks rushabh sir
@pravinkumbhare1750
@pravinkumbhare1750 2 года назад
Useful tips for Pivot Table...
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Many many thanks
@ganeshugale3257
@ganeshugale3257 2 года назад
Real Excel Superstar 😎
@ExcelSuperstar
@ExcelSuperstar 2 года назад
No, Ganesh Ugale You're the Excel Superstar
@ganeshugale3257
@ganeshugale3257 2 года назад
@@ExcelSuperstar 🙏🙏🙏
@Cricketer-007
@Cricketer-007 2 года назад
Very good
@kuldeep.3012
@kuldeep.3012 2 года назад
Thank you sir ji....mujhe sirf 3rd trick pta thi zero lana blank cell par
@mamalik1088
@mamalik1088 2 года назад
Again nice explain
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Keep watching
@kaleem77
@kaleem77 2 года назад
Sir valuable information
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks and welcome
@asimshahzad5696
@asimshahzad5696 2 года назад
Thank you so much
@ExcelSuperstar
@ExcelSuperstar 2 года назад
You're most welcome
@waqasmasood6537
@waqasmasood6537 2 года назад
Great
@himanshuprasad5282
@himanshuprasad5282 2 года назад
Very useful
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Glad to hear that
@DineshSardesai
@DineshSardesai 2 года назад
great
@canirmalchoudhary8173
@canirmalchoudhary8173 2 года назад
Nice recap even after knowing. I accept that even after knowing I could not think of these settings.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Glad I could help!
@devangthakkar6847
@devangthakkar6847 2 года назад
Superb Sir - Very Very usefull trick for day to day works..... Once again thanks.....
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Always welcome Keep Watching
@rupeshsonker1
@rupeshsonker1 2 года назад
Yes
@pradeepjangid490
@pradeepjangid490 2 года назад
Excellent
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks
@pradeepjangid490
@pradeepjangid490 2 года назад
@@ExcelSuperstar sir 1 have 2 excel files First is only data input file which is linked to 2nd file. When I transferred to 1st file in other PC than 2nd files data automatically retrieved. But I didn't transferred 2nd file. How this is possible in Excel, that reference linked file automatically transferred to another pc.
@user-mj9zi4sf5k
@user-mj9zi4sf5k 9 месяцев назад
please share this excel file for practice
@saahilsaahil5912
@saahilsaahil5912 2 года назад
good one👍
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks ✌️
@ashukumar881
@ashukumar881 2 года назад
Sir sales data ko financial year wise short karna ho tab kaise kare iski bare me kuch bataye..???🙏🙏🙏
@vishalbhati912
@vishalbhati912 Год назад
Use custom sorting or move option with left click
@Amitkumar-uj8ip
@Amitkumar-uj8ip 2 года назад
Sir love from jharkhand and I wanted to know how we calculate median in pivot table please reply 🙏
@BKumar6677
@BKumar6677 2 года назад
🙌
@rkpugalia8305
@rkpugalia8305 2 года назад
आज आवाज की स्पीड अच्छी लगी।
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thank you
@gochhi7841
@gochhi7841 2 года назад
First viewer 🙏
@ExcelSuperstar
@ExcelSuperstar 2 года назад
😊
@sagar1991y
@sagar1991y 2 года назад
Hi Rishabhji, mai jab bhi pivot karta hu quarterly to wo data Jan to March 1 qtr dikhata hai use hum kaise financial year wise kar sakte hai
@ExcelSuperstar
@ExcelSuperstar 2 года назад
learn this trick in our upcoming webinar - www.excelsuperstar.org/excels-pivot-table-tricks-webinar/
@sunilkumar-jl7uf
@sunilkumar-jl7uf 2 года назад
After activate these settings, can we use these every time in our pivot table or will have to need activate again when required.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
In Office 365, go to OPTIONS > DATA > "Edit Default Layout" > Pivot table Options.
@bck4589
@bck4589 2 года назад
Sir, mai jab date ko pivot table me rakhti hu to sab date dikhata hai, lekin muze vo month ya fir year wise chahiye to aap batao kaise kare?
@asimshahzad5696
@asimshahzad5696 2 года назад
Aap date ko month ya year me group kr dein
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Watch this - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IIzLRnb5Udc.html
@sanjaydesai8263
@sanjaydesai8263 2 года назад
Sir valuable information
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks and welcome
Далее
Сколько метров чернил в ручке?
16:35
Boots on point 👢
00:24
Просмотров 2,5 млн
MS Excel: A to Z Logical Function | Excel in Hindi
12:36
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн