I'm your new subscriber and I got a lot of knowledge
@learnwithlokeshlalwani10 ай бұрын
Thanks for subbing
@rijafatima781 Жыл бұрын
Sir ap boht ache se explain krte hn thank you so much first time comment kr rhi ho
@learnwithlokeshlalwani Жыл бұрын
Thank you so much for your comment.
@rijafatima781 Жыл бұрын
@@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
@aakashr8063 Жыл бұрын
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.
@shubhammeshram8504 Жыл бұрын
It worked after selecting book 10.
@arsalankhan7069 Жыл бұрын
can you tell me how it worked I have also selected all the files but getting the same error, kindly can you brief. @@shubhammeshram8504
@Mistermac88010 ай бұрын
yes sir , mne bi prectice kri h and book 1 k baad baki PDF ka data show nhi ho rha h
@raneepatnaik46692 ай бұрын
How to select
@samarsx21 күн бұрын
@@Mistermac880 same problem
@nishabhatia35993 ай бұрын
Thanks sir very useful, informative and explained very nicely once again thanks
@learnwithlokeshlalwani3 ай бұрын
Thank you so much for your comment.
@GovindLectures Жыл бұрын
Which version of excel you used for this work.
@learnwithlokeshlalwani Жыл бұрын
Office 365
@muhammadalamgir28518 ай бұрын
Sir I have watched your this and other informative videos And Subscribed your channel for live class on 20-3-24 .
@KAILASHBHATIA-kf4mu3 ай бұрын
Thank you very much for sharing very useful and informative
@ROHANSBMM Жыл бұрын
sir maine apke webinar ke liye registration kiya hai aaj rat 8 baje ke liye
@vikingviralrelaxing478 Жыл бұрын
Sir Ek video Clients se conversation ka information ka banaye Please?😢
@mayuriatmande1943 Жыл бұрын
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
@learnwithlokeshlalwani Жыл бұрын
Thank you so much for your comment. Keep watching!
@parasfcommandopritam73593 ай бұрын
Sir 1 video freelance pr profile banane ka banaiye Please......
@mdmohsinalam31478 ай бұрын
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.
@andmilestogobeforeisleep44153 күн бұрын
Same problem
@nileshranade42049 ай бұрын
Thanks a lot Sir .new subscriber
@biswaranjanswain8640 Жыл бұрын
Apka learning platform pe hindi me hota to bahut achha hota hai
@MahendraPatel-d7f Жыл бұрын
sir app ki video se aacha anubhav milta he par job ka bhi setting karao sir
@naulakhanaulakha-c1v11 ай бұрын
Great viedo love from Pakistan🇵🇰
@learnwithlokeshlalwani11 ай бұрын
Thank you for your comment.
@Leo-gc3hq Жыл бұрын
Ee video dekh k aab company wala ee sab aab khud hi kar liyoo ga
@nasirkhans59698 ай бұрын
Sir ap kon se excel use karta hai
@rythu_king Жыл бұрын
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
@zunaidalam5532 Жыл бұрын
You are amazing Sir. Did anyone address you by R Madhavan.? You look similar to him❤
@Dj-jt1mx Жыл бұрын
Before convert , kindly show pdf file what type of data u have table data only convert pdf to excel in this pattern..
@hiral_kadavla Жыл бұрын
Wooow so so good trick I learnt first time this one Super excited to try this one 🎉
@learnwithlokeshlalwani Жыл бұрын
Great 👍
@saniakanwal7330 Жыл бұрын
Hi
@saniakanwal7330 Жыл бұрын
App ka link kaha pa ha????
@m.kumarmanmohan3548 Жыл бұрын
did you get work tell m
@m.kumarmanmohan3548 Жыл бұрын
if yes so reply
@indian-gamer8340 Жыл бұрын
I wish I can earn money with your idea in fucher 😂.
@Tempo-Turbic-ir2030. Жыл бұрын
Lol😂
@akashsong6284 Жыл бұрын
Not possible 😂
@realthor8548 Жыл бұрын
Not Possible
@Tripmusic786 Жыл бұрын
😂 HAHAHA....INFUTURE....
@nirajmanger2537 Жыл бұрын
Why we are not getting work after Watching your video
@atnaturesbeautyshow6958 Жыл бұрын
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
@learnwithlokeshlalwani Жыл бұрын
Join my free webinar. Here all your doubts will be cleared. Here is the link: event.webinarjam.com/register/13/m4851s2
@GBtechrepublic10 ай бұрын
Which office version supports this function, i have 2016 in which PDF option is not available
@tauseefsubzwari8815 Жыл бұрын
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.
@mdmohsinalam31478 ай бұрын
Hey, Tauseef you can get the Solution
@inonenews9 ай бұрын
Love you bhaiya ❤
@ASADALI-jl5kp Жыл бұрын
One video on CSV file cleaning
@learnwithlokeshlalwani Жыл бұрын
Sure, will make a video in future.
@ASADALI-jl5kp Жыл бұрын
Shukria sir ❤ mn ny ab tk jitny b excel or tips or tricks seekhany waly youtubers dekhy hn ap un sb sy best hn
@supratim12345 Жыл бұрын
Hello Lokesh, how can I use this trick in windows 10, or higher version? Please suggest
@myimran Жыл бұрын
Hello Sir, Please address the ways to approach small businesses as you described in this video in LinkedIn?
@funfact_adventures Жыл бұрын
Amazing video sir. Thank you so much sir for this video❤
@learnwithlokeshlalwani Жыл бұрын
Keep watching
@AliAli-y9h5c Жыл бұрын
@@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
@rafickmulani711 Жыл бұрын
@learnwithlokeshlalwani what if PDFs are not sorted? Data are printed ups and downs then what??😮 I haven't downloaded your given PDFs. It's just my random question.
@ghulamkazim9244 Жыл бұрын
Sir g Amazing Trick❤❤❤ but guide us in which Excel version (year)???? Thanxxxx
@learnwithlokeshlalwani Жыл бұрын
Thank you so much for your comment. Its MS Office 365
@ghulamkazim9244 Жыл бұрын
Thanxxxxx A lot
@top-five-facts6 ай бұрын
help full your all videos
@azhariqbal1390 Жыл бұрын
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".
@techparadize2221 Жыл бұрын
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
@learnwithlokeshlalwani Жыл бұрын
Make a video of the steps you are doing and send it to ask@nurturetechacademy.in
@yhharishadyar7843 Жыл бұрын
Thanks for power query knowledge.
@learnwithlokeshlalwani Жыл бұрын
It's my pleasure
@indo_tube Жыл бұрын
Subscribed sir Thank you for valuable information
@learnwithlokeshlalwani Жыл бұрын
Thanks and welcome
@gunrajsingh5559 Жыл бұрын
Great 👍🏻👍🏻👍🏻👍🏻👍🏻
@NivaDeka-u9x4 ай бұрын
freelancing ka liya excel ka premium lena zaroori ha kiya🤔🤔
@Noman_Ali_1 Жыл бұрын
Who is earnings from this trick so i start
@bhagyajyothi7655 Жыл бұрын
Thanku so much for ur information sir
@learnwithlokeshlalwani Жыл бұрын
Most welcome
@aeibee189 Жыл бұрын
Aaj kal kisi ko kuchh nhi aata to wo KZbin ki video dekhkr seekh leta hai kyuki KZbin 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
@learnwithlokeshlalwani Жыл бұрын
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.
@MuhammadImran-bf5si5 ай бұрын
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
@therealn17302 ай бұрын
I get this message "We didn't recognise the format of your first file. please filter the list of files so it contains only supported files" when converting. Yes excel 2024
@manishagrawal4930 Жыл бұрын
Sir it look likes everything like magic .Do it really works?
@learnwithlokeshlalwani Жыл бұрын
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
@reenaroy933 Жыл бұрын
Thanks a lot for valuable information.
@learnwithlokeshlalwani Жыл бұрын
Glad it was helpful!
@RushiPatil39045 ай бұрын
Amazing videos❤❤
@learnwithlokeshlalwani5 ай бұрын
Glad you like them!
@PralhadNilange Жыл бұрын
It is very important to earning online monet
@buzzleafshorts Жыл бұрын
Im your new subscriber 😊
@learnwithlokeshlalwani Жыл бұрын
Thanks for subbing
@RajaTyagi456 Жыл бұрын
Sir ji... Ek naya youtuber dekha gya h pawan lalwani in the field of data analytics....kya aapka Bhai hai?
@biswajitmandal6520Ай бұрын
kon si generation excel download kare sir
@DailytonicGK.1 Жыл бұрын
Sir how to start freelancing plz make video for beginners plzzzzzzzzzzzzzz
@learnwithlokeshlalwani Жыл бұрын
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
@ganeshgowda6617 Жыл бұрын
Sir which Excel version has this get file from pdf function.
@worldexplore98748 ай бұрын
Kiya ye work Google sheet ke through ho sakta hai ?
@parthplays2142 Жыл бұрын
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.
@AwaisAhmad-s8r Жыл бұрын
i am unbale to understand that which version of ms excel is best for meeting all day by day requirements. Kindly suggest best and latest version MS Office. waiting for your kind reply.
@learnwithlokeshlalwani Жыл бұрын
Use Office 365 so that you can use the latest functions.
@mynameislove0252 Жыл бұрын
Sir please ek advance Excel course laiyee
@learnwithlokeshlalwani Жыл бұрын
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
@aqsabashir363 Жыл бұрын
🙃👍👍 I am your new subscriber..
@learnwithlokeshlalwani Жыл бұрын
Thanks for the sub
@monu852411 ай бұрын
Sir power bi tool excel ke konse version me work karta hai aur ise ham free download kaha se kare ispe bhi video banaye
@being_humann Жыл бұрын
Good information 👍
@learnwithlokeshlalwani Жыл бұрын
Thanks
@jyotishasharma2544 Жыл бұрын
Sir freelancer se kuch question leke plesse uske answer de dijiye.. Clients ko kya chahiye Jisse project rejects na ho Data entry, copy paste se related
@muhammedfarooq7207 Жыл бұрын
Mashallah, Tabarakallah
@creativeideasbyreenapawar6462 Жыл бұрын
Sir aap ka combination plan bahot hi amazing h thank you so much 🙏🙏🙏🙏🙏
@learnwithlokeshlalwani Жыл бұрын
Thank you so much for your comment.
@faisalfaraz3141 Жыл бұрын
good info and thanks for cooperation
@learnwithlokeshlalwani Жыл бұрын
Always welcome
@vkp229 Жыл бұрын
@@learnwithlokeshlalwani Sir job nahi milti Skill hai fir bhi
@vkp229 Жыл бұрын
@@learnwithlokeshlalwani Last two years try kar raha hu ak bhi project nahi mila
@gabbarbrothers5. Жыл бұрын
Sir hmako bhi dila dijiye ye kaam 🙏🙏🙏🙏🙏🙏🙏🙏🙏😂
@bijaykumarmishra7689 Жыл бұрын
Sir how I can update power BI and power query in my get data tab
@googleyoutube6496 Жыл бұрын
Sir How to Mony windrow please send video
@parsu_t_only Жыл бұрын
Sir ea kaam phn me karskte hai ya desktop ya laptop chahiye
@learnwithlokeshlalwani Жыл бұрын
Laptop or a PC is required
@spiritualmasterkeey Жыл бұрын
hi Lokesh, thank you for sharing your expertise and helping us.. One request i am new to fiverr but have 20 years of work experience and i have some experience with excel. how would buyers choose me me as a seller as i don't have any work on fiverr to show.
@mohammednajeebuddin58910 ай бұрын
Thanks Mr. Lokesh, God bless you for helping us Request for you ebooks on Excel. Regards
@ajaylearningcentre88985 ай бұрын
Liked 👍 and subscribed 😊
@learnwithlokeshlalwani5 ай бұрын
Thanks for subbing!
@TheSajidsiddiqui Жыл бұрын
Background mein telescope kaun sa hain?
@nawazshaikh2003 Жыл бұрын
Thank you so much sir 😊
@learnwithlokeshlalwani Жыл бұрын
Most welcome
@manoranjakrang9863 Жыл бұрын
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
@learnwithlokeshlalwani Жыл бұрын
MS Office 365
@minadev1 Жыл бұрын
Hello Pawan ji, can you please teach us POWER QUERY & POWER BI courses.
@learnwithlokeshlalwani Жыл бұрын
I do have a course on Power Bi. Join my free webinar. Here all your doubts will be cleared and your questions will be answered. Here is the link to register: event.webinarjam.com/register/14/691x7b2
@tarekmd41365 ай бұрын
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?
@gadgetsfunnel288611 ай бұрын
Many clients are watching
@mjtoons6025 Жыл бұрын
Sir, whatever skill you tell about work, is this work possible with smart phone? please reply
@mjtoons6025 Жыл бұрын
I'm member your you tube channel
@FullmetalThor Жыл бұрын
not possible
@mohammadkasim007 Жыл бұрын
Best knowledge Video
@learnwithlokeshlalwani Жыл бұрын
Thank you so much for your comment
@mohammadkasim007 Жыл бұрын
Sir me bhi yhi Work krta hun In kuwait city ❤
@hasnainchodary5 Жыл бұрын
ap kon saversion use kar rhay ha ms office ka
@learnwithlokeshlalwani Жыл бұрын
I am using MS Office 365
@hasnainchodary5 Жыл бұрын
@@learnwithlokeshlalwani ya option free ma kasay milay ga
@fayazuddinmohd8555 Жыл бұрын
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.
@learnwithlokeshlalwani Жыл бұрын
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!
@shaikshavali-oq6cg Жыл бұрын
Nice information bro
@learnwithlokeshlalwani Жыл бұрын
Most welcome.
@riazuddin749311 ай бұрын
What if the columns of files are not equal? We will have to use the power query in detail then?
@eatpraylove4918 Жыл бұрын
i've developed the tool for the same. that took less than 10 sec to convert any pdf to excel.
@mianshahzaib639 Жыл бұрын
Detail about tool plese
@intisarhussain4437 Жыл бұрын
Hi sir mera name intisar hussain hai aur me pakistan se hun me 8 class parha hun ap ache lge par kam parhe likhe insan ka hai jo ap dete o me zrurat mand hun plz esy parsnly video dain plz i wait ur ans
@papachoudhary5482 Жыл бұрын
Thanks
@learnwithlokeshlalwani Жыл бұрын
Welcome
@moinuddinshariff6267 Жыл бұрын
Sir Iam very much inspired nd getting very good knowledge from ur videos ,i want to know how I contact u
@learnwithlokeshlalwani Жыл бұрын
Thank you so much for your comment. Please email at ask@nurturetechacademy.in
@birijoni8286 Жыл бұрын
which version of Excel are you using?
@learnwithlokeshlalwani Жыл бұрын
Office 365
@maazhasan Жыл бұрын
Thaks alot sir
@learnwithlokeshlalwani Жыл бұрын
Most welcome
@waheedkamboh Жыл бұрын
Which Excel version you are using please, because in data, i did not find get data option like you are showing, please guide me
@learnwithlokeshlalwani Жыл бұрын
I am using MS Office 365
@RakeshKMishra11 ай бұрын
How to do it in the MS Excel 2010 version? Please give information for all.
@learnwithlokeshlalwani11 ай бұрын
I will suggest to use the latest version of excel. So that you can use all the latest tips and tricks on excel.
@RakeshKMishra11 ай бұрын
@@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.