Pivot Table Multisheet | Microsoft Power Query | Combine sheets with Excel Power Query

[@jaitiwari241]

I never saw a teacher like u.. I will surely recommend this channel to everyone I know who wish to learn and pursue their career in data analyst and MIS

[@Innozant]

Thanks Jai for your appreciation.. Really means a lot to me..Have. A wonderful career ahead❤️🙏

[@Vitthalbedre34]

YES I'M ALSO

[@vikasgawaria5330]

Sir aap real teacher ho kyonki AAP har topic ko starting to ending Tak explain karte ho thankyou so much for this advance knowledge video

[@Innozant]

Thanks Vikas..Keep Learning ❤️

[@nitishcomradebhatt1838]

I am trying to learn excel for last 1 year and also purchased some online courses, but i could not get that confidence , sir last 2 months se aap ke video dekh ke mujhe maza aagaya now i able to create my complex formula. thanking u so much sir

[@Innozant]

Thanks..Keep learning..Keep exploring

[@ayanmallick2337]

Filhal mera system may ms office 2016 hai, or mayne apka video dekhkar practice vhi karli. Results bilkul sahi aya. Thank you "Sir"🙏

[@Innozant]

Thanks Ayan Ji..Happy learning ❤️

[@bnmishra7558]

U r one of the best teacher in the world god bless you

[@Innozant]

Really means a lot to me

[@heenajamal6334]

Sir really aap bahot hi achese choti si choti cheez samjhate ho......thank u so much sir

[@Innozant]

Thanks Heena..God bless you bacha ❤️👍

[@bhushankadam5632]

Excellent teaching sir... कितनी खूबसूरती और आसानी से पढ़ाते हो.. Great.. Thanks sir.

[@Innozant]

Thanks Bhushan Ji

[@sahilsreedharan]

Best Excel learning channel ever seen in KZbin . Great way of presentation and interactive approach towards knowledge seekers like me 🙏🙏❤️❤️ INNOZANT Sir..u r Great 🙏 har ek video dekhe tho lagtha hai ki ye video tho mere liye banaya hua hai.... just awsome.

[@Innozant]

Thanks Sahil for such a wonderful appreciation. Really means a lot to me ,Thanks for your love and support dear.Wishing You Wonderful career ahead.🙏♥️

[@kazisazzad9257]

Several of your tutorials are unique. There's so much to learn from you! The process of explaining things is very beautiful too! Great jobs. ❤️

[@Innozant]

Thanks Kazi sahab..happy learning 🙏❤️

[@anshuupadhyay1455]

Big fan Sir 💓 apki har video's se hamari problem solve ho jati he thank you sir...

[@Innozant]

Thanks Aashu..Hope Aapke ye videos Pasand. Aate hain aur aap inse seekhte Hain ♥️🙏

[@DKG-MIS]

No one can explain better than you Thanks a lot.

[@Innozant]

Thanks dear

[@truepearl9334]

Amazing things I am learning from your channel. India need teachers like you. Your youtube Student from Najafgarh Delhi.

[@Innozant]

Thanks dear.. God bless You dear

[@TheSuvankarKundu]

You're my true guru.... Thankyou so much.. I m so much excited to learn power query...and VBA..

[@Innozant]

Thanks Suvankar ,Happy Learning ♥️♥️

[@shrikantbadge3978]

This is the premium content. Nobody gives this for free. You're a pure philanthropist Sir.🙌🙌🙌

[@Innozant]

Yes Shrikant Ji..M planning to upload complete tutorial from beginner to expert level .. Completely FREE on KZbin Platform.Thats why m not going to sale Video Lecture😁👍♥️🙏

[@devendergusain8974]

@@Innozant THNAX SIR VERY MUCH LOVE U SIR

[@vijaysahal4556]

I enjoyed excelfun channel mr mike nd yours innozant both blog tq sir

[@Innozant]

Thanks Vijay❤️

[@ravisrivastava6722]

Aapka sabse best chij ha ki aap step by step batate ha or sath me ye bhi ki error aaye to kya krna ha best ha sir

[@Innozant]

Thanks Ravi ,Happy Learning.Step by step hi seekhna hai ,Life me aage badhiye yhi wish hai meri

[@ravisrivastava6722]

@@Innozant thank you sir

[@Altaf_Alam]

Sir Really Value added content..... I have understood relationship concept 🤩

[@Innozant]

Thanks Altaf

[@deepakkandpal2602]

