Pivot Table Multiple Workbook | Create a Pivot Table from Multiple Workbooks | Excel Power Query

One Pivot from Multiple files | Pivot Table Multiple Workbook | Create a Pivot Table from Multiple Workbooks | Excel 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 #pivottablemultiworkbook#Innozant #onepivotfrommultiplefiles#excelpowerquery

[@anjaligulatiamb_123]

Bilkul shi kha sir apne,..ak baar mein nhi ata..next time fir se go through kiya to pta chla..k ..abhi or dhyan se dekhna chahiye...really concept gets clear..thank you sir..🙏🤗🙏

[@Innozant]

Thanks Anjali..Happy Learning ❤️

[@kashifqasim8069]

I am from Karachi Pakistan I ❤ your way of teaching and guiding. I your explanation is very helpful

[@Innozant]

Thanks Kashif Keep learning

[@tanweerabbasabbas649]

Great way of explaining🥰🥰🥰

[@shahzadsiddiqui5117]

bahut bahut important concept sir , Thanks..!

[@Innozant]

❤️👍

[@muhammadarif8006]

Excellent teaching Sir thanks alot.🇵🇰

[@bhagatrishi5454]

you helped a lot to do data analysis of stock market daily huge data with very simple steps. now i am more efficient after this video, but tookk time to establish relations and designing my data connections. thank you.

[@Innozant]

Thanks Bhagat H for your valuable appreciation..Happy learning dear❤️

[@situsahoo2482]

It's very good.but hum is video ko ruk ruk ke dikh raha hun.aur sikh raha hoo.sir.pehli bar samna ho gaya hai gada dhari bhim ke samne 😀.but aapke hum ko is tarah guide kar rah hain hum dedicated ho kar sikh rah hai.ending part.mein.thoda dimag lagana hai.Its much more needed . corporate sector.Thanks dilip sir ❤️

[@Innozant]

Yes Situ ..Maine video ke start me hi bata Diya tha Thora sa complex hai..but dhyanse steps dekhnege aur excercise file ki Practice krnege to ye bht kaam aayega job me..it's very important real time Question.🙏❤️

[@manber1987]

Lean a lot from you sir keep teaching

[@horrorlovestories]

Bahooot khatarnak topic hai sach mein practice karna hoga 😀

[@Innozant]

Offcourse iska practice krna hoga dear

[@anuraggupta8002]

Bahot badiya sir.

[@saahilsaahil5912]

Sir in this current scenario I don't think no other youtuber is better than you in terms of teaching excel series.. you are just fantastic n fantabulous.. I have a utmost request to you.. Sir you don't need any background music your way of teaching style is more enough for us to entertain..kindly don't play any background music while you make us understanding in the beginning of the video.. thank you so much for all your videos m very admired by you sir👍👍

[@Innozant]

Thanks Sahil Ji...For your love and support..Dear .Music is in only intro part ..there is NO background music is in mg any of the videos.. Happy Learning..🙏❤️

[@saahilsaahil5912]

@@Innozant ok sirji....waise bhi aapki awaz music se bhttttttttttt ziyada achi hai.. ☺☺

[@tejpalsain1507]

Thanks sir. इसका पहली बार सामना हुआ है इसलिए समझने में कठिन लग रहा है। पर लगातार क्लास टू क्लास देखूंगा तो समझ मे आ जायेगा शायद।

[@Innozant]

Haan Maine batay bhi ki ye Thora complex hai..dhyan se video pause krke dekhna hai aur Saath hi Practice krenge to aayega .bht important btopic hai ye .

[@vishalbhati912]

Bahot badiya sir.

[@Innozant]

Thanks Vishal Ji♥️

[@rewawaleashu1554]

You are really genius sir

[@rashidfaridkhan2664]

Excellent way of Explaination.. Love it..

[@Innozant]

Thanks Rashid ..Keep Learning ❤️

[@neetasharma204]

You explained it so wonderfully. You helped me a lot to learn. You are a fantastic teacher.

[@Innozant]

Thanks Neeta.. Really means a lot to me dear

[@tech_sultanpur]

Sir ... Your Teaching Style is Excellent ... This is Different and Most Important Topic ... Thànk you Dear Sir

[@Innozant]

Thanks Ahsaan...in topics ke assignment Practice bht jaruri hai dear.🙏❤️

[@MrAbir06]

U r really great... Aap ka fan bangaya sir

[@Innozant]

Thanks Abir aapke is pyare aur valuable comment ke liye 🙏❤

