Nice sir Sir aap ye kabhi mt sochna ki meri video ko bahut kam Log dekhte hai . Aapke samjhane ka tareeka bahut mst hai ache se samajh me aata hai .Aapke video ko ek din ache views aayege . Aur ise bahut log dekhege . Plz conti....👍🏻🙏
Dear Sir Thanks for uploading such excellent tutorial. It is a new topic to import text files in power query. I don't know that process of import text files before. Looking forward to some excellent power query tricks and topics. Thanks & Regards Jayanta Bhattacharyya.
Mere pas sbd nhi h, tarif krne ke liye, bs yehi kahunga sir , jis bhi eswr ko mante ho aap wh apki seht bnaye rhe or yese content hme milte rhe..., Thank you from ❤
Please add one step in this video. It is the step of linking Nov 17 data with Dec 17 data. Please accept my congratulations for explaining minor details in such a simple way. I have subscribed your channel. Keep it up.
Quite liked the tutorials given by you about power query. I found it very useful. Easy to understand. Do you also have any tutorial series for power apps & power BI ? Do you have any institute here in Delhi ?
Yes we are running Training institute at New Ashok Nagar Delhi ,You may visit Innozant website for more information or connect with Team Innozant on call/whatsapp
Sir, thank you again for the power query tutorials, they are very well done and you the best at teaching. I also have one question, when I copy query and paste it and change source, it does the same steps but output is incorrect . When I run the same steps again , output is correct. Why would this be the case? Pls advise
Sir, I am new to this series. i have some unstructured text documents. i am not getting different column while loading data in power query. i only find one col. I do not know how to make column in it
sir i really expecting your feedback, what would i learn deeply, i found excel really hard but power query much easier for me , So please sir , give you kind guidence what would i learn excel or power query,
hello Sir, Aap ka samjhane ka tareeka bohat acha hai aap excel ke expert hain aap se poochna tah mujhe excel main open password lagta hai main chata hoon apne office main woh password boss ko batadoon lekin woh password change na ho or na delete ho paye plz sir aap meri ye query solve karden plz...
Yadi aap sumproduct me --(double negative) use karte hain to wo coerce kar deta hai thats means true value jahan milega use 1 aur false ko 0 me convert kr dega lekin yadi array ka dimension same hoga to fine nhi to issue hoga..but asterisk(*) ke case me aisq nhi hoga..ydi array ka dimension alag bhi hoga to sahi chalega..aap sumproduct ke Playlist ko ek baar jaroor dekhen.
Sir jub hum excel ki asi files ko power query kay zaray import kartay hay jis many formula laga ho too import kay bay formula khutam ho jata ha. May chata hoon formula khutam na hoo. Plz guide.
Dear Sir, I'm unable to pull the data from excel binary(.xslb) file to powerquery. but if i tried to excel workbook(.xlsx) file then it easily load the data what's the reason behind on it????? please help
Hello sir, I'm your new subscriber. I need your help. I'm a graduate in BA and right now am pursuing a course in Advanced excel with MIS. Please let me know what are the career scope and what should i learn next. Thank you in advance
@@Innozant Thank you so much sir. Your channel is really aspiring many people's and it's productive too. Am glad to have a quick response from you. Please accept my gratitude 🙏🙏🙏
The best teacher always smiles face, may god bless you.
Thanks.kero learning
Thank you sir ,I learned a lot from your excel's tutorials, and now I started learning Power query Excellent tutorial.
Thanks Sandeep Ji,Happy Learning ❤️🙏
The way you teach things is Excellent sir. Thank you.Keep educating us sir
Thanks Harshitha , Really means a lot today me dear
I am extremely happy to know how to teach you, You are mind blowing, Great to see
Thanks Rohit ji..Happy Learning ❤️👍
we get lots of classes about excel but ur teaching is amzng
Thanks Naseer Sahab ❤️👍
U are the one of the best " TEACHER and ur TEACHING STYLE " I've ever seen in my whole life sir u are the G.O.A.T😊😊😊😊❤❤🎉🎉🎉 " RESPECT "
Really means a lot to me..Keep learning and keep growing dear
@@Innozant thank u sir
Wow,
You are real excel hero Sir🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thanks for your appreciation Pawan.. happy learning
Apka tutorial se kafi helf milti hai
Thanks Pushpendra Ji🙏❤️
fantastic!! Appreciate your compassion and support,the way you teach is amazing.
Thanks dear.Keep learning 👍
Excellent sir. Your method of teaching too much amazing.GOD bless you
Thanks Javed sahab..Happy learning
Superb Sir. You are Great Mentor
Wow.
It is nice idea.
Thanks sir 🙏🙏🙏🙏🙏🙏
Thanks dear.Happy learning
so nice i have no words for you really great work for all ..
Very important series for data wrangling so pls continue it sir
Sure dear...❤❤🙏🙏
Excellent job brother
Thanks Sadiq.Happy learning
Great content and delivery
Wow sir what a explanation thank you so much.
Thanks bro for ur support..It can not be able to learn PQ without you...need help in single cell move left or right ..
waah maza aa agaya,thanks
Nice 👍 Great Sir ji❤
TQ....SIR...JI..🙏🙏🙏🙏🙏🙏🙏
Its awesome sir.. Thanku so much..
Thanks Suvankar ji
You are superb sir
Thanks Ajit ji❤️🙏
Nice sir
Sir aap ye kabhi mt sochna ki meri video ko bahut kam Log dekhte hai . Aapke samjhane ka tareeka bahut mst hai ache se samajh me aata hai .Aapke video ko ek din ache views aayege . Aur ise bahut log dekhege . Plz conti....👍🏻🙏
Thanks for showing trust ,Love and support dear.. Love you all
superb sir 👌👌👌👌👌👌👌👌
Thanks ..
प्रणाम है गुरूजी आपको
Dear Sir
Thanks for uploading such excellent tutorial. It is a new topic to import text files in power query. I don't know that process of import text files before. Looking forward to some excellent power query tricks and topics.
Thanks & Regards
Jayanta Bhattacharyya.
Thanks Jayanta...Have a lovely day ahead..
Mere pas sbd nhi h, tarif krne ke liye, bs yehi kahunga sir , jis bhi eswr ko mante ho aap wh apki seht bnaye rhe or yese content hme milte rhe..., Thank you from ❤
Thanks Amit ji.Keep learning ❤️
Thanks sir 🙏
Yuo are amazing sir
great video
Sir Ur amazing 🙏🙏 thanks a lot🙏🙏
Thanks Abhishek Ji..Happy learning..good night
When we changed the source data for dec file does the previous month data got removed???
Amazing thank u sir
You are the best sir Jee amazing topic thank you so much si
Thanks Vikash ji..happy learning
sir November vale data m change nhi ho rha h refresh krne k baad
You are great
Thanks Kishor..Happy learning dear
Well-done
Thanks Aqeel Sahab...Happy Learning dear
Dear sir, I have a CSV file of a Bank statement with more than 25 pages in it.Do Power query work on it.please suggest what to do.
Why not..You may import it in power query
🙏🙏🙏🙏🙏🙏👍👍👍👍👍👍 Thnq sir
Thanks Gaurav ji
Thanks 🙏
Please add one step in this video. It is the step of linking Nov 17 data with Dec 17 data. Please accept my congratulations for explaining minor details in such a simple way. I have subscribed your channel. Keep it up.
Ok...👍❤️ thanks Rajeev ji for your valuable appreciation ❤️
Quite liked the tutorials given by you about power query. I found it very useful. Easy to understand. Do you also have any tutorial series for power apps & power BI ? Do you have any institute here in Delhi ?
Yes we are running Training institute at New Ashok Nagar Delhi ,You may visit Innozant website for more information or connect with Team Innozant on call/whatsapp
Sir, thank you again for the power query tutorials, they are very well done and you the best at teaching.
I also have one question, when I copy query and paste it and change source, it does the same steps but output is incorrect . When I run the same steps again , output is correct. Why would this be the case? Pls advise
Great, this is not working in xlsx file ?
Sir, I am new to this series. i have some unstructured text documents. i am not getting different column while loading data in power query. i only find one col. I do not know how to make column in it
Syed sahab kindly watch complete playlist step by step
@@Innozant Thanks sir.
sir csv.zip file ko kaise import kare from web se is per video banaeye
Jaise aur file impirt karte hain waise hi process web content download krne ke liye krenge
Please help to load dynamic 365 CRM data in Excel m while connecting with api i am getting some odata error
Sir vlookup me columns or rows ka ek sath use kaise kare
questions share karen with detail query innozantcampus@gmail.com
Sir I had mail my query with details
sir i really expecting your feedback, what would i learn deeply, i found excel really hard but power query much easier for me ,
So please sir , give you kind guidence what would i learn excel or power query,
Excel + Power BI (includes Power query,power pivot & Data Visualization) both
i follwod all of the steps that you showd but can't add the dec file , i don't knwo where is the problem
sir do you have any say .
How can we set automatically column width in power query?
First set word wrap ON then set auto size OFF.It may help you.
Sir kya hum pdf file SE data upload Kar sakte h
Sir My data is not getting properly in excel data . please suggest me.what to do. ??
hello Sir,
Aap ka samjhane ka tareeka bohat acha hai aap excel ke expert hain aap se poochna tah mujhe
excel main open password lagta hai main chata hoon apne office main woh password boss ko batadoon lekin woh password
change na ho or na delete ho paye plz sir aap meri ye query solve karden plz...
Password jinxed Pata joga wo to edit karenge hi Aizaz sahab😁
@@Innozant Sir Tools main jaakar jo General option ata hai woh wahan se hide hojaye aisa vba ke through ho sakta hai kiya
Sir iski practice file kaise milega
Bhai multiplication ka singh jo max product formula ma lagaya hai woh kaisa work karta hai barao comment ma
Kaunse question me..Video link dijiye..phir explain kr deta hu jo bhi aapki query hai...
@@Innozant max aur product formula wala video ma jo multiplication sign jo use hua hai uska bara ma kaisa work karta hai
Yadi aap sumproduct me --(double negative) use karte hain to wo coerce kar deta hai thats means true value jahan milega use 1 aur false ko 0 me convert kr dega lekin yadi array ka dimension same hoga to fine nhi to issue hoga..but asterisk(*) ke case me aisq nhi hoga..ydi array ka dimension alag bhi hoga to sahi chalega..aap sumproduct ke Playlist ko ek baar jaroor dekhen.
sir mere excel 2019 me load and combine ka option hai transform ka option nahi hai to kese karu?
Sir jub hum excel ki asi files ko power query kay zaray import kartay hay jis many formula laga ho too import kay bay formula khutam ho jata ha. May chata hoon formula khutam na hoo. Plz guide.
Firmula khatak kajan hota hai..?rhta hi to h
@@InnozantSir plz start macros.
Dear Sir,
I'm unable to pull the data from excel binary(.xslb) file to powerquery. but if i tried to excel workbook(.xlsx) file then it easily load the data what's the reason behind on it????? please help
Sir ji thank you . Record 10.49 se samaj me nahi aaya.. aap ne data ko kyoo change kiay
Sir apki Power quiet ki video nhi arhi
Eveey week aa ri hai power video
Hello sir, I'm your new subscriber. I need your help. I'm a graduate in BA and right now am pursuing a course in Advanced excel with MIS. Please let me know what are the career scope and what should i learn next. Thank you in advance
Thanks Cynthia ,We welcome you to experience the taste of success.
kindly watch this video it will help you
ua-cam.com/video/Z-ElRbzWL2I/v-deo.html
@@Innozant Thank you so much sir. Your channel is really aspiring many people's and it's productive too. Am glad to have a quick response from you. Please accept my gratitude 🙏🙏🙏
May you live happily ever after. This is my prayer to God
Thanks Ranjit...Happy learning
@@Innozant really sir you are doing a great work.
Sir VBA & MACRO ka series kab daloge..
❤❤❤
SIR plz excel file upload kr dijiye
👌🏼💞
greaatttttt
Sir please aap mujhe apna mobile number dijiye, mujhe aap se kuch excel se relented question puchne hai
👌💐💐🙏
Thanks Tejpal ji
Error aa raha hai
Kya error
Why do you have to put the title of the video in English if virtualy non of the content is spoken in English?
Because excel is in English, we understand both the languages equally
I think you don't know both languages hindi or English that's why you put question
TEXT FILE SEND KARO MUJHE
Download it from master assignment link given in video description
kya bhadhiya chij btayi h sir
logo to sahi bna lo itna weird lag rha I
Kya aisa isme weired hai dear,kindly watch the content of you are really a dive deep learner,Happy learning ❤️
❤️❤️❤️❤️