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.
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..🙏🤗🙏
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 .
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👍👍
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..🙏❤️
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 ❤️
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.🙏❤️
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 😊
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
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?
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.
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?
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
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
@@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.
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
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🙂♥️
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.
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 ?
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
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...
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
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
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.
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..🙏♥️♥️🙏🙏
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
You are the best teacher
bahut bahut important concept sir , Thanks..!
❤️👍
Great way of explaining🥰🥰🥰
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.
Thanks Bhagat H for your valuable appreciation..Happy learning dear❤️
Excellent teaching Sir thanks alot.🇵🇰
Lean a lot from you sir keep teaching
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..🙏🤗🙏
Thanks Anjali..Happy Learning ❤️
Sir, please make a basic SQL tutorial to advance. Your teaching is amazing.
Bahooot khatarnak topic hai sach mein practice karna hoga 😀
Offcourse iska practice krna hoga dear
Bahot badiya sir.
I am from Karachi Pakistan I ❤ your way of teaching and guiding. I your explanation is very helpful
Thanks Kashif Keep learning
U r really great... Aap ka fan bangaya sir
Thanks Abir aapke is pyare aur valuable comment ke liye 🙏❤
Excellent way of Explaination.. Love it..
Thanks Rashid ..Keep Learning ❤️
Thanks sir.
इसका पहली बार सामना हुआ है इसलिए समझने में कठिन लग रहा है।
पर लगातार क्लास टू क्लास देखूंगा तो समझ मे आ जायेगा शायद।
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 .
magician!! that's u r.... simply awesome!! keep the great work going....
Thanks Anand Ji..HV a great day 🙏
Bahot badiya sir.
Thanks Vishal Ji♥️
Sir ... Your Teaching Style is Excellent ... This is Different and Most Important Topic ... Thànk you Dear Sir
Thanks Ahsaan...in topics ke assignment Practice bht jaruri hai dear.🙏❤️
Very informatic keep it up
You are really genius sir
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👍👍
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..🙏❤️
@@Innozant ok sirji....waise bhi aapki awaz music se bhttttttttttt ziyada achi hai.. ☺☺
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 ❤️
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.🙏❤️
Mind Blowing Video Sir ji.
Practice bht jaruri hai dear..👍🙏❤️
You explained it so wonderfully. You helped me a lot to learn. You are a fantastic teacher.
Thanks Neeta.. Really means a lot to me dear
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 😊
Thanks dear aapke valuable appreciation ke liye ..God bless You .Keep learning and exploring
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
Thanks Jayanta.. Practice is must for these topics 🙏❤️
Amazing video , thanks a ton
Superb sir ji.
Thank you 🙏
Super Advanced Video. 😍😍😍
Thanks Kuldeep Ji.Happy Learning ❤️
great sir
very useful sir
Thanks
Nice sir 👍🏻👍🏻👍🏻👍🏻
❤️
excellent sir
Really too good...❤️
Thanks Virat Ji👍❤️
Thank You
Great Sir 👌
Thanks dear ...
Fantastic 😍💋 💝💖♥️❤️
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?
If you require corresponding value from another table .. offcourse we need relationship
Can you explain with different header
Thnq sir 🙏
♥️🙏
Sir NSE 50 chart se pivot charts bana saktey hai?
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.
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?
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
Please make video on how sql is useful in mis reporting
Sql series alag se aane wale hain
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
which version excel it is?
Each sheet or each workbook has same head. But how will I combine different sheet or workbook without similarities.
Sir I have a question regarding 2019 data which has connection only then what is its use? If it is not mention in relationship.
Again recheck the videos ,wo maine situation btaya hai ki kuch data set ka sirf connection ki hi requirements hoti h
@@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.
Please make a video on power bi
After power query and powrr pivot..will upload power bi series
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
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 🙏🙏🙏.
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🙂♥️
Which version of ms office?
All procedure I completed as like as you but Pivot report doesn't generate showing data model. Please give me the solution.
But i feel you need to make the power query video before this one..😊
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...
Sir,if we are using old version 2007,.to usme possible hai kya..relationship concept
Update kar lijiye excel 2016 .. available hain net par free version Anjali
@@Innozant ok sir 🙏
Need your help to create pivot table from multiple sheet. I am trying but not happening as like your instruction
What problem. You are facing now
@@Innozant I have 2year data in multiple workbook. But I unable to create pivot table with using this multiple workbook. Data is too long
I need your online help to make this pivot table . My job is under threat for this
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.
Import data hoga office 2013 me..
@@Innozant Do i need to add power querry, or kindly provide me the steps.
Sir....
How to apply conditional formatting on Pivot table
Video me cover kiya hai playlist me
@@Innozant sir maine bahut dhoondha pivot table me condiotional formatting kaise lgate hai but nahi mila....
सर कल वाले असाइनमेंट में मैने Pivot tabal और chart बनाया था। बन गया था, और मैने आपको मेल किया था,।
Haan Dekh liya tha Tejpal Ji..good 🙏♥️
@@Innozant thanks
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 ?
haan ho sakti hai wo data dikhne me text hoga but hoga nhi .there are several method to convert text to numbers
Bt maine multiply by 1
Or value formula dono try kiye .. wo nhi hua ..
Data GST WEBSITE SE Download ki thi...
👌👌👌👌👌👌👌👌👌👌👌👌👌
Assalamualaikum sir
Main 2 table se Pivot table banata hun lekin is mein relationship Nahin Hota iska Koi HAL bataen.thanks
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
Office 2013 kaunsa hai home edition ya professional
@@Innozant Microsoft office Professional Plus 2013, and I think crack version.
Sir i m not getting get data option in my excel data
Hi Ruby..Kindly tell mw which Ms office version you are working now..Will guide you
Sir version 10
Sir please basic and advanced macros p video baniye
haan kuch time baad
Mere sheet main Relationship nahi ho paa raha he .. please help
Kys issue aa ra hai Dilip ji .kindly tell me
O May God
Thanks.. happy Learning 🙏❤️
sir where are u from?
Aap Kahan se Hain Kuldeep Ji❤️🙏
👍
2016 transform Nehi hai
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...
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
Deta modal में add करने के बाद शो रिपोर्ट फिल्टर पेज बटन काम नही करता
Which version
@@Innozant MS Office 16 and 365 verson
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
Check your data format..is it csv or excel or ither data format?
Sir ye excel 2007 me nahi aa rha hai
Usme avY nhi h dear
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.
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..🙏♥️♥️🙏🙏
@@Innozant okay sir but maine kal wale video ke liye bola tha multiple sheet 😀
Haan wo Rakesh ek hi workbook me multiple sheet ko merge Kiya humne..ye multiple workbook se Kiya h merge .
Sir aap shi kh rhe the ki ye ek baar Mai smj ni aaega
Haan..step by step Seekhiye aayega samjh
Sir Ji, I have MS Office 2013 and Transform data is not showing in excel.
Import data option hoga office 13 me bhi dear
Great🫠🫠🫠🫠
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
Love from karachi🫠🫠🫠🫠🫠