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 ❤️
@bhagatrishi54542 жыл бұрын
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.
@Innozant2 жыл бұрын
Thanks Bhagat H for your valuable appreciation..Happy learning dear❤️
@muhammadarif8006 Жыл бұрын
Excellent teaching Sir thanks alot.🇵🇰
@kashifqasim8069 Жыл бұрын
I am from Karachi Pakistan I ❤ your way of teaching and guiding. I your explanation is very helpful
@Innozant Жыл бұрын
Thanks Kashif Keep learning
@horrorlovestories3 жыл бұрын
Bahooot khatarnak topic hai sach mein practice karna hoga 😀
@Innozant3 жыл бұрын
Offcourse iska practice krna hoga dear
@anuraggupta80024 ай бұрын
Bahot badiya sir.
@tanweerabbasabbas649 Жыл бұрын
Great way of explaining🥰🥰🥰
@MrAbir063 жыл бұрын
U r really great... Aap ka fan bangaya sir
@Innozant3 жыл бұрын
Thanks Abir aapke is pyare aur valuable comment ke liye 🙏❤
@situsahoo24823 жыл бұрын
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 ❤️
@Innozant3 жыл бұрын
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.🙏❤️
@rashidfaridkhan26642 жыл бұрын
Excellent way of Explaination.. Love it..
@Innozant2 жыл бұрын
Thanks Rashid ..Keep Learning ❤️
@tech_sultanpur3 жыл бұрын
Sir ... Your Teaching Style is Excellent ... This is Different and Most Important Topic ... Thànk you Dear Sir
@Innozant3 жыл бұрын
Thanks Ahsaan...in topics ke assignment Practice bht jaruri hai dear.🙏❤️
@sachinkamble9359 Жыл бұрын
Amazing video , thanks a ton
@rewawaleashu15548 ай бұрын
You are really genius sir
@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
@user-jc6te1vm8v3 жыл бұрын
magician!! that's u r.... simply awesome!! keep the great work going....
@Innozant3 жыл бұрын
Thanks Anand Ji..HV a great day 🙏
@saahilsaahil59123 жыл бұрын
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👍👍
@Innozant3 жыл бұрын
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..🙏❤️
@saahilsaahil59123 жыл бұрын
@@Innozant ok sirji....waise bhi aapki awaz music se bhttttttttttt ziyada achi hai.. ☺☺
@tejpalsain15073 жыл бұрын
Thanks sir. इसका पहली बार सामना हुआ है इसलिए समझने में कठिन लग रहा है। पर लगातार क्लास टू क्लास देखूंगा तो समझ मे आ जायेगा शायद।
@Innozant3 жыл бұрын
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 .
@vishalbhati9123 жыл бұрын
Bahot badiya sir.
@Innozant3 жыл бұрын
Thanks Vishal Ji♥️
@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
@jayantabhattacharyya6283 жыл бұрын
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
@Innozant3 жыл бұрын
Thanks Jayanta.. Practice is must for these topics 🙏❤️
@superNareshg3 жыл бұрын
Superb sir ji. Thank you 🙏
@KuldeepSingh-nq1vi2 жыл бұрын
Super Advanced Video. 😍😍😍
@Innozant2 жыл бұрын
Thanks Kuldeep Ji.Happy Learning ❤️
@msexcelgooglesheet3743 жыл бұрын
Mind Blowing Video Sir ji.
@Innozant3 жыл бұрын
Practice bht jaruri hai dear..👍🙏❤️
@forgotten_friend54062 жыл бұрын
excellent sir
@ramavtarsingh1462 жыл бұрын
Very informatic keep it up
@hemgandhi80872 жыл бұрын
Thank You
@kinghundred3 жыл бұрын
very useful sir
@Innozant3 жыл бұрын
Thanks
@vijaysahal45563 жыл бұрын
Nice sir 👍🏻👍🏻👍🏻👍🏻
@Innozant3 жыл бұрын
❤️
@viratclasses44003 жыл бұрын
Really too good...❤️
@Innozant3 жыл бұрын
Thanks Virat Ji👍❤️
@user-ke2mk6qz9z3 жыл бұрын
Great Sir 👌
@Innozant3 жыл бұрын
Thanks dear ...
@aritramech3 жыл бұрын
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?
@Innozant3 жыл бұрын
If you require corresponding value from another table .. offcourse we need relationship
@bittusatyaa10 ай бұрын
Can you explain with different header
@mohammedfareeduddin56427 ай бұрын
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?
@mohammedfareeduddin56427 ай бұрын
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
@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.
@gauravbhatia79873 жыл бұрын
Thnq sir 🙏
@Innozant3 жыл бұрын
♥️🙏
@deemanshugundhaiya21483 жыл бұрын
Sir NSE 50 chart se pivot charts bana saktey hai?
@andyalejandro95233 жыл бұрын
Fantastic 😍💋 💝💖♥️❤️
@bansilal86693 ай бұрын
which version excel it is?
@mahadevkhandekar13 жыл бұрын
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.
@satishojha62403 жыл бұрын
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 🙏🙏🙏.
@Innozant3 жыл бұрын
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🙂♥️
@padmatv12036 ай бұрын
All procedure I completed as like as you but Pivot report doesn't generate showing data model. Please give me the solution.
@aabdullahhaasnain7033 Жыл бұрын
Each sheet or each workbook has same head. But how will I combine different sheet or workbook without similarities.
@xploretheworldwithsrvlondon113 жыл бұрын
Please make video on how sql is useful in mis reporting
@Innozant3 жыл бұрын
Sql series alag se aane wale hain
@xploretheworldwithsrvlondon113 жыл бұрын
Please make a video on power bi
@Innozant3 жыл бұрын
After power query and powrr pivot..will upload power bi series
@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 🙏
@vvv1160 Жыл бұрын
Which version of ms office?
@TechnobunnY2 жыл бұрын
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
@tanweerabbasabbas649 Жыл бұрын
But i feel you need to make the power query video before this one..😊
@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
@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....
@tejpalsain15073 жыл бұрын
सर कल वाले असाइनमेंट में मैने Pivot tabal और chart बनाया था। बन गया था, और मैने आपको मेल किया था,।
@Innozant3 жыл бұрын
Haan Dekh liya tha Tejpal Ji..good 🙏♥️
@tejpalsain15073 жыл бұрын
@@Innozant thanks
@debaruddhasahachowdhury88689 ай бұрын
Need your help to create pivot table from multiple sheet. I am trying but not happening as like your instruction
@Innozant9 ай бұрын
What problem. You are facing now
@debaruddhasahachowdhury88689 ай бұрын
@@Innozant I have 2year data in multiple workbook. But I unable to create pivot table with using this multiple workbook. Data is too long
@debaruddhasahachowdhury88689 ай бұрын
I need your online help to make this pivot table . My job is under threat for this
@Just_cringe_3 жыл бұрын
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 ?
@Innozant3 жыл бұрын
haan ho sakti hai wo data dikhne me text hoga but hoga nhi .there are several method to convert text to numbers
@Just_cringe_3 жыл бұрын
Bt maine multiply by 1 Or value formula dono try kiye .. wo nhi hua ..
@Just_cringe_3 жыл бұрын
Data GST WEBSITE SE Download ki thi...
@abhishekshrivastava85003 жыл бұрын
Sir please basic and advanced macros p video baniye
@Innozant3 жыл бұрын
haan kuch time baad
@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...
@muhammadtariqmayo16304 ай бұрын
Assalamualaikum sir Main 2 table se Pivot table banata hun lekin is mein relationship Nahin Hota iska Koi HAL bataen.thanks
@jaythechhotuteacher32063 жыл бұрын
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.
@Innozant3 жыл бұрын
Import data hoga office 2013 me..
@jaythechhotuteacher32063 жыл бұрын
@@Innozant Do i need to add power querry, or kindly provide me the steps.
@SunilYadav-hm6no3 жыл бұрын
O May God
@Innozant3 жыл бұрын
Thanks.. happy Learning 🙏❤️
@prajwalshetty20473 жыл бұрын
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
@Innozant3 жыл бұрын
Office 2013 kaunsa hai home edition ya professional
@prajwalshetty20473 жыл бұрын
@@Innozant Microsoft office Professional Plus 2013, and I think crack version.
@rubyyadav64663 жыл бұрын
Sir i m not getting get data option in my excel data
@Innozant3 жыл бұрын
Hi Ruby..Kindly tell mw which Ms office version you are working now..Will guide you
@rubyyadav64663 жыл бұрын
Sir version 10
@kuldeepgandhi25893 жыл бұрын
sir where are u from?
@Innozant3 жыл бұрын
Aap Kahan se Hain Kuldeep Ji❤️🙏
@sahilsreedharan3 жыл бұрын
👌👌👌👌👌👌👌👌👌👌👌👌👌
@poulomidevroy62653 жыл бұрын
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...
@Innozant3 жыл бұрын
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
@kutaldilip56853 жыл бұрын
Mere sheet main Relationship nahi ho paa raha he .. please help
@Innozant3 жыл бұрын
Kys issue aa ra hai Dilip ji .kindly tell me
@riya318333 жыл бұрын
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
@Innozant3 жыл бұрын
Check your data format..is it csv or excel or ither data format?
@prajwalshetty20473 жыл бұрын
👍
@debabratachakraborty8476 ай бұрын
2016 transform Nehi hai
@sushilaswal89503 жыл бұрын
Sir ye excel 2007 me nahi aa rha hai
@Innozant3 жыл бұрын
Usme avY nhi h dear
@RakeshSingh-qo5nd3 жыл бұрын
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.
@Innozant3 жыл бұрын
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-qo5nd3 жыл бұрын
@@Innozant okay sir but maine kal wale video ke liye bola tha multiple sheet 😀
@Innozant3 жыл бұрын
Haan wo Rakesh ek hi workbook me multiple sheet ko merge Kiya humne..ye multiple workbook se Kiya h merge .
@chandrabhanmishra1898 Жыл бұрын
Deta modal में add करने के बाद शो रिपोर्ट फिल्टर पेज बटन काम नही करता
@Innozant Жыл бұрын
Which version
@chandrabhanmishra1898 Жыл бұрын
@@Innozant MS Office 16 and 365 verson
@amritathakur2036 Жыл бұрын
Sir aap shi kh rhe the ki ye ek baar Mai smj ni aaega
@Innozant Жыл бұрын
Haan..step by step Seekhiye aayega samjh
@traditionalmaithilisong60193 жыл бұрын
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
@DeepakSharma-fl5yf3 жыл бұрын
Sir Ji, I have MS Office 2013 and Transform data is not showing in excel.