[@jayantabhattacharyya628]

Dear Sir Excellent video. Every day I am learning excel from your unique teaching but it is a new topic. Hope this will help me to add knowledge in power query and power pivot. Thanks Jayanta Bhattacharyya

[@Innozant]

Thanks Jayanta.. Practice is must for these topics 🙏❤️

[@user-jc6te1vm8v]

magician!! that's u r.... simply awesome!! keep the great work going....

[@Innozant]

Thanks Anand Ji..HV a great day 🙏

[@sachinkamble9359]

Amazing video , thanks a ton

[@nocopyrightvideos163]

Sir jii Aap es video main smarty lag rahai ho 😎 I meen aap pe ye shut accha lag raha hai & sir jii really youtube par maine bahut videos watch ki hai but but aapki video ek baar main samajh main aa jati hai thanks thanks sir ji love from Delhi 😊

[@Innozant]

Thanks dear aapke valuable appreciation ke liye ..God bless You .Keep learning and exploring

[@msexcelgooglesheet374]

Mind Blowing Video Sir ji.

[@Innozant]

Practice bht jaruri hai dear..👍🙏❤️

[@superNareshg]

Superb sir ji. Thank you 🙏

[@ramavtarsingh146]

Very informatic keep it up

[@forgotten_friend5406]

excellent sir

[@hemgandhi8087]

Thank You

[@aritramech]

Excellent tutorial. And very detailed teaching technique; only want to know that if I only use two tables from two workbooks ; do I need to create relationships then?

[@Innozant]

If you require corresponding value from another table .. offcourse we need relationship

[@KuldeepSingh-nq1vi]

Super Advanced Video. 😍😍😍

[@Innozant]

Thanks Kuldeep Ji.Happy Learning ❤️

[@kinghundred]

very useful sir

[@Innozant]

Thanks

[@vijaysahal4556]

Nice sir 👍🏻👍🏻👍🏻👍🏻

[@Innozant]

❤️

[@mohammedfareeduddin5642]

Nice informative classes sir... Sir mere pass 3 different teams ka productivity report hai. Mere boss ne isko dynamically summary banake liye bola. Isko my kaisa karunga?

[@mohammedfareeduddin5642]

Summary fields are Total Production Per Month Average Production per day Average Handling Time (Production) (min) Production total time spent (Hours) Average Quality Check % QC total Approx. QC AHT (min) QC total time spent (Hours) Total Time spent (Hours) Prod+QC Total FTE FTE Utilized

[@viratclasses4400]

Really too good...❤️

[@Innozant]

Thanks Virat Ji👍❤️

[@bittusatyaa]

Can you explain with different header

[@user-ke2mk6qz9z]

Great Sir 👌

[@Innozant]

Thanks dear ...

[@deemanshugundhaiya2148]

Sir NSE 50 chart se pivot charts bana saktey hai?

[@mdfirojansari887]

Sir I have a question regarding 2019 data which has connection only then what is its use? If it is not mention in relationship.

[@Innozant]

Again recheck the videos ,wo maine situation btaya hai ki kuch data set ka sirf connection ki hi requirements hoti h

[@mdfirojansari887]

@@Innozant thank you so much 💓 sir for reply...and I just want to tell you I am learning these days from you. The way you are teaching is a very unique technique and conceptually it is very clear to understand...after research I got your video which I had never got..thank you again sir for unconditional support.

[@mahadevkhandekar1]

Connection karne ke bad workbook update nahi kar sakta. Kya issue hoga? ya maine kuch galat kiya tha kya? message got as sheet used for other person even if this sheet is not read only.

[@TechnobunnY]

Sir heading common na ho but 2 files mein Invoice number with original invoice value and Sales Return ko compare karna hai with duplicate instances of sales return? Please guide how to do that

[@satishojha6240]

Sir aapka har video bahut valuable hai. Comment mai sql server ki demand ho rahi hai aapki kya rai hai sir jaroor bataye ga thanku sir 🙏🙏🙏.

[@Innozant]

SQL query aana chaiye yadi Data Analyst ke liye apply Kar rahe Hain to.. companies ki demand time ke Saath badhti ja rahi hai ..unko Fullstack Employees chaiye HOTA hai Jise sab aata ho🙂♥️

[@anjaligulatiamb_123]

Sir,if we are using old version 2007,.to usme possible hai kya..relationship concept

[@Innozant]

Update kar lijiye excel 2016 .. available hain net par free version Anjali