thank you sir, the way you teach that is amazing. you rock sir i will recomand this channel to those people who realy want to learn.

[@Innozant]

Thanks Deepak...Have a wonderful career ahead

[@ranvir0392]

Sir, Hat's off to you............wah kya explanation hai..........you are best teacher........🙏👍👌

[@Innozant]

Thanks Ranvir ji..Happy learning dear❤🙏

[@ManjeetSingh-th4fu]

The way of teaching is amazing. Thanks a lot.

[@saddammalik5566]

Start From Superb ideas example...... thanks

[@Innozant]

Thanks Saddam ❤️👍

[@md.sumonkhandaker451]

Your teaching method is too good

[@Innozant]

❤️❤️ Thanks dear

[@kavita8390]

Your teaching skills are one of the best … you simplify difficult topics so well that learning actually did fun … hats off to you

[@Innozant]

Thanks Kavita ♥️👍

[@Jitenderkumar-yp1rn]

Excellent topic sir jii..... Practice ki jarurat hai isme.....😍😍❤❤

[@Innozant]

Haan Jitendra .. Practice is must 🙏

[@KuldeepSingh-nq1vi]

Really you are awesome teacher so far. Thank for in details explanation.

[@Innozant]

Thanks Kuldeep Ji..God bless You dear

[@aditiprakash531]

Your way of teaching is really awesome. thanks you so much sir

[@Innozant]

Thanks Aditi.. Really means a lot to me.We welcome you to experience the taste of Success with Innozant-Seed of Success

[@puransingh-sx2tk]

New series par sir ko badhai 🙏😊

[@Innozant]

🙂🙏♥️

[@sarveshdubey6909]

Thank you for your wonderful guidance and using very simple techniques. I just started the youtube video for fun today but got so excited to hear you that makes me to learn new things

[@Innozant]

Thanks Sarvesh ji for valuable appreciation..Keep learning..keep exploring ❤️

[@sagarsinghsolanki3546]

Arre aap to bde heavy teacher ho bhai 😎

[@Innozant]

Hahaha.Heavy Teacher😀😀ye kya hota hai Solanki sahab.

[@sagarsinghsolanki3546]

@@Innozant matlab bahut badhiya 👏

[@jaitiwari241]

You are master guru and savior

[@Innozant]

Thanks Jai.Hope these videos may add some value in your life❤️🙏

[@jaitiwari241]

@@Innozant 🙏🙏🙏

[@vinayvemul8456]

Sir your so great teacher for excel

[@satishojha6240]

Thanks sir aap se bahut umeed hai. 🙏🙏🙏

[@Innozant]

Thanks Satish Ji👍🙏❤️

[@situsahoo2482]

Sir aiye to hatke ho gaya.heavy data ko hum one pager mein kar lenge kuch minutes mein..I love ..❤️.innozant family.Thanks to ❤️dilip sir❤️

[@Innozant]

Situ Sahoo Ji .. Thanks dear...next video issse bhi Hatke aane wala hai🙏♥️❤️🙂

[@AnupKumar-oe2jb]

Thank you sir. Wah maza aa jata h video dekh kar. we always wait for your video

[@Innozant]

Thanks Anup Ji.. Happy Learn dear ..,That for your love and support 🙏♥️

[@deepakchauhan4974]

Great approach, executed this successfully,

[@Innozant]

Thanks Deepak.. Happy Learning ❤️🙏

[@forgotten_friend5406]

excellent teaching methods

[@tapankumardas8252]

You are really great Sir. Thanks for new series teaching

[@Innozant]

Thanks Tapan..Happy Learning 👍♥️🙏

[@Sanddystar17]

Salute sir.. for Excel advance knowledge 😊😊😊

[@Innozant]

Thanks Gupta Ji.. Practice bht jaruri hai. In topic Ka

[@Sanddystar17]

@@Innozant ji sir aapke sare file ko achhe se series me rakha hai practice bhi hoti hai

[@RahulChauhan-ll9pu]

Fantastic guru ji 👍🙏

[@Innozant]

Thanks Rahul Ji ❤️🙏

[@rangel9082]

Sir you are great ❤

[@E_K18]

Really helpful and amazing 👍🏻👍🏻thankyou!!! Homework Done 💝

[@Innozant]

Are Wah... Thanks ❤️👍🙏

[@karimsamnani3660]

Great explain & nice tutorial.

[@gauravgupta6458]

Sir thank you so much for making this video

[@Innozant]

