@@learnwithlokeshlalwaniSir meri aik problem hai because I'm from Pakistan so jo log peopleperhour pai account banate hain but Pakistan se banaye gaye account accept nahi hote Sir why? Please help me
A small correction. After you combine file and transform, in your 'sample file', select some other file other than 'first file', it is not showing data after book1. Select book 10 as it has 2 pages in pdf.
Hello sir mein odisha se hun aur mein jobless hun bohat jaga try ki kuch nahin Mila aur apka video dekh kar kush ho gayi sir mujhe v online paisa kamana he Longo ko dikhana hai apse request hai ki aap mujhe sikha kar skill excel ka ta ki mein online earning karsaku sir plz
convert PDF files to Excel individually and organize them in a designated folder. I carefully execute each step and verify the source name in the first column. Although all twelve Excel files appear, only one book is populated with data. The remaining eleven books are blank. Kindly advise on a solution to this issue or provide a step-by-step resolution if anyone has previously resolved a similar power query.
Dear sir, this trick is not completely working. When we are selecting first pdf file as sample file, then it is only fetching data of first pdf with headers. When we tried to select 10th pdf, that's working pretty good. All data is loading properly from all pdfs but from first page only and not from the second page and so on and also header of first pdf file is not there but that's not the issue. The main concern is to fetch data properly from all pdfs from each page. Please create a revised video for this. Well video is amazing..Thanks
When I click on the link for practice file, I don't fiind the "File" option anywhere. In a box on the right side, it says "you don't have permission to view sharing information for this item".
I tried with voters I'd list. Didn't work properly. Can you please do video on how to convert pdf voter list to Excel properly please this will be very good learning video us
I convert PDF files to Excel individually and organize them in a designated folder. I carefully execute each step and verify the source name in the first column. Although all twelve Excel files appear, only one book is populated with data. The remaining eleven books are blank. Kindly advise on a solution to this issue or provide a step-by-step resolution if anyone has previously resolved a similar power query.
@@learnwithlokeshlalwanisir will you like to send me a excel sheet of a strong room of a bank where cash available of different denominations on a 14 cupboards. To balance withdrawal and deposit of daily cash
Join my free webinar. Here you will get in depth information about freelancing. And all your queries will be answered also. Here is the link: event.webinarjam.com/register/13/m4851s2
i as you can see have missed your masterclass and am your new subscriber, is there any way that i can still get your excel ebook? i would be truly thankful
hello sir, 2021 excel 365 version , but i have still problem in power query , when i want to convert file's folder from pdf into Excel following your process i found "NULL" some rows, may you solve this problem through you video? thank you
Yes, it works. Join my free webinar to get in depth idea, here all your doubts will be cleared and your questions will be answered. Here is the link: event.webinarjam.com/register/13/m4851s2
Sir ek baat samajhme nahi aarahi ke jab ye kaam aadhe ghante me hi sakta hai to phir kaam karne wala one hour ka charge 861 aur delivery in 2 days kyun daalte hain. Pls samjhaiye
Aaj kal kisi ko kuchh nhi aata to wo TH-cam ki video dekhkr seekh leta hai kyuki TH-cam pr har tarha ka video available hai To clients bhi apki video dekhkr seekh lega usko kisi ko kaam dena hi nhi padega to isse ham kaise paise earn kr payenge
Clients often choose to work with freelancers for various reasons, even for seemingly simple tasks. Freelancers offer a flexible and cost-effective solution that can be tailored to the specific needs of the project. They bring specialized skills and expertise, ensuring high-quality work. Additionally, freelancers can often deliver quicker turnaround times due to their focused dedication on the project at hand.
Sir mere excel 2019 me PDF file ka option nhi dikh raha hai or support ek sath sab , even ki me from web wala option use kiya but ek file se jada nhi ho raha hai
Dear Sir, I working as a accountant in automobile industryand i have been seeing your videos for so many months. Request you to kindly suggest me to earn money as a second salary.
I'm glad to hear that you've been finding value in my videos. Leveraging Excel skills for extra income is a great idea. Consider offering freelance services like financial analysis, data entry, or creating customized Excel templates. Online platforms can connect you with clients seeking your expertise. You could also provide Excel training to individuals or groups. Best of luck in boosting your earnings!
among the 12 file that you have given to extract in excel , only the first file is being extracted and all the rest are showing errors, i mean null. What is the solution?
Here is the link to join my free webinar: event.webinarjam.com/register/13/m4851s2 Here you will get in-depth idea of basic to advanced level Excel course
@@learnwithlokeshlalwani This thing you should mention in your video. I found out some tips from other video channels regarding installing Power Query in old MS Excel like 2010, 2013 ,2016.. this also you can mention in your video. Your videos are partially informative. I think you are charging more for detailed information which is obvious. No problem. Thank you for your reply.
A. O a sir i am from pakistan I also wana following you step by step but When I click on the link for practice file, I don't fiind the "File" option anywhere. In a box on the right side, it says "you don't have permission to view sharing information for this item".
Sir, Good afternoon. I'm from Bangladesh. After watch this video i have done my practice but only first page is ok other all pages Showed but place of data its shows "nulll". Will you please help me on it?
Sir,infect,all data are not comming in the the new sheet only page 1 data are comming according the process you have explained in the video but rest of all files showing null ,sir what is the problem I am facing to extract all files dara
Sir aap Excell ka konsa software use karte hai, hamare me 'Get data' ka option nahi hai usme to 'Acces form' wala option hai sir bataye kon sa year version Kiya àapne
FREE Live Masterclass. Register Now. 🔥🔥
event.webinarjam.com/register/13/m4851s2
Sir
Future
Sir please tell me your inst id
Good
I wants to register but register now is not active after enter data
Hello Lokesh, This is Shahid from Pakistan, a big fan of u and u r a true excel guru. From now on, you are my guru jee.
Thank you so much for your comment.
I am pakistani, MashaAhlla best techer in youtube
Thank you so much for your comment.
Sir, apki videos sai knowledge bohat milta hai. Thanks
Most welcome
Sir aap kanha se hai@@learnwithlokeshlalwani
I am from pakistan and much appreciated this effort
Thank you.
apki videos se bht jayada help milegi aab mujhe family financial support mai or apke webinar se bhi
Www Ooooloooooo9osoooooooooooooooooooooololsoooooooo9lspooooooooo9ooo9oooplo😊olooooo😊ooo😊#😊#sspol9s#
Allah SWT bless you and your beloved ones materially and spiritually Ameen
Thank you so much for your blessing.
Take love from Bangladesh ❤❤❤❤
I'm your new subscriber and I got a lot of knowledge
Thanks for subbing
Sir ap boht ache se explain krte hn thank you so much first time comment kr rhi ho
Thank you so much for your comment.
@@learnwithlokeshlalwaniSir meri aik problem hai because I'm from Pakistan so jo log peopleperhour pai account banate hain but Pakistan se banaye gaye account accept nahi hote Sir why? Please help me
thank you sir apki video dekh kar ab main monthly 20000 se 30000 hazar rupe kama raha hu
How bro please explain it
How bro?
Pesa kmae ns kmae lekin tricks sikhne ko kmal k milte hai💪😎👌
Thanks sir very useful, informative and explained very nicely once again thanks
Thank you so much for your comment.
Sir I have watched your this and other informative videos
And
Subscribed your channel for live class on 20-3-24 .
A small correction. After you combine file and transform, in your 'sample file', select some other file other than 'first file', it is not showing data after book1. Select book 10 as it has 2 pages in pdf.
It worked after selecting book 10.
can you tell me how it worked I have also selected all the files but getting the same error, kindly can you brief. @@shubhammeshram8504
yes sir , mne bi prectice kri h and book 1 k baad baki PDF ka data show nhi ho rha h
How to select
@@Mistermac880 same problem
Thank you very much for sharing very useful and informative
Great viedo love from Pakistan🇵🇰
Thank you for your comment.
Which version of excel you used for this work.
Office 365
sir maine apke webinar ke liye registration kiya hai aaj rat 8 baje ke liye
Amazing videos❤❤
Glad you like them!
Thanks a lot Sir .new subscriber
Great 👍🏻👍🏻👍🏻👍🏻👍🏻
Which office version supports this function, i have 2016 in which PDF option is not available
Hello sir mein odisha se hun aur mein jobless hun bohat jaga try ki kuch nahin Mila aur apka video dekh kar kush ho gayi sir mujhe v online paisa kamana he Longo ko dikhana hai apse request hai ki aap mujhe sikha kar skill excel ka ta ki mein online earning karsaku sir plz
Join my free webinar. Here all your doubts will be cleared. Here is the link: event.webinarjam.com/register/13/m4851s2
Wooow so so good trick I learnt first time this one
Super excited to try this one 🎉
Great 👍
Hi
App ka link kaha pa ha????
did you get work tell m
if yes so reply
Love you bhaiya ❤
Liked 👍 and subscribed 😊
Thanks for subbing!
Sir Ek video Clients se conversation ka information ka banaye Please?😢
Sir 1 video freelance pr profile banane ka banaiye
Please......
Sir / bhaiya bohot bohot achhe tarike se samjhate ho aap thank you so much ❤ i hope aapki videos ki wajah se mai earn kar paungi
Thank you so much for your comment. Keep watching!
convert PDF files to Excel individually and organize them in a designated folder. I carefully execute each step and verify the source name in the first column. Although all twelve Excel files appear, only one book is populated with data. The remaining eleven books are blank. Kindly advise on a solution to this issue or provide a step-by-step resolution if anyone has previously resolved a similar power query.
Same problem
Im your new subscriber 😊
Thanks for subbing
You are amazing Sir.
Did anyone address you by R Madhavan.?
You look similar to him❤
Good information 👍
Thanks
Apka learning platform pe hindi me hota to bahut achha hota hai
good info and thanks for cooperation
Always welcome
@@learnwithlokeshlalwani
Sir job nahi milti
Skill hai fir bhi
@@learnwithlokeshlalwani
Last two years try kar raha hu ak bhi project nahi mila
sir app ki video se aacha anubhav milta he par job ka bhi setting karao sir
One video on CSV file cleaning
Sure, will make a video in future.
Shukria sir ❤ mn ny ab tk jitny b excel or tips or tricks seekhany waly youtubers dekhy hn ap un sb sy best hn
Before convert , kindly show pdf file what type of data u have table data only convert pdf to excel in this pattern..
Dear sir, this trick is not completely working. When we are selecting first pdf file as sample file, then it is only fetching data of first pdf with headers. When we tried to select 10th pdf, that's working pretty good. All data is loading properly from all pdfs but from first page only and not from the second page and so on and also header of first pdf file is not there but that's not the issue. The main concern is to fetch data properly from all pdfs from each page. Please create a revised video for this. Well video is amazing..Thanks
Make a video of the steps you are doing and send it to ask@nurturetechacademy.in
When I click on the link for practice file, I don't fiind the "File" option anywhere. In a box on the right side, it says "you don't have permission to view sharing information for this item".
I tried with voters I'd list. Didn't work properly. Can you please do video on how to convert pdf voter list to Excel properly please this will be very good learning video us
Mast❤🐺
I convert PDF files to Excel individually and organize them in a designated folder. I carefully execute each step and verify the source name in the first column. Although all twelve Excel files appear, only one book is populated with data. The remaining eleven books are blank. Kindly advise on a solution to this issue or provide a step-by-step resolution if anyone has previously resolved a similar power query.
Hey, Tauseef you can get the Solution
🙃👍👍 I am your new subscriber..
Thanks for the sub
freelancing ka liya excel ka premium lena zaroori ha kiya🤔🤔
Best knowledge Video
Thank you so much for your comment
Sir me bhi yhi Work krta hun In kuwait city ❤
Thanks for power query knowledge.
It's my pleasure
Sir kya ham jpg se excel sheet me convert kar sakte h
I tried, but it is extracting data from Book 1 only. Though other book nmEA re ahowing in 1st column, their respective data are not combined.
help full your all videos
Thanku so much for ur information sir
Most welcome
Amazing video sir. Thank you so much sir for this video❤
Keep watching
@@learnwithlokeshlalwanisir will you like to send me a excel sheet of a strong room of a bank where cash available of different denominations on a 14 cupboards.
To balance withdrawal and deposit of daily cash
Sir g Amazing Trick❤❤❤ but guide us in which Excel version (year)???? Thanxxxx
Thank you so much for your comment. Its MS Office 365
Thanxxxxx A lot
Sir how I can update power BI and power query in my get data tab
kon si generation excel download kare sir
Nice information bro
Most welcome.
Subscribed sir
Thank you for valuable information
Thanks and welcome
Sir how to start freelancing plz make video for beginners plzzzzzzzzzzzzzz
Join my free webinar. Here you will get in depth information about freelancing. And all your queries will be answered also. Here is the link: event.webinarjam.com/register/13/m4851s2
Sir which Excel version has this get file from pdf function.
i as you can see have missed your masterclass and am your new subscriber, is there any way that i can still get your excel ebook? i would be truly thankful
Please email at ask@nurturetechacademy.in
hello sir, 2021 excel 365 version , but i have still problem in power query , when i want to convert file's folder from pdf into Excel following your process i found "NULL" some rows, may you solve this problem through you video? thank you
Sir ap kon se excel use karta hai
Thanks a lot for valuable information.
Glad it was helpful!
Sir it look likes everything like magic .Do it really works?
Yes, it works. Join my free webinar to get in depth idea, here all your doubts will be cleared and your questions will be answered. Here is the link: event.webinarjam.com/register/13/m4851s2
Kiya ye work Google sheet ke through ho sakta hai ?
Sir ek baat samajhme nahi aarahi ke jab ye kaam aadhe ghante me hi sakta hai to phir kaam karne wala one hour ka charge 861 aur delivery in 2 days kyun daalte hain.
Pls samjhaiye
Aaj kal kisi ko kuchh nhi aata to wo TH-cam ki video dekhkr seekh leta hai kyuki TH-cam pr har tarha ka video available hai
To clients bhi apki video dekhkr seekh lega usko kisi ko kaam dena hi nhi padega to isse ham kaise paise earn kr payenge
Clients often choose to work with freelancers for various reasons, even for seemingly simple tasks. Freelancers offer a flexible and cost-effective solution that can be tailored to the specific needs of the project. They bring specialized skills and expertise, ensuring high-quality work. Additionally, freelancers can often deliver quicker turnaround times due to their focused dedication on the project at hand.
Thank you so much sir 😊
Most welcome
sir mere pass office 2016 isme ye feature nahi araha hai ...aap konsa version use karte ho?
Sir mere excel 2019 me PDF file ka option nhi dikh raha hai or support ek sath sab , even ki me from web wala option use kiya but ek file se jada nhi ho raha hai
Hello Lokesh,
how can I use this trick in windows 10, or higher version? Please suggest
ap kon saversion use kar rhay ha ms office ka
I am using MS Office 365
@@learnwithlokeshlalwani ya option free ma kasay milay ga
I tried this, the pdfs should be very clear or else it will not detect the table
Dear Sir,
I working as a accountant in automobile industryand i have been seeing your videos for so many months.
Request you to kindly suggest me to earn money as a second salary.
I'm glad to hear that you've been finding value in my videos. Leveraging Excel skills for extra income is a great idea. Consider offering freelance services like financial analysis, data entry, or creating customized Excel templates. Online platforms can connect you with clients seeking your expertise. You could also provide Excel training to individuals or groups. Best of luck in boosting your earnings!
I can't register for master class from Bangladesh. Please help me
Here is the link to register: event.webinarjam.com/register/13/m4851s2
Sir mere Excel 2019 me combine n transform ka option nahi hai
i've developed the tool for the same. that took less than 10 sec to convert any pdf to excel.
Detail about tool plese
among the 12 file that you have given to extract in excel , only the first file is being extracted and all the rest are showing errors, i mean null.
What is the solution?
we didn't recognize file format error aa jata hy. please help to resolve
Payment kese recieve hoga account me aur pta kese chalega ki kaam aaya h es related video bnayo aur account kese bnaye
Sir please ek advance Excel course laiyee
Here is the link to join my free webinar: event.webinarjam.com/register/13/m4851s2
Here you will get in-depth idea of basic to advanced level Excel course
What if the columns of files are not equal? We will have to use the power query in detail then?
How to do it in the MS Excel 2010 version? Please give information for all.
I will suggest to use the latest version of excel. So that you can use all the latest tips and tricks on excel.
@@learnwithlokeshlalwani This thing you should mention in your video. I found out some tips from other video channels regarding installing Power Query in old MS Excel like 2010, 2013 ,2016.. this also you can mention in your video. Your videos are partially informative. I think you are charging more for detailed information which is obvious. No problem. Thank you for your reply.
I wish I can earn money with your idea in fucher 😂.
Lol😂
Not possible 😂
Not Possible
😂 HAHAHA....INFUTURE....
Why we are not getting work after Watching your video
Sir mera combine file diler box open nhi hora hai
excel sheet can not seeing to (get data option) button. I don't know why it's not showing the tab.please tell me how can solve
A. O a sir i am from pakistan
I also wana following you step by step but
When I click on the link for practice file, I don't fiind the "File" option anywhere. In a box on the right side, it says "you don't have permission to view sharing information for this item".
Sir, Good afternoon. I'm from Bangladesh. After watch this video i have done my practice but only first page is ok other all pages Showed but place of data its shows "nulll". Will you please help me on it?
Sir kindly excel download krnay ka link day dain
Sir,infect,all data are not comming in the the new sheet only page 1 data are comming according the process you have explained in the video but rest of all files showing null ,sir what is the problem I am facing to extract all files dara
Sir power bi tool excel ke konse version me work karta hai aur ise ham free download kaha se kare ispe bhi video banaye
Sir ji... Ek naya youtuber dekha gya h pawan lalwani in the field of data analytics....kya aapka Bhai hai?
Is it Excel 2010 or 2016?
Sir aap Excell ka konsa software use karte hai, hamare me 'Get data' ka option nahi hai usme to 'Acces form' wala option hai sir bataye kon sa year version Kiya àapne
MS Office 365
Thank you sir😊
Most welcome
Transfer data option not shown Excel 2016 version
It shows edit option
Which Excel version you are using please, because in data, i did not find get data option like you are showing, please guide me
I am using MS Office 365
❤Sir ji Very Nice❤
Thanks
Background mein telescope kaun sa hain?
sir mujh sy Ms excel ki orignel file install nhi ho rahi hai plz help kr dy