[@anjaligulatiamb_123]

@@Innozant ok sir 🙏

[@padmatv1203]

All procedure I completed as like as you but Pivot report doesn't generate showing data model. Please give me the solution.

[@xploretheworldwithsrvlondon11]

Please make video on how sql is useful in mis reporting

[@Innozant]

Sql series alag se aane wale hain

[@andyalejandro9523]

Fantastic 😍💋 💝💖♥️❤️

[@aabdullahhaasnain7033]

Each sheet or each workbook has same head. But how will I combine different sheet or workbook without similarities.

[@bansilal8669]

which version excel it is?

[@xploretheworldwithsrvlondon11]

Please make a video on power bi

[@Innozant]

After power query and powrr pivot..will upload power bi series

[@Just_cringe_]

Sir ek video how to convert text to numbers ke uppr b banaiye . Mere office m ek bar data m maine text value ko no. M change krne ke liye *1 kiya . Value function se krne ki koshish ki.. Or right click krke convert to numbers krne ki koshish ki.. bt wo data type change nhi hua. Kya iske alawa b . Data formatting ho skti h ?

[@Innozant]

haan ho sakti hai wo data dikhne me text hoga but hoga nhi .there are several method to convert text to numbers

[@Just_cringe_]

Bt maine multiply by 1 Or value formula dono try kiye .. wo nhi hua ..

[@Just_cringe_]

Data GST WEBSITE SE Download ki thi...

[@zaid-e-mehfil2274]

Sir.... How to apply conditional formatting on Pivot table

[@Innozant]

Video me cover kiya hai playlist me

[@zaid-e-mehfil2274]

@@Innozant sir maine bahut dhoondha pivot table me condiotional formatting kaise lgate hai but nahi mila....

[@tejpalsain1507]

सर कल वाले असाइनमेंट में मैने Pivot tabal और chart बनाया था। बन गया था, और मैने आपको मेल किया था,।

[@Innozant]

Haan Dekh liya tha Tejpal Ji..good 🙏♥️

[@tejpalsain1507]

@@Innozant thanks

[@gauravbhatia7987]

Thnq sir 🙏

[@Innozant]

♥️🙏

[@tanweerabbasabbas649]

But i feel you need to make the power query video before this one..😊

[@debaruddhasahachowdhury8868]

Need your help to create pivot table from multiple sheet. I am trying but not happening as like your instruction

[@Innozant]

What problem. You are facing now

[@debaruddhasahachowdhury8868]

@@Innozant I have 2year data in multiple workbook. But I unable to create pivot table with using this multiple workbook. Data is too long

[@debaruddhasahachowdhury8868]

I need your online help to make this pivot table . My job is under threat for this

[@IMRANALI-pt9bt]

Sir jab mai data sheet ko open kar raha hu to navigator ke andar select multiple items nahi mil raha hai shirf sheet 1 likh kar aa raha hai isse kaise sahi kar sakte hai

[@sahilsreedharan]

👌👌👌👌👌👌👌👌👌👌👌👌👌

[@vvv1160]

Which version of ms office?

[@SunilYadav-hm6no]

O May God

[@Innozant]

Thanks.. happy Learning 🙏❤️

[@jaythechhotuteacher3206]

Sir i am not getting GET DATA OPTION in DATA Tabe in miscrosoft office 2013, i am not able to import data from other workbook. i dont get power querry option.

[@Innozant]

Import data hoga office 2013 me..

[@jaythechhotuteacher3206]

@@Innozant Do i need to add power querry, or kindly provide me the steps.

[@poulomidevroy6265]

Hello sir ... i am from kolkata and currently working in finance domain but wish to shift my career to MIS... i am greatly inspired by your teaching... please let me know how to participate in the excel assessment test conducted by Innozant and how much is the fees...

[@Innozant]

Dear Paulomi Dev ,Thanks for showing your interest in MIS & Data Analytics learning.We welcome you experience the taste of success with Innozant-Seed of Success. Kindly note that we are not charging a single penny from you if you are skilled and able to crack the interview.Will provide you no. of job reference for the same. Yes We charge fees if you are Interested to learn Mis and related technology from us in LiVE CLASSROOM session. For more info/Career guidance you may call/Whatsapp on 7065069985

[@prajwalshetty2047]

👍

[@tanweerabbasabbas649]

Cannot load sample file it says error!!. Doosree baat ye ke google folder se same video ka sample file araam se nahi milta.. pls guide...

[@abhishekshrivastava8500]

