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

Pivot Table Multisheet | Microsoft Power Query | Combine sheets with Excel Power Query
1. Learn how to combine multiple worksheet into one sheet using power query
2. Create Pivot Table based on Multisheet merging using power query
Excel Pivot Tables Playlist Link- • Excel Pivot Tables
Download the Assignment Master Practice Folder here (All Playlist Example at one place) drive.google.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#pivottableexcel #pivottablemultisheet#Innozant #powerquery #excelpowerquery

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

[@bhushankadam5632]

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

[@Innozant]

Thanks Bhushan Ji

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

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

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

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

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

[@DKG-MIS]

No one can explain better than you Thanks a lot.

[@Innozant]

Thanks dear

[@bnmishra7558]

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

[@Innozant]

Really means a lot to me

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

[@ManjeetSingh-th4fu]

The way of teaching is amazing. Thanks a lot.

[@md.sumonkhandaker451]

Your teaching method is too good

[@Innozant]

❤️❤️ Thanks dear

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

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

[@saddammalik5566]

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

[@Innozant]

Thanks Saddam ❤️👍

[@vinayvemul8456]

Sir your so great teacher for excel

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

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

[@vijaysahal4556]

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

[@Innozant]

Thanks Vijay❤️

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

[@forgotten_friend5406]

excellent teaching methods

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

[@Altaf_Alam]

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

[@Innozant]

Thanks Altaf

[@KuldeepSingh-nq1vi]

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

[@Innozant]

Thanks Kuldeep Ji..God bless You dear

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

[@puransingh-sx2tk]

New series par sir ko badhai 🙏😊

[@Innozant]

🙂🙏♥️

[@ranvir0392]

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

[@Innozant]

Thanks Ranvir ji..Happy learning dear❤🙏

[@deepakchauhan4974]

Great approach, executed this successfully,

[@Innozant]

Thanks Deepak.. Happy Learning ❤️🙏

[@Jitenderkumar-yp1rn]

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

[@Innozant]

Haan Jitendra .. Practice is must 🙏

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

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

[@sagarsinghsolanki3546]

Arre aap to bde heavy teacher ho bhai 😎

[@Innozant]

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

[@sagarsinghsolanki3546]

@@Innozant matlab bahut badhiya 👏

[@shahzadsiddiqui5117]

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

[@Innozant]

Playlist hai power query ka

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

[@tapankumardas8252]

You are really great Sir. Thanks for new series teaching

[@Innozant]

Thanks Tapan..Happy Learning 👍♥️🙏

[@padmakarbadge8419]

Bahut bahut dhanyawad sir.

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

👍

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

[@karimsamnani3660]

Great explain & nice tutorial.

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

[@E_K18]

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

[@Innozant]

Are Wah... Thanks ❤️👍🙏

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

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

[@situsahoo2482]

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

[@Innozant]

Wo bhi krenge series start

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

[@devangthakkar6847]

Superb dear sir.....

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

[@gauravgupta6458]

Sir thank you so much for making this video

[@Innozant]

Thanks Gaurav

[@RahulChauhan-ll9pu]

Fantastic guru ji 👍🙏

[@Innozant]

Thanks Rahul Ji ❤️🙏

[@shaileshkumar-qf6bd]

you are great sir

[@bushrarashid5860]

thank you so much 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 ♥️🙏

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@Innozant]

Thanks Rahul

[@YashSharma-oe5bt]

Really this is very useful thanks a lot

[@Innozant]

Thanks Yash.. happy Learning 🙏❤️👍

[@jaitiwari241]

Wat a wonderful and detailed explanation

[@Innozant]

Thanks Jai ❤️🙏Happy Learning ❤️🙏

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

[@mohammadazam5729]

Thanks Brother

[@adamgamingshorts6502]

Really helpful sir.

[@18451111]

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

[@muhammadarif8006]

Excellent thanks a lot Sir 🇵🇰

[@samairasinghchauhan1662]

Superb

[@shubhamsoni8115]

great Job Sir

[@Innozant]

Thanks Shubham

[@hemgandhi8087]

Thank You

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

[@kinghundred]

very useful sir

[@Innozant]

Thanks dear

[@hiteshfichadia8218]

Ohhh.. what a technic

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

[@jaynarayan1963]

Very important sir

[@Innozant]

Thanks Jay🙏❤️👍

[@areebulhaque4666]

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

[@pardeeparya9986]

Thanks Sir, u r great.

[@Innozant]

Thanks Pradeep 🙏❤️

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

[@mohan8887]

Great vedio sir..

[@Innozant]

Thanks Mohan♥️🙏

[@sonukumarskp6933]

Ye wala to Mera job me bahout kaam aata h sir

[@Innozant]

Thats Good..Happy Learning dear.

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

[@ishutiwari5567]

great sir 🙏

[@Innozant]

Thanks Ishu.. Happy Learning ♥️🙏

[@karanarora4272]

Apand kr k bhi add ho jayega sir data

[@yogeshrao5924]

Nice

[@tejpalsain1507]

Thanks sir.

[@Innozant]

Thanks Tejpal ♥️🙏

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

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

[@user-jc6te1vm8v]

amazing sir once again!

[@Innozant]

Thanks Anand🙏♥️

[@artiverma5122]

Too good

[@Innozant]

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

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

[@skmusicalgroupghinoi8950]

Thanks sir

[@Innozant]

❤️

[@shrikantbadge3978]

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

[@Innozant]

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

[@vijaykumarjain3222]

Nice sir

[@Innozant]

Thanks Vijay ji

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

[@Vishalkumar-qh8kg]

Sir we can use vstack

[@mohdjakir6719]

Sir i am Graduate from ART stream, toh mera koi scope hai exel me. Please sir reply me 🙏🙏

[@Innozant]

Offcourse..eithe you are commerce or Science graduate doesn't matter ,It's very good field MIS Reporting. kzbin.info/www/bejne/kF6onYWYr7x_aKs

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

[@bhimkunwor3894]

Please share video for power pivot

[@paviralanaresh]

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

[@Innozant]

There is no isssue

[@anupg8927]

Homework done

[@Innozant]

Very good 👍♥️

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

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

[@RAKESHKUMAR-qw9cn]

VBA ki class bhi start kre basic to advanced. Aap kab se suru krge VBA ki class. Or SQL ki class pls bataye.

[@Innozant]

Thanks Rakesh Ji for suggestion,Dheere dheere sabhi series start honge dear,Main koi bhi series start krunga to complete tutorial launga..♥️🙏