Thanks Gaurav

[@devangthakkar6847]

Superb dear sir.....

[@user-ke2mk6qz9z]

Thank you for teaching sir it's very helpful to us.

[@Innozant]

Thanks Sudhish . Happy Learning dear.. Practice is must .ok👍👍♥️🙏

[@user-ke2mk6qz9z]

@@Innozant ☺️

[@jayantabhattacharyya628]

Dear Sir Awesome much awaited video. I am trying to do it both SQL and power pivot. Thanks Jayanta Bhattacharyya.

[@Innozant]

Thanks Jayanta , Happy Learning Hope this example help you a lot 🙏♥️

[@padmakarbadge8419]

Bahut bahut dhanyawad sir.

[@varshamahindrakar3811]

Thank you very must.. it was something new to learn

[@Innozant]

Thanks Varsha .Hope you like these videos and trying to enhance your skills on regular basis ..Happy Learning ♥️🙏

[@YashSharma-oe5bt]

Really this is very useful thanks a lot

[@Innozant]

Thanks Yash.. happy Learning 🙏❤️👍

[@AnupKumar-oe2jb]

I made the pivot table. thank you very much sir to make learn new something

[@Innozant]

Thanks Anup..Very good dear. Practice is must 🙏♥️

[@AnupKumar-oe2jb]

@@Innozant thank you Sir

[@jaitiwari241]

Wat a wonderful and detailed explanation

[@Innozant]

Thanks Jai ❤️🙏Happy Learning ❤️🙏

[@situsahoo2482]

Hum toh wait kiye hein aap google sheet ke bare mein.start karenge.🙏🙏❤️❤️

[@Innozant]

Wo bhi krenge series start

[@deepakkhurana5010]

Sir all excel series are awesome please start new series for SQL Thanku

[@Innozant]

Thanks Deepak...Akele Jaan hu Deepak Kitna Jaan lenge khudka.koi nhi aayega waqt ke Saath saare series .. complete aayega jo bhi series start krenge 👍❤️♥️🙏

[@deepakkhurana5010]

@@Innozant thanku sir & I'm waiting........

[@razamoulvi8801]

Can't wait for Power Query...🤩🤩

[@Innozant]

Happy Learning...♥️🙏How's todays Video🙂 Practice is must 🙏

[@razamoulvi8801]

@@Innozant Yes sir👍🏻👍🏻Great video ... Thanks for the video😊

[@amandeepbadgujjar7096]

Hello sir, I hope you happy and safe 🙏, sir you said in the end of the video that make pivot table by Power query, same as your steps, I wanna tell you, I made, as you said to make pivot table by Power query 😇😇

[@Innozant]

👍

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@Innozant]

Thanks Rahul

[@shubhamsoni8115]

great Job Sir

[@Innozant]

Thanks Shubham

[@shaileshkumar-qf6bd]

you are great sir

[@adamgamingshorts6502]

Really helpful sir.

[@rohitkeshri-1005]

Sir last wala sheet pivot name se Jo bnaya h wo blank h na? Aur kewal usi sheet ko copy krke paste kiye h c: drive me?

[@pardeeparya9986]

Thanks Sir, u r great.

[@Innozant]

Thanks Pradeep 🙏❤️

[@mohan8887]

Great vedio sir..

[@Innozant]

Thanks Mohan♥️🙏

[@kinghundred]

very useful sir

[@Innozant]

Thanks dear

[@bushrarashid5860]

thank you so much sir

[@shahzadsiddiqui5117]

bahut bahut important topic hai, mujhe poora playlist dekhna hai Power query

[@Innozant]

Playlist hai power query ka

[@twinklesharma9415]

Thank you so much sir

[@Innozant]

Thanks Twinkle,We welcome you to experience the taste of success with Innozant -Seee of success. Recommended you to start your learning journey from playlist Basic Excel (in sequence playlist link are available in video description with Complete assignment) Keep Learning...Keep Exploring 👍❤️

[@user-jc6te1vm8v]

amazing sir once again!

[@Innozant]

Thanks Anand🙏♥️

[@ishutiwari5567]

great sir 🙏

[@Innozant]

Thanks Ishu.. Happy Learning ♥️🙏

[@mohammadazam5729]

Thanks Brother

[@kishorpanara4191]

Awesome sir SQL SHIKHA O GE AUR KAI DINO SE APKA VIDEO DEKH RAHU LEKIN COMMENT NAHI KAR PA RAHAHU TO SORRY SIR MERI UNGLI ME PROBLEM HAI ACHHA HONE KE LIYE 6 DIN AUR LAGEGA