Sir please basic and advanced macros p video baniye

[@Innozant]

haan kuch time baad

[@prajwalshetty2047]

Sir I am not able to get the GET DATA option in data tabe in Microsoft office 2013, I am not getting option to import data from other workbook. I am not getting the power query option. Please help me out Sir

[@Innozant]

Office 2013 kaunsa hai home edition ya professional

[@prajwalshetty2047]

@@Innozant Microsoft office Professional Plus 2013, and I think crack version.

[@muhammadtariqmayo1630]

Assalamualaikum sir Main 2 table se Pivot table banata hun lekin is mein relationship Nahin Hota iska Koi HAL bataen.thanks

[@kuldeepgandhi2589]

sir where are u from?

[@Innozant]

Aap Kahan se Hain Kuldeep Ji❤️🙏

[@riya31833]

I am using Excel 2016. My query is while doing the exercise of this sheet, I am getting below mentioned error :- We couldn't get data from the data model, Here's the error message we got" NO error message available, result code:-21462333052(0x80131524) kindly tell me why i am getting this error Thanks

[@Innozant]

Check your data format..is it csv or excel or ither data format?

[@rubyyadav6466]

Sir i m not getting get data option in my excel data

[@Innozant]

Hi Ruby..Kindly tell mw which Ms office version you are working now..Will guide you

[@rubyyadav6466]

Sir version 10

[@debabratachakraborty847]

2016 transform Nehi hai

[@chandrabhanmishra1898]

Deta modal में add करने के बाद शो रिपोर्ट फिल्टर पेज बटन काम नही करता

[@Innozant]

Which version

[@chandrabhanmishra1898]

@@Innozant MS Office 16 and 365 verson

[@kutaldilip5685]

Mere sheet main Relationship nahi ho paa raha he .. please help

[@Innozant]

Kys issue aa ra hai Dilip ji .kindly tell me

[@RakeshSingh-qo5nd]

Iska sir use kya hai mujhe samjh nhi aa rha. Multiple sheet par agr data ho to relationship stablish kar k normally pivot table bna skte hai to iske use se banane ki kya jarurat hai.. sir apne power query ke powers k fayde kya kya hain apne isse bhi describe nhi kiya hai to please ise describe kijiye jisse ham concept ke sath relate kr paye aur samjh paye.

[@Innozant]

Rakesh Ji ..Aap Aisi baat kroge😁 Ye multiple sheet se nhi banaya hai pivot dear. ..Multiple workbook ke bich me relationship establish Kiya hai...Ek Baar aap video phirse repeat kijiye .aur mujhe phir bataiye ki samajh Aaya ki Nahi...aayega samajh Thora complex but it's really usefulk dear. Ab Aapke second query Ka reply-aap yadi kal aur aaj wale video ko dekhen to Maine Baar Baar Bola hai ki he main power query Nahi Kara rha hi bus mujhe pivot table me query ki jarurat aayi hai isliye use Kiya hu..Maine aaj bhi Bola ki kya interface hai power query ke apko bikul nhi sochna hai..Power Pivot aur Power query Ka Basic to advanced Playlist scratch se start krenge usme ek ek baareeki se aikhaya Jayega ..Don't worry ..bus abhi Jaise steps Maine kiye Hain follow krke pivot from multiple workbook with relationship kijiye ye Practice..🙏♥️♥️🙏🙏

[@RakeshSingh-qo5nd]

@@Innozant okay sir but maine kal wale video ke liye bola tha multiple sheet 😀

[@Innozant]

Haan wo Rakesh ek hi workbook me multiple sheet ko merge Kiya humne..ye multiple workbook se Kiya h merge .

[@sushilaswal8950]

Sir ye excel 2007 me nahi aa rha hai

[@Innozant]

Usme avY nhi h dear

[@DeepakSharma-fl5yf]

Sir Ji, I have MS Office 2013 and Transform data is not showing in excel.

[@Innozant]

Import data option hoga office 13 me bhi dear

[@amritathakur2036]

Sir aap shi kh rhe the ki ye ek baar Mai smj ni aaega

[@Innozant]

Haan..step by step Seekhiye aayega samjh

[@traditionalmaithilisong6019]

Sir your video are supper. I learn more and more. Please sir make advance video of reconciliation in excel for bank statement, cash book and debit and credit note. Please give whatapps number

[@tanweerabbasabbas649]

Great🫠🫠🫠🫠

[@tanweerabbasabbas649]

Love from karachi🫠🫠🫠🫠🫠