Тёмный

Every excel user Must know this excel trick - Create a pivot table on multiple sheets 

Excel Tutorial
Подписаться 286 тыс.
Просмотров 72 тыс.
50% 1

Every excel user Must know this excel trick - Create a pivot table on multiple sheets
AI Tools & ChatGPT with MS Office (100% Practical 2 Hours Live Webinar) : skillcourse.in/webinar-new/
Unlock the power of Excel with this must-know trick! Learn how to create a pivot table across multiple sheets effortlessly. Streamline your data analysis and reporting by consolidating information from different sheets into one dynamic pivot table. Boost your Excel skills and efficiency with this essential tip! Watch now and take your spreadsheet game to the next level.
Pivot table : • All about Excel Pivot ...
#exceltips
#DataAnalysis
#pivottables
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/learnmoreindia
------------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My RU-vid Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu

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

 

23 ноя 2023

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 77   
@SSPSFF19950
@SSPSFF19950 7 месяцев назад
Thank you sir details men batane ke liye
@iftekharahmed807
@iftekharahmed807 7 дней назад
Xlent presentation
@abhilashachauhan5625
@abhilashachauhan5625 7 месяцев назад
Thank You sir
@Amanfathe
@Amanfathe 7 месяцев назад
Thank you sir
@exceltips305
@exceltips305 7 месяцев назад
Very good video
@rlkgamer5004
@rlkgamer5004 7 месяцев назад
Nice sir
@charulatanijai9485
@charulatanijai9485 15 дней назад
Wonderful
@syedarshad3233
@syedarshad3233 3 месяца назад
Thanks excellent knowledgeable video.. please keep posting and share your knowledge sir ji.....
@Excel_Tutorial
@Excel_Tutorial 2 месяца назад
Keep watching
@nileshdavane5038
@nileshdavane5038 Месяц назад
Thank you so much 😊
@Excel_Tutorial
@Excel_Tutorial Месяц назад
You're welcome 😊
@user-jo4fj1kw9c
@user-jo4fj1kw9c 6 месяцев назад
please make a detailed lenghty video on power query
@jstips3558
@jstips3558 6 месяцев назад
Thanks very much sir ❤
@Excel_Tutorial
@Excel_Tutorial 21 день назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@samratsharma
@samratsharma 7 месяцев назад
Sir itena late video mat dolo please mai wait kr rha tha sir
@janjua1024
@janjua1024 6 месяцев назад
Plz make a video, upon forecast dates, a complet project plan for implementation s
@roydebasish1
@roydebasish1 7 месяцев назад
❤❤❤ EXTREMELY EXCELLENT, THANKS SATISH SIR & LEARN MORE PRO ❤❤❤
@virendrarami7606
@virendrarami7606 5 месяцев назад
Appko rubru milna hai me Ahmedabad me hu me rs.10 Dene ke liye ready hu
@virendrarami7606
@virendrarami7606 5 месяцев назад
Your videos are extra ordinary
@s.kindian3118
@s.kindian3118 6 месяцев назад
Very nice sir if multiple conditions per ak video bana diye jaise ki ak koyi hai jisme ham ye likhna chahte hai ki agar 0 se 30 me aye to wo hojaye 0 to 30 days, agar ye 30 se 60 tak hai to ye hojaye 30 to 60 days aise koyi condition per video bana diye main kafi dino se aap ka video dekhta hu or wo video dekh kar do bahot acha laga tha Jo wo sir the unka name to bhul gya hu but jinko unke company se nikalne Wale the or uske baad permosion hogya tha
@munirajur5388
@munirajur5388 6 месяцев назад
Multiple rows for same person Mail merge. Like payment remittance 50 invoice payment to 3 supplier.
@Kingpotash
@Kingpotash 7 месяцев назад
You are great sir, your teaching style is very good, thank you sir very much
@Maheshdubey167
@Maheshdubey167 7 месяцев назад
Great video 🙏
@Excel_Tutorial
@Excel_Tutorial 21 день назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@hiteshchourey9730
@hiteshchourey9730 7 месяцев назад
Sirji, trick best hai.
@santoshkongari6820
@santoshkongari6820 3 месяца назад
Sir looking for stock inventory video, in which daily material In and out to be done and balance I have to get on daily basis.
@Malkamoneclick
@Malkamoneclick 5 месяцев назад
U R a gd teacher
@Excel_Tutorial
@Excel_Tutorial 29 дней назад
It's my pleasure, Keep watching the new videos I am uploading.
@indicageneralstudy3262
@indicageneralstudy3262 7 месяцев назад
Sir नमस्कार सर। मैं up से हूं adca कर रहा हूं आपके सभी वीडियो काफी हेल्पफुल रहते हैं। सर मैं आपसे निवेदन करता हूं कि एक वीडियो स्टॉक इन्वेंटरी का बना दीजिए चाहे भले ही कितनी लंबी वीडियो रहे। जिसमे stock in , stock out , net stock आदि रहे
@monisali_official_30
@monisali_official_30 7 месяцев назад
Please make a video for SSC COMPETITIVE EXAMINATION Ms Office 365 MCQS shortcuts key
@waqasentertainment933
@waqasentertainment933 5 месяцев назад
I am from Pakistan Sir you are a genius God bless you 💖
@Excel_Tutorial
@Excel_Tutorial 23 дня назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@waqasentertainment933
@waqasentertainment933 5 месяцев назад
Satish sir great 👍
@Excel_Tutorial
@Excel_Tutorial 21 день назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@jstips3558
@jstips3558 6 месяцев назад
Hii sir mere pass two workbook me data h or third workbook par pivot table lagana hai Please make v video
@bhaveshdongare7606
@bhaveshdongare7606 6 месяцев назад
Nice video sir ji
@Excel_Tutorial
@Excel_Tutorial 21 день назад
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e_lb0FCAZ24.html)
@HIMANSHUVERMA-br3uy
@HIMANSHUVERMA-br3uy 2 месяца назад
Practise ke liye excel ka link bhi de dete sir jo apne bataya usko practically bhi kr lete aur help.ho jate
@allinonenews8627
@allinonenews8627 4 месяца назад
👍😊
@Excel_Tutorial
@Excel_Tutorial Месяц назад
Keep watching
@cultureandtourism7559
@cultureandtourism7559 7 месяцев назад
Lovev u sir
@Excel_Tutorial
@Excel_Tutorial 29 дней назад
Keep watching the new videos I am uploading.(ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-3aanQhWeUTo.html)
@pradhancreativity1617
@pradhancreativity1617 7 месяцев назад
Sumif ki tarah multiply if kar sakte hai kya Example I want to multiply b1*c1 whaen "CR" is available in a1 otherwise it blank
@samuelnavinkumar
@samuelnavinkumar 4 месяца назад
Hai sir how to separate multiple senteces in one single cell to multiple rows in excell
@pratapkeshavpawar9689
@pratapkeshavpawar9689 5 месяцев назад
On mobile will it be possible to provide this data readymade command = rand.from where we will find this data guide please 🙏 for to Know or else type will be the option?my PC is windows 7
@kailaschavan6342
@kailaschavan6342 7 месяцев назад
Thank you sir तसेच आपण मल्टीपल शीट वरुन एकाच शीट वर vlookup फॉर्म्युला तयार करू शकतो का जर असेल तसे तर कृपया तसा video बनवा
@nirmalraj25
@nirmalraj25 7 месяцев назад
Sir! Please Reply: Mere paas 6 Sheet hai. Orders, Products, Inventory, Discount, Sales and Region. Isme se Orders, Products, Inventory mein ek-ek common column hai. Baaki sab different, i meant no common column. Discount ka column bohot hi chota hai aur Horizontal mein data hai. (Question: Inn sabhi ka combined data kar ke mujhe pivot table ke zariye analyse karna hai, kese kare?) Please Please Please Please REPLY. Pareshaan hu. Calculated field bhi karni hai like AOV nikal ne hai. Percentage sab. Lekin combine kare kese?
@shivii88
@shivii88 7 месяцев назад
Sir live class ki timing accha nhi h afternoon ki. Rakho
@sayediftekharraheman6324
@sayediftekharraheman6324 7 месяцев назад
Sir normally ham excel me data type karte he to to wo upar se niche ko type karte he. But Mera question ye he ki "me chahta hoo agar Mera pehla row ka kaam khatam ho jae to wo cell automatically niche chala jae or upar ek or row create ho jae or jis row ka kaam hogaya wo niche chala jae. Agar ye possible hai to please sir mere ko thoda guide kardijiye. Kese hoga ye."
@sarims197
@sarims197 6 месяцев назад
MS Excel Quiz ? (10th Class Marksheet) Total 6 Subject hai Agar Student 1 ya 2 subject me fail hoga to wo student ka result pass hoga. Aur agar 3 subject ya usse jyada subject me fail hoga to wo student ka result fail hoga. Plz video banaye sir
@sanjugalande
@sanjugalande 5 месяцев назад
I had query I have 10 Excel files and each Excel file has 5 sheets can I pull specific sheet from alll 10 Excel file
@saifuddinansari7514
@saifuddinansari7514 6 месяцев назад
Sir mere papa life insurance advisor h or unke clients ki details mene excel ki multiple sheets me month wise maintain kri hui hai or ab mjhe ye janna hai ki is month me kiski policy due ho rhi hai to wo me kse kru? Please iske uper ek video bnaiye.
@jahidulislamshamim7549
@jahidulislamshamim7549 3 месяца назад
I want to learn Excel from you. How can i admit?
@user-dx9cl9mp9m
@user-dx9cl9mp9m 3 месяца назад
AP Jo bol rha hai sir qty a amount change hoga to same data nhi hoga to count nhi hoga sir
@pravinsaundalkar7208
@pravinsaundalkar7208 25 дней назад
Sir 2 alag file se 1 pivot table banega kya
@tetsuyakuroko2620
@tetsuyakuroko2620 7 месяцев назад
Kisi sheet se data lena ho, lekin formula ho toh kaise pivot banaye...
@rupakdutta8539
@rupakdutta8539 4 месяца назад
Excel pe photo insert link keise kare? Jaise name sunday, uspe click kiya to sunday ka photo dikhai de. Pdf pe photo link keise kare jeise moon name pe click kiya to moon ka tasbir aye.aur usko kisiko bhi sher karu to bo dekh sake. Aisa ajkal chal rarahe .keise karne hei.bataye to.
@shantiprasadkukreti
@shantiprasadkukreti 5 месяцев назад
ITEM CODE KE SATH PIVO TABLE KASE KARE
@sumitshaw565
@sumitshaw565 7 месяцев назад
Different different excel sheet mein pivot table bana ho toh
@deviprasadp8703
@deviprasadp8703 7 месяцев назад
Sir You didn't Explain M language in power query and Dax language in power bi in your app Could you please add and give some advance level technical skills support.
@Excel_Tutorial
@Excel_Tutorial 7 месяцев назад
Sure I have started updating all the content now and already I have added DAX in Power BI
@deviprasadp8703
@deviprasadp8703 7 месяцев назад
@@Excel_Tutorial I'm a huge fan of you Sir, please don't mind Sir.
@sarju3399
@sarju3399 9 дней назад
Roj Ek hi data pe Kam karte hai par roj hi pivot table banana padta hai to mujhe uska short kat tarika bataye ki roj pivot table na banana padega
@himanshuarora837
@himanshuarora837 4 дня назад
Use macros
@MegaPawan420
@MegaPawan420 3 месяца назад
Mere pass 9 lakh ki 4 sheet hai kaise ek pivot banau sabka Sabke column name same hai
@SikandarAli-cv7ro
@SikandarAli-cv7ro 4 месяца назад
Pivot table and chart ban janay k bad, data change krnay se, pivot table and chart me koi change ni ata, please guide me
@shushankmanhas
@shushankmanhas 2 месяца назад
Tumhe lagta hai ye chutio ki tricks kabi kaam aati hai Simplify your work as it can. Yeh sab tricks mai pdoge tou age complete ho jayei Excel ne kabi seekh paoge
@darshitchavda8264
@darshitchavda8264 7 месяцев назад
Awesome Sirjee.... & I have a query can you please give me your cell.. please
@rakeshdas5228
@rakeshdas5228 7 месяцев назад
Sir ab online course bharosaa kaise kare abhi 5day pahle webner 99 rs m join kya free m certification k saath Microsoft office 360 and ChatGPT 5 year Tak dengee free m bolaa agar unke cousins join kare toh mene 7000gst k saath 1st installment m payment kya thha but ab keh r h 2nd installment k baad h milegaa subscription, isliye dar yah k paisaa bekaar naa hojaye.Kya Aap Sir help karsakte h isme,Jatan Shah name se h Microsoft Certified trainer boltaa h,Fake vaale h ya Real pataa nahi chal p r
@User.313Alamgir
@User.313Alamgir 7 месяцев назад
Jatan Shah fraud hai mujhe bhi chuna lagaya tha
@baigazam1284
@baigazam1284 2 месяца назад
سیل کی ٹایپینگ نہیں ہو رہی ہے ۔ کیا کام کیا جاۓ؟
@Excel_Tutorial
@Excel_Tutorial 2 месяца назад
Aapka question samaj nahi aaya.
@pushkartiwari5942
@pushkartiwari5942 7 месяцев назад
Jay Shree Ram 💜💜💜🙏
Далее
DOTA 2 - КЛАССИКА
19:17
Просмотров 142 тыс.
Pivot table ko bhul jawo! Par kyun🤔?
20:14
Просмотров 136 тыс.