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

[@RishabhMishra-kn3fv]

You are the best teacher

[@shahzadsiddiqui5117]

bahut bahut important concept sir , Thanks..!

[@Innozant]

❤️👍

[@tanweerabbasabbas649]

Great way of explaining🥰🥰🥰

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

[@muhammadarif8006]

Excellent teaching Sir thanks alot.🇵🇰

[@manber1987]

Lean a lot from you sir keep teaching

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

[@kumkumchakraborty2892]

Sir, please make a basic SQL tutorial to advance. Your teaching is amazing.

[@horrorlovestories]

Bahooot khatarnak topic hai sach mein practice karna hoga 😀

[@Innozant]

Offcourse iska practice krna hoga dear

[@anuraggupta8002]

Bahot badiya sir.

[@kashifqasim8069]

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

[@Innozant]

Thanks Kashif Keep learning

[@MrAbir06]

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

[@Innozant]

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

[@rashidfaridkhan2664]

Excellent way of Explaination.. Love it..

[@Innozant]

Thanks Rashid ..Keep Learning ❤️

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

[@user-jc6te1vm8v]

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

[@Innozant]

Thanks Anand Ji..HV a great day 🙏

[@vishalbhati912]

Bahot badiya sir.

[@Innozant]

Thanks Vishal Ji♥️

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

[@rewawaleashu1554]

You are really genius sir

[@ramavtarsingh146]

Very informatic keep it up

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

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

[@msexcelgooglesheet374]

Mind Blowing Video Sir ji.

[@Innozant]

Practice bht jaruri hai dear..👍🙏❤️

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

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

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

[@sachinkamble9359]

Amazing video , thanks a ton

[@superNareshg]

Superb sir ji. Thank you 🙏

[@KuldeepSingh-nq1vi]

Super Advanced Video. 😍😍😍

[@Innozant]

Thanks Kuldeep Ji.Happy Learning ❤️

[@kiran68098]

great sir

[@vijaysahal4556]

Nice sir 👍🏻👍🏻👍🏻👍🏻

[@Innozant]

❤️

[@forgotten_friend5406]

excellent sir

[@kinghundred]

very useful sir

[@Innozant]

Thanks

[@viratclasses4400]

Really too good...❤️

[@Innozant]

Thanks Virat Ji👍❤️

[@hemgandhi8087]

Thank You

[@user-ke2mk6qz9z]

Great Sir 👌

[@Innozant]

Thanks dear ...

[@andyalejandro9523]

Fantastic 😍💋 💝💖♥️❤️

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

[@gauravbhatia7987]

Thnq sir 🙏

[@Innozant]

♥️🙏

[@bittusatyaa]

Can you explain with different header

[@deemanshugundhaiya2148]

Sir NSE 50 chart se pivot charts bana saktey hai?

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

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

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

[@xploretheworldwithsrvlondon11]

Please make video on how sql is useful in mis reporting

[@Innozant]

Sql series alag se aane wale hain

[@bansilal8669]

which version excel it is?

[@aabdullahhaasnain7033]

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

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

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

[@xploretheworldwithsrvlondon11]

Please make a video on power bi

[@Innozant]

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

[@vvv1160]

Which version of ms office?

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

[@padmatv1203]

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

[@tanweerabbasabbas649]

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

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

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

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

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

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

[@tejpalsain1507]

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

[@Innozant]

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

[@tejpalsain1507]

@@Innozant thanks

[@sahilsreedharan]

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

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

[@muhammadtariqmayo1630]

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

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

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

[@abhishekshrivastava8500]

Sir please basic and advanced macros p video baniye

[@Innozant]

haan kuch time baad

[@kutaldilip5685]

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

[@Innozant]

Kys issue aa ra hai Dilip ji .kindly tell me

[@SunilYadav-hm6no]

O May God

[@Innozant]

Thanks.. happy Learning 🙏❤️

[@kuldeepgandhi2589]

sir where are u from?

[@Innozant]

Aap Kahan se Hain Kuldeep Ji❤️🙏

[@prajwalshetty2047]

👍

[@debabratachakraborty847]

2016 transform Nehi hai

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

[@chandrabhanmishra1898]

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

[@Innozant]

Which version

[@chandrabhanmishra1898]

@@Innozant MS Office 16 and 365 verson

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

[@sushilaswal8950]

Sir ye excel 2007 me nahi aa rha hai

[@Innozant]

Usme avY nhi h dear

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

[@amritathakur2036]

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

[@Innozant]

Haan..step by step Seekhiye aayega samjh

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

[@tanweerabbasabbas649]

Great🫠🫠🫠🫠

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

Love from karachi🫠🫠🫠🫠🫠