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

  Рет қаралды 94,860

Excel Tutorial

Excel Tutorial

Күн бұрын

Пікірлер: 95
@Excel_Tutorial
@Excel_Tutorial 6 ай бұрын
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
@indicageneralstudy3262
@indicageneralstudy3262 Жыл бұрын
Sir नमस्कार सर। मैं up से हूं adca कर रहा हूं आपके सभी वीडियो काफी हेल्पफुल रहते हैं। सर मैं आपसे निवेदन करता हूं कि एक वीडियो स्टॉक इन्वेंटरी का बना दीजिए चाहे भले ही कितनी लंबी वीडियो रहे। जिसमे stock in , stock out , net stock आदि रहे
@roydebasish1
@roydebasish1 Жыл бұрын
❤❤❤ EXTREMELY EXCELLENT, THANKS SATISH SIR & LEARN MORE PRO ❤❤❤
@virendrarami7606
@virendrarami7606 Жыл бұрын
Appko rubru milna hai me Ahmedabad me hu me rs.10 Dene ke liye ready hu
@virendrarami7606
@virendrarami7606 Жыл бұрын
Your videos are extra ordinary
@guptavikas9681
@guptavikas9681 4 ай бұрын
I’ve been waiting for a new video from you and here it is.
@Excel_Tutorial
@Excel_Tutorial 4 ай бұрын
Many many thanks 😀😀😀😀😀😀😀😀
@syedarshad3233
@syedarshad3233 9 ай бұрын
Thanks excellent knowledgeable video.. please keep posting and share your knowledge sir ji.....
@Excel_Tutorial
@Excel_Tutorial 9 ай бұрын
Keep watching
@SSPSFF19950
@SSPSFF19950 Жыл бұрын
Thank you sir details men batane ke liye
@happyworld3897
@happyworld3897 21 күн бұрын
Mujhe ek google shiit me 5 company ka data lakeni mujhe name waise company sheet me data add ho gyee
@utkarshsrivastava2336
@utkarshsrivastava2336 23 күн бұрын
Sir Jaise ek form hai use link karna 🔗 hai to jaise form bharo database me automatic update ho jaye to use kaise hoga Sir ? Please Sir espe video banaye
@waqasentertainment933
@waqasentertainment933 Жыл бұрын
I am from Pakistan Sir you are a genius God bless you 💖
@Excel_Tutorial
@Excel_Tutorial 7 ай бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)
@bhupendragupta8809
@bhupendragupta8809 6 ай бұрын
Sir very interesting teaching
@janjua1024
@janjua1024 Жыл бұрын
Plz make a video, upon forecast dates, a complet project plan for implementation s
@abhilashachauhan5625
@abhilashachauhan5625 Жыл бұрын
Thank You sir
@munirajur5388
@munirajur5388 Жыл бұрын
Multiple rows for same person Mail merge. Like payment remittance 50 invoice payment to 3 supplier.
@KhanSaheb-k3z
@KhanSaheb-k3z Ай бұрын
Sir, ismai sales values same na ho toh work karega kya.,.?
@iftekharahmed807
@iftekharahmed807 7 ай бұрын
Xlent presentation
@pratapkeshavpawar9689
@pratapkeshavpawar9689 11 ай бұрын
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
@santoshkongari6820
@santoshkongari6820 9 ай бұрын
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.
@nileshdavane5038
@nileshdavane5038 8 ай бұрын
Thank you so much 😊
@Excel_Tutorial
@Excel_Tutorial 8 ай бұрын
You're welcome 😊
@Amazo-k3u
@Amazo-k3u Жыл бұрын
please make a detailed lenghty video on power query
@rlkgamer5004
@rlkgamer5004 Жыл бұрын
Nice sir
@bairaGi_AkB
@bairaGi_AkB Жыл бұрын
You are great sir, your teaching style is very good, thank you sir very much
@s.kindian3118
@s.kindian3118 Жыл бұрын
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
@exceltips305
@exceltips305 Жыл бұрын
Very good video
@saifuddinansari7514
@saifuddinansari7514 Жыл бұрын
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.
@jstips3558
@jstips3558 Жыл бұрын
Hii sir mere pass two workbook me data h or third workbook par pivot table lagana hai Please make v video
@JavedIqbal-eo1mc
@JavedIqbal-eo1mc 4 ай бұрын
Thanks
@Excel_Tutorial
@Excel_Tutorial 4 ай бұрын
You are most welcome 😉😉😉😉😉😉😉
@bhaveshdongare7606
@bhaveshdongare7606 Жыл бұрын
Nice video sir ji
@Excel_Tutorial
@Excel_Tutorial 7 ай бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)
@samuelnavinkumar
@samuelnavinkumar 10 ай бұрын
Hai sir how to separate multiple senteces in one single cell to multiple rows in excell
@sanjugalande
@sanjugalande Жыл бұрын
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
@jstips3558
@jstips3558 Жыл бұрын
Thanks very much sir ❤
@Excel_Tutorial
@Excel_Tutorial 7 ай бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)
@AjaySharma-jw1jp
@AjaySharma-jw1jp 4 ай бұрын
Hi sir koi company data base pr mis reporting ke according koi video dalo or ak dashboard kise bnate h numerical value me please sir
@waqasentertainment933
@waqasentertainment933 Жыл бұрын
Satish sir great 👍
@Excel_Tutorial
@Excel_Tutorial 7 ай бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)
@shaayri4you
@shaayri4you 5 ай бұрын
Sir, If I have data in around 8 Lakh rows in each sheets of a file...then also it will work or not?
@rajaarushi2090
@rajaarushi2090 5 ай бұрын
Close & Load to grey ho gya, Click not enabled
@samratsharma
@samratsharma Жыл бұрын
Sir itena late video mat dolo please mai wait kr rha tha sir
@pradhancreativity1617
@pradhancreativity1617 Жыл бұрын
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
@somyashrivastava6419
@somyashrivastava6419 4 ай бұрын
Sir aap jo sikhate hai mjhe wo practice karna hai lekin ere pass data nhi hai? Please help sir kese karu
@sayediftekharraheman6324
@sayediftekharraheman6324 Жыл бұрын
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."
@HIMANSHUVERMA-br3uy
@HIMANSHUVERMA-br3uy 9 ай бұрын
Practise ke liye excel ka link bhi de dete sir jo apne bataya usko practically bhi kr lete aur help.ho jate
@sarims197
@sarims197 Жыл бұрын
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
@charulatanijai9485
@charulatanijai9485 7 ай бұрын
Wonderful
@Excel_Tutorial
@Excel_Tutorial 5 ай бұрын
Thank you! Cheers! 😎
@Maheshdubey167
@Maheshdubey167 Жыл бұрын
Great video 🙏
@Excel_Tutorial
@Excel_Tutorial 7 ай бұрын
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(kzbin.info/www/bejne/m5DPk2N8eKaNaJY)
@AamirAli-m8v
@AamirAli-m8v 15 күн бұрын
Close and load button work hi nai kr rha
@kailaschavan6342
@kailaschavan6342 Жыл бұрын
Thank you sir तसेच आपण मल्टीपल शीट वरुन एकाच शीट वर vlookup फॉर्म्युला तयार करू शकतो का जर असेल तसे तर कृपया तसा video बनवा
@pravinsaundalkar7208
@pravinsaundalkar7208 7 ай бұрын
Sir 2 alag file se 1 pivot table banega kya
@RiyaSingh-z2m5z
@RiyaSingh-z2m5z 10 ай бұрын
AP Jo bol rha hai sir qty a amount change hoga to same data nhi hoga to count nhi hoga sir
@monisali_official_30
@monisali_official_30 Жыл бұрын
Please make a video for SSC COMPETITIVE EXAMINATION Ms Office 365 MCQS shortcuts key
@nirmalraj25
@nirmalraj25 Жыл бұрын
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?
@rupakdutta8539
@rupakdutta8539 11 ай бұрын
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.
@lalooanant
@lalooanant 5 ай бұрын
Sir 2 एक्सएल शीट का pivot table बनाकर दोनों pivot Table में ग्राम पंचायत के Data entry कितना हुवा है और कितना बाकि है इस तरह का कोई वीडियो बनाइये .....
@shivii88
@shivii88 Жыл бұрын
Sir live class ki timing accha nhi h afternoon ki. Rakho
@jahidulislamshamim7549
@jahidulislamshamim7549 10 ай бұрын
I want to learn Excel from you. How can i admit?
@cultureandtourism7559
@cultureandtourism7559 Жыл бұрын
Lovev u sir
@Excel_Tutorial
@Excel_Tutorial 7 ай бұрын
Keep watching the new videos I am uploading.(kzbin.info/www/bejne/aZLEn4SejMqIitE)
@sarju3399
@sarju3399 7 ай бұрын
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 6 ай бұрын
Use macros
@tetsuyakuroko2620
@tetsuyakuroko2620 Жыл бұрын
Kisi sheet se data lena ho, lekin formula ho toh kaise pivot banaye...
@SikandarAli-cv7ro
@SikandarAli-cv7ro 11 ай бұрын
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 9 ай бұрын
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
@deviprasadp8703
@deviprasadp8703 Жыл бұрын
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 Жыл бұрын
Sure I have started updating all the content now and already I have added DAX in Power BI
@deviprasadp8703
@deviprasadp8703 Жыл бұрын
@@Excel_Tutorial I'm a huge fan of you Sir, please don't mind Sir.
@philp784
@philp784 4 ай бұрын
🎉
@shantiprasadkukreti
@shantiprasadkukreti 11 ай бұрын
ITEM CODE KE SATH PIVO TABLE KASE KARE
@sumitshaw565
@sumitshaw565 Жыл бұрын
Different different excel sheet mein pivot table bana ho toh
@baigazam1284
@baigazam1284 9 ай бұрын
سیل کی ٹایپینگ نہیں ہو رہی ہے ۔ کیا کام کیا جاۓ؟
@Excel_Tutorial
@Excel_Tutorial 9 ай бұрын
Aapka question samaj nahi aaya.
@rakeshdas5228
@rakeshdas5228 Жыл бұрын
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 Жыл бұрын
Jatan Shah fraud hai mujhe bhi chuna lagaya tha
@MegaPawan420
@MegaPawan420 10 ай бұрын
Mere pass 9 lakh ki 4 sheet hai kaise ek pivot banau sabka Sabke column name same hai
@allinonenews8627
@allinonenews8627 11 ай бұрын
👍😊
@Excel_Tutorial
@Excel_Tutorial 8 ай бұрын
Keep watching
@hiteshchourey9730
@hiteshchourey9730 Жыл бұрын
Sirji, trick best hai.
@darshitchavda8264
@darshitchavda8264 Жыл бұрын
Awesome Sirjee.... & I have a query can you please give me your cell.. please
@pushkartiwari5942
@pushkartiwari5942 Жыл бұрын
Jay Shree Ram 💜💜💜🙏
@NanduruVenu
@NanduruVenu 3 ай бұрын
Matter se jyada bakwas hai
@Amanfathe
@Amanfathe Жыл бұрын
Thank you sir
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 30 МЛН
Why Excel Power Pivot is a Game-Changer for Data Analysis🔥
17:12
Satish Dhawale
Рет қаралды 183 М.
Double VLOOKUP: Solve Complex Excel Lookups Easily
19:25
Excel Tutorial
Рет қаралды 6 М.
Pivot table ko bhul jawo! Par kyun🤔?
20:14
Learn More
Рет қаралды 149 М.
Create Pivot Tables In Excel | Use of Pivot Table - Pivot Table Tutorial
12:01
How to use vlookup formula in excel? | Excel V-lookup formula in Hindi.
36:54