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.com/drive/folder...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
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/innozantinfotech
#pivottableexcel #pivottablemultisheet#Innozant #powerquery #excelpowerquery
Пікірлер: 221
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
3 жыл бұрын
Thanks Jai for your appreciation.. Really means a lot to me..Have. A wonderful career ahead❤️🙏
@vitthalbedre34
Жыл бұрын
YES I'M ALSO
The way of teaching is amazing. Thanks a lot.
Best Excel learning channel ever seen in KZread . 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
3 жыл бұрын
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.🙏♥️
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
3 жыл бұрын
Thanks Kazi sahab..happy learning 🙏❤️
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
Your teaching method is too good
@Innozant
2 жыл бұрын
❤️❤️ Thanks dear
Bahut bahut dhanyawad sir.
Really you are awesome teacher so far. Thank for in details explanation.
@Innozant
2 жыл бұрын
Thanks Kuldeep Ji..God bless You dear
I enjoyed excelfun channel mr mike nd yours innozant both blog tq sir
@Innozant
2 жыл бұрын
Thanks Vijay❤️
Sir your so great teacher for excel
Great explain & nice tutorial.
No one can explain better than you Thanks a lot.
@Innozant
5 ай бұрын
Thanks dear
You're my true guru.... Thankyou so much.. I m so much excited to learn power query...and VBA..
@Innozant
3 жыл бұрын
Thanks Suvankar ,Happy Learning ♥️♥️
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
9 ай бұрын
Thanks..Keep learning..Keep exploring
You are really great Sir. Thanks for new series teaching
@Innozant
3 жыл бұрын
Thanks Tapan..Happy Learning 👍♥️🙏
Thank you sir. Wah maza aa jata h video dekh kar. we always wait for your video
@Innozant
3 жыл бұрын
Thanks Anup Ji.. Happy Learn dear ..,That for your love and support 🙏♥️
Your teaching skills are one of the best … you simplify difficult topics so well that learning actually did fun … hats off to you
@Innozant
2 жыл бұрын
Thanks Kavita ♥️👍
Great approach, executed this successfully,
@Innozant
3 жыл бұрын
Thanks Deepak.. Happy Learning ❤️🙏
Start From Superb ideas example...... thanks
@Innozant
3 жыл бұрын
Thanks Saddam ❤️👍
excellent teaching methods
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 ❤️
Your way of teaching is really awesome. thanks you so much sir
@Innozant
2 жыл бұрын
Thanks Aditi.. Really means a lot to me.We welcome you to experience the taste of Success with Innozant-Seed of Success
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
2 жыл бұрын
Thanks Sarvesh ji for valuable appreciation..Keep learning..keep exploring ❤️
Really helpful and amazing 👍🏻👍🏻thankyou!!! Homework Done 💝
@Innozant
3 жыл бұрын
Are Wah... Thanks ❤️👍🙏
Excellent teaching sir... कितनी खूबसूरती और आसानी से पढ़ाते हो.. Great.. Thanks sir.
@Innozant
Жыл бұрын
Thanks Bhushan Ji
Really helpful sir.
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
3 жыл бұрын
Thanks Ravi ,Happy Learning.Step by step hi seekhna hai ,Life me aage badhiye yhi wish hai meri
@ravisrivastava6722
3 жыл бұрын
@@Innozant thank you sir
U r one of the best teacher in the world god bless you
@Innozant
Жыл бұрын
Really means a lot to me
Amazing things I am learning from your channel. India need teachers like you. Your youtube Student from Najafgarh Delhi.
@Innozant
2 жыл бұрын
Thanks dear.. God bless You dear
you are great sir
Sir really aap bahot hi achese choti si choti cheez samjhate ho......thank u so much sir
@Innozant
Жыл бұрын
Thanks Heena..God bless you bacha ❤️👍
Superb dear sir.....
Really this is very useful thanks a lot
@Innozant
3 жыл бұрын
Thanks Yash.. happy Learning 🙏❤️👍
Thank you very must.. it was something new to learn
@Innozant
3 жыл бұрын
Thanks Varsha .Hope you like these videos and trying to enhance your skills on regular basis ..Happy Learning ♥️🙏
New series par sir ko badhai 🙏😊
@Innozant
3 жыл бұрын
🙂🙏♥️
Wat a wonderful and detailed explanation
@Innozant
3 жыл бұрын
Thanks Jai ❤️🙏Happy Learning ❤️🙏
You are master guru and savior
@Innozant
3 жыл бұрын
Thanks Jai.Hope these videos may add some value in your life❤️🙏
@jaitiwari241
3 жыл бұрын
@@Innozant 🙏🙏🙏
Big fan Sir 💓 apki har video's se hamari problem solve ho jati he thank you sir...
@Innozant
3 жыл бұрын
Thanks Aashu..Hope Aapke ye videos Pasand. Aate hain aur aap inse seekhte Hain ♥️🙏
Sir thank you so much for making this video
@Innozant
Жыл бұрын
Thanks Gaurav
Sir Really Value added content..... I have understood relationship concept 🤩
@Innozant
Жыл бұрын
Thanks Altaf
Thanks Sir, u r great.
@Innozant
3 жыл бұрын
Thanks Pradeep 🙏❤️
Thanks sir aap se bahut umeed hai. 🙏🙏🙏
@Innozant
3 жыл бұрын
Thanks Satish Ji👍🙏❤️
Thanks Brother
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 Hemant Ji..God bless You .Keep learning..Keep Exploring
Dear Sir Awesome much awaited video. I am trying to do it both SQL and power pivot. Thanks Jayanta Bhattacharyya.
@Innozant
3 жыл бұрын
Thanks Jayanta , Happy Learning Hope this example help you a lot 🙏♥️
Thank You
This is the premium content. Nobody gives this for free. You're a pure philanthropist Sir.🙌🙌🙌
@Innozant
3 жыл бұрын
Yes Shrikant Ji..M planning to upload complete tutorial from beginner to expert level .. Completely FREE on KZread Platform.Thats why m not going to sale Video Lecture😁👍♥️🙏
@devendergusain8974
3 жыл бұрын
@@Innozant THNAX SIR VERY MUCH LOVE U SIR
Excellent topic sir jii..... Practice ki jarurat hai isme.....😍😍❤❤
@Innozant
3 жыл бұрын
Haan Jitendra .. Practice is must 🙏
amazing sir once again!
@Innozant
3 жыл бұрын
Thanks Anand🙏♥️
Filhal mera system may ms office 2016 hai, or mayne apka video dekhkar practice vhi karli. Results bilkul sahi aya. Thank you "Sir"🙏
@Innozant
2 жыл бұрын
Thanks Ayan Ji..Happy learning ❤️
Sir, Hat's off to you............wah kya explanation hai..........you are best teacher........🙏👍👌
@Innozant
3 жыл бұрын
Thanks Ranvir ji..Happy learning dear❤🙏
Thanks sir very helpful video
@Innozant
2 жыл бұрын
Thanks Rahul
Thank you for teaching sir it's very helpful to us.
@Innozant
3 жыл бұрын
Thanks Sudhish . Happy Learning dear.. Practice is must .ok👍👍♥️🙏
@user-ke2mk6qz9z
3 жыл бұрын
@@Innozant ☺️
Thank you so much sir
@Innozant
2 жыл бұрын
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 👍❤️
Salute sir.. for Excel advance knowledge 😊😊😊
@Innozant
3 жыл бұрын
Thanks Gupta Ji.. Practice bht jaruri hai. In topic Ka
@Sanddystar17
3 жыл бұрын
@@Innozant ji sir aapke sare file ko achhe se series me rakha hai practice bhi hoti hai
Fantastic guru ji 👍🙏
@Innozant
3 жыл бұрын
Thanks Rahul Ji ❤️🙏
Excellent thanks a lot Sir 🇵🇰
Ohhh.. what a technic
great Job Sir
@Innozant
2 жыл бұрын
Thanks Shubham
Superb
I made the pivot table. thank you very much sir to make learn new something
@Innozant
3 жыл бұрын
Thanks Anup..Very good dear. Practice is must 🙏♥️
@AnupKumar-oe2jb
3 жыл бұрын
@@Innozant thank you Sir
Great vedio sir..
@Innozant
3 жыл бұрын
Thanks Mohan♥️🙏
very useful sir
@Innozant
3 жыл бұрын
Thanks dear
Thanks sir.
@Innozant
3 жыл бұрын
Thanks Tejpal ♥️🙏
great sir 🙏
@Innozant
3 жыл бұрын
Thanks Ishu.. Happy Learning ♥️🙏
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
3 жыл бұрын
Situ Sahoo Ji .. Thanks dear...next video issse bhi Hatke aane wala hai🙏♥️❤️🙂
Very important sir
@Innozant
3 жыл бұрын
Thanks Jay🙏❤️👍
Very nicely explained but copy and paste kar k pivot table apply kate to aur easy hota
Can't wait for Power Query...🤩🤩
@Innozant
3 жыл бұрын
Happy Learning...♥️🙏How's todays Video🙂 Practice is must 🙏
@razamoulvi8801
3 жыл бұрын
@@Innozant Yes sir👍🏻👍🏻Great video ... Thanks for the video😊
Too good
@Innozant
3 жыл бұрын
Thanks Arti...Hope like the power query explanation video.
Thanks sir
@Innozant
2 жыл бұрын
❤️
Arre aap to bde heavy teacher ho bhai 😎
@Innozant
3 жыл бұрын
Hahaha.Heavy Teacher😀😀ye kya hota hai Solanki sahab.
@sagarsinghsolanki3546
3 жыл бұрын
@@Innozant matlab bahut badhiya 👏
Nice
bahut bahut important topic hai, mujhe poora playlist dekhna hai Power query
@Innozant
Жыл бұрын
Playlist hai power query ka
Hum toh wait kiye hein aap google sheet ke bare mein.start karenge.🙏🙏❤️❤️
@Innozant
3 жыл бұрын
Wo bhi krenge series start
Sir all excel series are awesome please start new series for SQL Thanku
@Innozant
3 жыл бұрын
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
3 жыл бұрын
@@Innozant thanku sir & I'm waiting........
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
7 ай бұрын
👍
Nice sir
@Innozant
3 жыл бұрын
Thanks Vijay ji
Mano ya na Mano भैया, दीपक सर ने तो सब जादू वाले videos की khatiya खडी कर देनी है धीरे धीरे🤣🤣
@Innozant
3 жыл бұрын
Haha..Love You Shrikant...Apki in Umeedon pe khara utarne ki hi koshish jaari hai .♥️🙏
Namaste sir
@Innozant
3 жыл бұрын
Namaste dear ❤️👍
Ye wala to Mera job me bahout kaam aata h sir
@Innozant
3 жыл бұрын
Thats Good..Happy Learning dear.
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
3 жыл бұрын
Koi Baat Nhi Kishor hi.. comment se jyada important Aapka health hai dear..Seekhte rhiye ab advanced topic chal rha hai use bhi.
Homework done
@Innozant
3 жыл бұрын
Very good 👍♥️
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
3 жыл бұрын
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
Please share video for power pivot
Apand kr k bhi add ho jayega sir data
🙏🙏 Sir mere pass 2007 ka ms office aa but sir main je 2016 ms dekhta hu thnq sir
@Innozant
3 жыл бұрын
Very good Bhatia Ji🙏❤️👍
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?
Sir I am Not getting that option in Get Data-> Microsoft query can you tell alternative or how to access that
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
Sir we can use vstack
There is no return data function in my excel. How can i go back to excel from sql interface.
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
3 жыл бұрын
No issue dear..you must rename header and apply the same process ..There is no issue in output. Happy learning ♥️🙏
why do we need to do this if we can use that by just using ALT+d+p
Sir is it update automatically if the sheet info get update??
@Innozant
3 жыл бұрын
Offcourse in if core sheet get updated.it must be ..kindly test it Anirban❤️🙏
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.
I have a doubt sir what happens when we copy and paste sheets into another blank sheet?
@Innozant
2 жыл бұрын
There is no isssue
Sir i am Graduate from ART stream, toh mera koi scope hai exel me. Please sir reply me 🙏🙏
@Innozant
3 жыл бұрын
Offcourse..eithe you are commerce or Science graduate doesn't matter ,It's very good field MIS Reporting. kzread.info/dash/bejne/jGF5zrSbqrqyYqw.html
Sir using SQL query I got error could not add table evening 🙏🏻🙏🏻 help sir
@Innozant
3 жыл бұрын
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
Sir agar billions of row ka data hai toh use tabular form me kaha store kare aor kaise analyse kare please 🙏 bataiye