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

[@bhushankadam5632]

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

[@Innozant]

Thanks Bhushan Ji

[@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 ❤️👍

[@bnmishra7558]

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

[@Innozant]

Really means a lot to me

[@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 ❤️

[@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 🙏❤️

[@DKG-MIS]

No one can explain better than you Thanks a lot.

[@Innozant]

Thanks dear

[@ManjeetSingh-th4fu]

The way of teaching is amazing. Thanks a lot.

[@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 ♥️♥️

[@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 ♥️🙏

[@md.sumonkhandaker451]

Your teaching method is too good

[@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

[@vijaysahal4556]

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

[@Innozant]

Thanks Vijay❤️

[@saddammalik5566]

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

[@Innozant]

Thanks Saddam ❤️👍

[@vinayvemul8456]

Sir your so great teacher for excel

[@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

[@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

[@KuldeepSingh-nq1vi]

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

[@Innozant]

Thanks Kuldeep Ji..God bless You dear

[@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

[@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

[@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 ♥️👍

[@Altaf_Alam]

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

[@Innozant]

Thanks Altaf

[@rangel9082]

Sir you are great ❤

[@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 ❤️

[@deepakchauhan4974]

Great approach, executed this successfully,

[@Innozant]

Thanks Deepak.. Happy Learning ❤️🙏

[@forgotten_friend5406]

excellent teaching methods

[@Jitenderkumar-yp1rn]

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

[@Innozant]

Haan Jitendra .. Practice is must 🙏

[@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 🙏♥️

[@ranvir0392]

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

[@Innozant]

Thanks Ranvir ji..Happy learning dear❤🙏

[@jaitiwari241]

You are master guru and savior

[@Innozant]

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

[@jaitiwari241]

@@Innozant 🙏🙏🙏

[@satishojha6240]

Thanks sir aap se bahut umeed hai. 🙏🙏🙏

[@Innozant]

Thanks Satish Ji👍🙏❤️

[@padmakarbadge8419]

Bahut bahut dhanyawad sir.

[@tapankumardas8252]

You are really great Sir. Thanks for new series teaching

[@Innozant]

Thanks Tapan..Happy Learning 👍♥️🙏

[@karimsamnani3660]

Great explain & nice tutorial.

[@RahulChauhan-ll9pu]

Fantastic guru ji 👍🙏

[@Innozant]

Thanks Rahul 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🙏♥️❤️🙂

[@sagarsinghsolanki3546]

Arre aap to bde heavy teacher ho bhai 😎

[@Innozant]

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

[@sagarsinghsolanki3546]

@@Innozant matlab bahut badhiya 👏

[@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 ☺️

[@devangthakkar6847]

Superb dear sir.....

[@gauravgupta6458]

Sir thank you so much for making this video

[@Innozant]

Thanks Gaurav

[@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 ♥️🙏

[@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

[@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 ❤️🙏

[@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 🙏♥️

[@shahzadsiddiqui5117]

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

[@Innozant]

Playlist hai power query ka

[@E_K18]

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

[@Innozant]

Are Wah... Thanks ❤️👍🙏

[@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........

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@Innozant]

Thanks Rahul

[@shaileshkumar-qf6bd]

you are great sir

[@situsahoo2482]

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

[@Innozant]

Wo bhi krenge series start

[@adamgamingshorts6502]

Really helpful sir.

[@bushrarashid5860]

thank you so much sir

[@muhammadarif8006]

Excellent thanks a lot Sir 🇵🇰

[@shubhamsoni8115]

great Job Sir

[@Innozant]

Thanks Shubham

[@samairasinghchauhan1662]

Superb

[@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😊

[@kumkumchakraborty2892]

THANK YOU SIR

[@mohammadazam5729]

Thanks Brother

[@mohan8887]

Great vedio sir..

[@Innozant]

Thanks Mohan♥️🙏

[@kinghundred]

very useful sir

[@Innozant]

Thanks dear

[@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]

👍

[@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 👍❤️

[@pardeeparya9986]

Thanks Sir, u r great.

[@Innozant]

Thanks Pradeep 🙏❤️

[@user-jc6te1vm8v]

amazing sir once again!

[@Innozant]

Thanks Anand🙏♥️

[@ishutiwari5567]

great sir 🙏

[@Innozant]

Thanks Ishu.. Happy Learning ♥️🙏

[@jaynarayan1963]

Very important sir

[@Innozant]

Thanks Jay🙏❤️👍

[@hiteshfichadia8218]

Ohhh.. what a technic

[@hemgandhi8087]

Thank You

[@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.

[@18451111]

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

[@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?

[@yogeshrao5924]

Nice

[@sonukumarskp6933]

Ye wala to Mera job me bahout kaam aata h sir

[@Innozant]

Thats Good..Happy Learning dear.

[@tejpalsain1507]

Thanks sir.

[@Innozant]

Thanks Tejpal ♥️🙏

[@areebulhaque4666]

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

[@karanarora4272]

Apand kr k bhi add ho jayega sir data

[@artiverma5122]

Too good

[@Innozant]

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

[@shrikantbadge3978]

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

[@Innozant]

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

[@excelmaster1328]

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

[@vijaykumarjain3222]

Nice sir

[@Innozant]

Thanks Vijay ji

[@skmusicalgroupghinoi8950]

Thanks sir

[@Innozant]

❤️

[@SunilYadav-hm6no]

Namaste sir

[@Innozant]

Namaste dear ❤️👍

[@nikitakandarkar4066]

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

[@gauravbhatia7987]

🙏🙏 Sir mere pass 2007 ka ms office aa but sir main je 2016 ms dekhta hu thnq sir

[@Innozant]

Very good Bhatia Ji🙏❤️👍

[@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

[@Vishalkumar-qh8kg]

Sir we can use vstack

[@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❤️🙏

[@paviralanaresh]

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

[@Innozant]

There is no isssue

[@sitaramkohli9549]

Sir using SQL query I got error could not add table evening 🙏🏻🙏🏻 help sir

[@Innozant]

You are doing somewhere wrong when pass SQL query ..ek Baar dhyan se dekhiye Maine kaise Kiya hai aur apply kriye..it's working fine

[@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

[@technewz1]

Sir agar billions of row ka data hai toh use tabular form me kaha store kare aor kaise analyse kare please 🙏 bataiye

[@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

[@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

[@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.