[@Innozant]

Koi Baat Nhi Kishor hi.. comment se jyada important Aapka health hai dear..Seekhte rhiye ab advanced topic chal rha hai use bhi.

[@samairasinghchauhan1662]

Superb

[@jaynarayan1963]

Very important sir

[@Innozant]

Thanks Jay🙏❤️👍

[@muhammadarif8006]

Excellent thanks a lot Sir 🇵🇰

[@kumkumchakraborty2892]

THANK YOU SIR

[@karanarora4272]

Apand kr k bhi add ho jayega sir data

[@hiteshfichadia8218]

Ohhh.. what a technic

[@hemgandhi8087]

Thank You

[@anirbanmukherjee2590]

Sir is it update automatically if the sheet info get update??

[@Innozant]

Offcourse in if core sheet get updated.it must be ..kindly test it Anirban❤️🙏

[@areebulhaque4666]

Sir I am Not getting that option in Get Data-> Microsoft query can you tell alternative or how to access that

[@Vishalkumar-qh8kg]

Sir we can use vstack

[@tejpalsain1507]

Thanks sir.

[@Innozant]

Thanks Tejpal ♥️🙏

[@excelmaster1328]

Sir iam not able to get Microsoft server option from get data tab ? Even I have Excel 2021 version

[@paviralanaresh]

I have a doubt sir what happens when we copy and paste sheets into another blank sheet?

[@Innozant]

There is no isssue

[@vikasrai3196]

Sir one suggestion when u start any session plz mark it 1 for second video on same session 2 till session complete so that we can easily find the complete session on same topic

[@Innozant]

Dear Vikas Ji . Every playlist is organized and videos are there in sequence..Kindly leaen step by step from baaic to advanced based on playlist videos sequence

[@artiverma5122]

Too good

[@Innozant]

Thanks Arti...Hope like the power query explanation video.

[@sonukumarskp6933]

Ye wala to Mera job me bahout kaam aata h sir

[@Innozant]

Thats Good..Happy Learning dear.

[@nikitakandarkar4066]

There is no return data function in my excel. How can i go back to excel from sql interface.

[@yogeshrao5924]

Nice

[@shrikantbadge3978]

Mano ya na Mano भैया, दीपक सर ने तो सब जादू वाले videos की khatiya खडी कर देनी है धीरे धीरे🤣🤣

[@Innozant]

Haha..Love You Shrikant...Apki in Umeedon pe khara utarne ki hi koshish jaari hai .♥️🙏

[@skmusicalgroupghinoi8950]

Thanks sir

[@Innozant]

❤️

[@18451111]

Very nicely explained but copy and paste kar k pivot table apply kate to aur easy hota

[@YashSharma-oe5bt]

I have a question about this topic that is heading contents of each table should be common? Or is it work on different heading contents of multiples sheets. Please clarify me about it

[@Innozant]

No issue dear..you must rename header and apply the same process ..There is no issue in output. Happy learning ♥️🙏

[@vijaykumarjain3222]

Nice sir

[@Innozant]

Thanks Vijay ji

[@vijaysahal4556]

Hi sir power query main direct sheet merge ho jati h

[@Innozant]

Direct sheet merge means.import ya workbook merging?

[@vijaysahal4556]

@@Innozant import sir

[@rinapawar4364]

I m using excel 2013 , so how can i use power query.. Is there any other option to combine multiple sheet.. Request you to please help me.

[@Innozant]

Hi Rina..Power query is there in office 2013.. You may proceed with same steps

[@rinapawar4364]

Ok. Thank you

[@amritathakur2036]

Sir In my system so much time taken connecting to data source why happened this in more time

[@Innozant]

Kaunsa system hai. Configuration kya hai

[@shaikh9394]

Sir agar hamain different branches ka merge data mile or ab hum chahty hain isko different worksheet ya different workbook pr distribute krdei to isko kase karenge is pr bhi video bnadei.

[@SunilYadav-hm6no]

Namaste sir

[@Innozant]

Namaste dear ❤️👍

[@LDEVARAJAN-w6j]

why do we need to do this if we can use that by just using ALT+d+p

[@hamzamalick5751]

Sir thanks for your efforts and valuable content ❤️ but sir practice files download nhi ho rhi ha??

[@Innozant]

Assignment master link diya hai video description me