Awesome Excel Trick to Earn Rs. 850 in just 1 hour (2025)

[@learnwithlokeshlalwani]

FREE Live Masterclass. Register Now. 🔥🔥 event.webinarjam.com/register/13/m4851s2

[@Rehan_idrishi_911]

Mohit Gupta. 14500 Ramesh Iyer. 14900 Rohan Kapoor. 19500 Vikram Iyer. 14400 Vikram Mishra. 14600

[@learnwithlokeshlalwani]

@@Rehan_idrishi_911 Correct Answer!

[@NatashaSana-h4k]

Before this lecture I have NO idea that how to we change PDF File to Excel I learn this thing now thanks sir

[@learnwithlokeshlalwani]

@@NatashaSana-h4k Glad to hear.

[@gudiyasingh9779]

SIR IS KAAM KO MOBILE PE KAISE KARE ISKA BHI VIDEO PLEASE BANAYE

[@AdnanAhmed-o5b]

Mohit Gupta=14500 Ramesh Iyer=14900 Rohan Kapoor=19500 Vikram Iyer=14400 Vikram Mishra=14600 Sir, you are great aap ke teaching ka style bohut acha hai keep it up

[@sumtx]

Same

[@Cyberguardians1]

Aman Kapoor 14000 Manish Sharma 10400 Mohit Gupta 14500 Mohit Patel 13000 Nidhi Joshi 10400 tq sir for for awsome teaching now only i have register to masterclass sir

[@luckykahalwaa]

😂wrong you want to choose top 5 not top 6 to 10 😅😅😅😅

[@Asaduledit08]

Mohit gupta : 14500 Ramesh lyer : 14900 Rohan kapoor : 19500 Vikram lyer :14400 Vikram mishra : 14600 Love from Bangladesh sir 😊😊

[@AmirulIslam-gm2hj]

Rohan Kapoor=19500 Ramesh Iyer=14900 Vikram Mishra=14600 Mohit Gupta=14500 Vikram Iyer =14400 Sir thanks for the awesome teaching.

[@yugallokhande2896]

Did you all earn

[@indrajitdas8358]

YES I LOVE PDF I KNEW. BUT I DIDN'T KNOW IF THE WHOLE EXCEL SHEET WILL BE CONVERTED IN 1 SPREADSHEET. THIS YOU TAUGHT ME.

[@rizwanayasmin7297]

Dear you are awosme. Some of tricks we know but practically nahe kiya tha. Your teaching style is so simple and easy. You are doing a great job. Etni efforts kar k you are giving us your knowledge.

[@learnwithlokeshlalwani]

Thank you for your comment.

[@manassamanta341]

@@learnwithlokeshlalwani sir, mein bca computer application backgroung ka student hu... mein last 1 year tally with gst ka course kiya hai, mein ab tally job ke liye apply kar raha hu.. to mujhe accountant job ke liye exel ke kaun kaun se topic me zyada knowledge lena chahiye?

[@akashvishwakarma5594]

Aapne magic kar diya sir ji thank you mujhe abhi tk utna kuch pta nhi tha.. ❤

[@ideas_hub]

Really you are a pro mentor , i didn,t know before this skill.

[@learnwithlokeshlalwani]

Thank you for your comment.

[@mahmoodmakkah9282]

nice, bahot kuch sikha hai aap se, thanks

[@danielkovlogs]

Top 5 lifetime values Mohit Gupta : 14500 Ramesh Iyer : 14900 Rohan Kapoor : 19500 Vikram Iyer : 14400 Vikram Mishra :14600

[@learnwithlokeshlalwani]

Right Answer!

[@mdmotaleb6142]

Teaching style is execellent. Thanks Bhai.

[@learnwithlokeshlalwani]

My Pleasure.

[@kaifayasmin]

the answer is 1. mohit gupta- 14500 2. ramesh iyer- 14900 3. rohan kapoor- 19500 4. vikram iyer- 14400 5. vikram mishra- 14600. lots of thanks sir .....mujhe apki teaching style samjhaane ka tarika bahut achaa lgta hai or achese mind m baith jata hai......keep it up sir...

[@learnwithlokeshlalwani]

Thank you so much for your comment. Correct Answer!

[@DangerGamely]

Sir me ajj muje ye nahi pta hai ki freelancer per keisa order like jate h or order keisa diye jate h in sab ka step by step process kya hota I Don't know sir please app samjao

[@aemonsana834]

I also solve it... Mohit Gupta: 14500 Ramesh Iyer:14900 Rohan Kapoor: 19500 Vikram lyer: 14400 Vikram Mishra: 14600

[@Simranrajoriya0047]

Sir aapne shi me bhut different chiz btai h tusi great ho sir

[@utsavkakaniya5013]

SIR MENE ABHI ABHI AAPKI CHANNEL KI VISIT KI HAI . AAP BHUT ACHA OR INTERESTING SIKHATE HO . ME AAPKI 2025 KI SERISE KE SARE EXCEL VIDEO DEKHKE EXCEL ME MASTER BANNA CHAHTA HU . THANKYOU SIR .

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@TheUnthinkableEdge]

Ur second salary is our first salary 😅

[@ashrafulislam1913]

😂😂😂😂😂 sach me ek ek alamat hai

[@kritarthashrestha9104]

exactly🤣

[@dittu2701]

Ye yahi karte hai 😂

[@abrarahmed2365]

😂😂

[@abrarahmed2365]

Not yet 😅

[@Azhar_Khan383]

Top 5 customers are Rohan kapoor-19,500/- Ramesh iyer-14,900/_ Vikram Mishra -14,600/- Mohit Gupta-14,500/- Vikram iyer-14,400/- Many Thanks sir for your hardwork.

[@gitargolpo]

How to create the top 5 names top1, top2, top 3,top 4, top5. In a row. Please suggest.

[@humayedabdullah]

Rohan Kapoor =19500 Ramesh lyer= 14900 Mohit Gupta=14500 Vikram Lyer=14400 Vikram Mishra=14600 That is the Top 5 customers with highest lifetime values check it sir 👍

[@krishnammahour1099]

Top 5 customers with highest lifetime value in 1. Mohit Gupta 14500 2. Ramesh Lyer. 14900 3. Rohan Kapoor. 19500 4. Vikram lyer. 14400 5. Vikram Mishra. 14600

[@learnwithlokeshlalwani]

Right Answer!

[@littleking9850]

Rohan Kapoor=19500 Ramesh Iyer=14900 Vikram Mishra=14600 Mohit Gupta=14500 Vikram Iyer=14400 I made a pivot chart too, thanks for teaching us sir ❤❤👍👍❤❤

[@learnwithlokeshlalwani]

Right Answer!

[@TusharsVlogs888]

Your videos are very helpful for everyone who are looking for a job and need to learn excel 😊❤

[@sudhirsingh4596]

But Thanks to You Sir kaafi or b kuch seekhne ko mila.. Learning is life..

[@learnwithlokeshlalwani]

It's my pleasure

[@hellom.kshorts1979]

Rohan Kapoor - 19500 Ramesh Iyer - 14900 Vikram Mishra - 14600 Mohit Gupta - 14500 Vikram Iyer -14400

[@learnwithlokeshlalwani]

Correct Answer!

[@Vkfunshorts_8563]

Yes Sir, Aisa Feature use kiya hai, but iska use sahi tarike se nahi kiya tha, Thank You ❤

[@mayurmate1]

The answer is: Rohan Kapoor - 19,500 Ramesh Iyer - 14,900 Vikram Mishra - 14,600 Mohit Gupta - 14,500 Vikram Iyer - 14,400 Sir, Aapka yeh homework dekar answer complete karke lena thought kafi accha hai aur isse practicle aur excel knowledge bhi sabhi ka badhega.

[@saadayaz5657]

Sir you are doing soo well I very happy to find teacher as you 😊😊

[@learnwithlokeshlalwani]

It's my pleasure

[@MuhmmadFaisal-k8t]

Please sir koi esa plateform bata dy jis sy 1 week ky ander ander client ajye ur guidence style is Excellent or Really are u very honest person♥♥

[@NOT_AGER8AIT]

1. Rohan Kapoor 2. Ramesh Iyer 3. Vikram Mishra 4. Mohit Gupta 5. Vikram Iyer

[@adileepkumarsingh6487]

aapka teaching style... fabulous ...

[@annweshakundu5366]

Mohit Gupta =14500 Ramesh Iyer =14900 Rohan Kapoor =19500 Vikram Iyer =14400 Vikram Mishra =14600

[@ayushgupta5609]

substitute of text to coloum is Flashfiill.... But text to coloum works much then flashfill some times

[@magesh5781]

yes, I have converted the no of times and this most useful tool for professionals

[@avinashdakua1669]

Homework answer Mohit Gupta = 14500 Ramesh iyer= 14900 Rohan kapoor =19500 Vikram Iyer = 14400 Vikram Mishra= 14600

[@indrapkushwaha]

Sir your video is very informative below is the top five customers name Mohit Gupta =14500 Ramesh Iyer =14900 Rohan Kapoor =19500 Vikram Iyer =14400 Vikram Mishra =14600

[@Bareeqa00]

THANKYOU✨

[@nkitaM]

Sach me sir . Apka teaching style alaag🔥hai

[@learnwithlokeshlalwani]

Thanks for watching.

[@salmansalluss827]

Thanks sir for explain about data analysis and visualization features for us

[@snehaljagadale14]

Hi sir I have done this many times I was working in a consultancy firm with basic salary there I have done so many conversion with this I love pdf website because the my work deals with client where the usually send the docs document and pdf document or word document we use convert to make another excel report or sheet and use to upload in a particular website the website we used were generally govt websites but all the other tricks you have mentioned it was amazing

[@sunilkumarnandi9187]

Good Evening Sir. Your Teaching style is very friendly.

[@learnwithlokeshlalwani]

So nice of you

[@RakheeSharma-dw8qy]

Mohit gupta =14500 Ramesh iyer=14900 Rohan kapoor=19500 Vikram iyer=14400 Vikram mishra =14600 Sir please check it.😊

[@DAKSHAGARWAL-2013]

Yes i knew how to convert from pdf to excel

[@amrushavaidya5100]

Ur teching style is up to the mark sir

[@learnwithlokeshlalwani]

Thank you for your comment.

[@sagardeepsingh-s5l]

Very Nice video sir for helping in Data Analysis 📊👍

[@learnwithlokeshlalwani]

Glad you liked it.

[@utpalbiswas4213]

1.Rohan kapur -19500 2.Ramesh lyer -14900 3.Vikram mishra - 14600 4.Mohit Gupta - 14500 5.Vikram lyer - 14400

[@learnwithlokeshlalwani]

Right Answer!

[@crazyqueen4975]

I know this whole thing sir and thank you so much for this wonderful video

[@learnwithlokeshlalwani]

Most welcome

[@struggleofmylife0412]

I have used the same for my co. as MIS Excutive. But today I know its value.

[@sajjadahmed4884]

Excellent learning video, im aware pdf converting into excel and selecting top 5 as well

[@learnwithlokeshlalwani]

Thank you for your comment.

[@sudhirsingh4596]

Zabardast Video h.. awesome Thank You So Much

[@learnwithlokeshlalwani]

Thanks for liking

[@gaffarhusain3632]

Very very thanks for it 🎉

[@learnwithlokeshlalwani]

My pleasure.

[@omprakashverma9398]

Top 5 customers with highest life time value are Rohan Kapoor 19500 Ramesh Iyer 14900 Vikram Mishra 14600 Mohit Gupta 14500 Vikram Iyer 14400 Thanks Sir , 👋👋

[@learnwithlokeshlalwani]

The answer is correct!

[@hrk1]

U r doing a good job, plz keep it up

[@learnwithlokeshlalwani]

Thank you.

[@afzalhussain1109]

Top Five Values 1) Mohit Gupta _14500 2) Ramesh lyer_14900 3) Roshan Kumar _19500 4) Vikram lyer _ 14400 5) Vikram Mishra _14600 Sir your teaching style superb Thank you Sir for this vedio

[@learnwithlokeshlalwani]

Right Answer!

[@RunitaChendwankar]

Thank you very much sir its helps me a lot...

[@learnwithlokeshlalwani]

Glad to hear that

[@salimakkiwat]

I haven't used this kind of excel feature.... Thanks

[@mithunmodak169]

Thanks for sharing this great videos 🎉

[@learnwithlokeshlalwani]

Thanks for watching!

[@HenilRadhanpura-yp6bt]

Sir today is my first session of attending your freelance course I like to know more about that. I will definitely see your previous video to learn from that

[@learnwithlokeshlalwani]

Thanks and welcome

[@gaminghurry]

10:50 ha pata tha balki maine isse bhot baar use v kia ha ( pdf to word,jpg) aur v bhot sare ha ❤

[@salimakkiwat]

No, I didn't know the excel feature you showed. Thanks

[@viquas1536]

Answer: Mohit Gupta : 14500 Ramesh Iyer : 14900 Rohan Kapoor : 19500 Vikram Iyer : 14400 Vikram Mishra : 14600

[@rahulthanke]

Mohit Gupta 14500 Ramesh Iyer 14900 Rohan Kapoor 19500 Vikram Iyer 14400 Vikram Mishra 14600 SIR APKA TEACHING KA TARIKHA BAHOT BADHIYA HAI SIR HETS OFF SIR

[@learnwithlokeshlalwani]

Thank you for your comment. The answer is also correct.

[@AryanJ-y5l]

1. Aman Kapoor 2. Manish Sharma 3. Mohit Gupta 4. Mohit Patel 5. Nidhi Joshi They are the top 5 lifetime value customers.

[@learnwithlokeshlalwani]

Please check your answer again!

[@Entertainment_With_Noor]

Bhai sahab jitna asani se aap batate utna asan ni hai Market me sab kuch. By the way, I work as a data analyst in a known company but mujhe bhi ni milta hai freelance.

[@ramanpainuli]

Top 5 - 1) Rohan Kapoor - 19500 2) Ramesh Iyer - 14900 3) Vikram Mishra - 14600 4) Mohit Gupta - 14500 5) Vikram Iyer - 14400

[@learnwithlokeshlalwani]

Correct Answer!

[@57_pramodsitaprao12]

The top 5 people are Mohit Gupta 14500, Ramesh Iyer 14900, Rohan Kapoor 19500, Vikram Iyer 14400, Vikram Mishra 14600, Thank you & Keep it up!

[@learnwithlokeshlalwani]

Great work. Correct Answer!

[@mhgame]

Mere pass computer nhi hai na hi laptop tab bhi dekh rha hu knowledge ke liye

[@bestsongs3644]

Agar typing hard lage to ak otg, mouse aur keyboard kharid lena

[@ASMACEO]

sir I am from bangladesh . "I am learning Excel very easily by watching your videos. You explain everything so clearly that I am able to understand things which I might not have learned even by taking a course."

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@mytalks5639]

Best video, it's very helpful

[@learnwithlokeshlalwani]

Glad to hear it.

[@Mr.pramodKumar-e7s]

wow nice sir😊😊

[@sumitshaw8559]

top 5 people are Mohit Gupta 14500, Ramesh Iyer 14900, Rohan Kapoor 19500, Vikam Iyer 14400, Vikram Mishra 14600

[@learnwithlokeshlalwani]

Correct Answer!

[@JainulAbedinB]

No it's wrong because the client needs the top 5 its mean highest value to low value ​@@learnwithlokeshlalwani

[@ReviewMastery-v2q]

Great ❤

[@AmanChoudhary-n8g]

Thank you sir for this video❤

[@learnwithlokeshlalwani]

My Pleasure!

[@yaduwanshikundan]

amazing session 🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@Armani-z9o]

Yes, & I learned from you, sir.

[@All_Latest_Jobs]

Nice video 🎉

[@rahulraajalda3524]

Nice video Sir 😊

[@amirsuhail4053]

Rohan kapur 19,500 Ramesh Iyer 14,900 Vikram Mishra 14,600 Mohit Gupta 14,500 Vikram Iyer 14,400

[@learnwithlokeshlalwani]

Right Answer!

[@_EternalVoid]

Sheet 1--- Rohan Kapoor - 19500 Ramesh Iyer - 14900 Vikram Mishra - 14600 Mohit Gupta - 14500 Vikram Iyer - 14400 I have submitted from both sheets

[@learnwithlokeshlalwani]

Right Answer!

[@aopgamer5266]

Thank u so Mach sar aapane itne acche tarike se doubt clear Kiya but but data analysis ke liye aur kya kya Sikh sakte hain kya aap humko bata sakte ho

[@RamitKumar-r9e]

sir u are awesome i'm in class 10th

[@Dashboard_Specailist]

yes i have converted pdf to excel after seen in your video.

[@AJAYSINGH-iv9gt]

29,30,31,36 and 37 are the lifer time value , Mohit, ramesh rohan vikram vikram misra

[@SyedaAmrin-c5g]

Yes sir good explanation

[@learnwithlokeshlalwani]

Thanks and welcome

[@roop_sidana]

Aman Kapoor 14000 Manish Sharma 10400 Mohit Gupta 14500 Mohit Patel 13000 Nidhi Joshi 10400 Ramesh Gupta 10600 Ramesh Iyer 14900 Rohan Kapoor 19500 Sneha Kapoor 10400 Vikram Iyer 14400 Vikram Mishra 14600 sir is this correct ???

[@learnwithlokeshlalwani]

Top 5?

[@sumitgedam9977]

Nice teaching sir

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@shaikirfa-hu8pn]

Answer is 1. Mohit gupta- 14500 2. Ramesh iyer- 14900 3. Rohan kapoor- 19500 4. Vikram iyer- 14400 5. Vikram mishra- 14600

[@learnwithlokeshlalwani]

Correct Answer!

[@kavitham165]

Yes sir, ilove pdf I'm using everyday

[@zarbezulfeqhar3513]

VERY HAPPY TO SAY BHAI I DO THIS PDF TO WORD AND EXCEL BUT YOUR LAST PREVIOUS VIDEO GET HELP ME LIKE FORMATING

[@learnwithlokeshlalwani]

Sure, More to come!

[@sathimuralidharan8900]

Well explained

[@Islamicinsights116]

Yes sir i have converted pdf to excel many times

[@MalingarayaElabanavi]

I need thie type data analysis in mobile, Please make a video in mobile app.❤

[@YashvardhanSingh-uu8qf]

Top 5 person by lifetime value- 1. Rohan kapoor=19500 2.Ramesh Iyer =14900 3. Vikram Mishra=14600 4.Mohit Gupta= 14500 5.Vikram Iyer = 14400 Text canbe spilitted usually two ways - #Text to column #Flash fill & both mathod I learnt from you sir...❤❤

[@learnwithlokeshlalwani]

Great work. Correct Answer!

[@skcreation-india2001]

Yes, I have used such features.

[@shadowgaming-v9t]

Mohit Gupta 14500 Ramesh Iyer 14900 Rohan Kapoor 19500 Vikram Iyer 14400 Vikram Mishra 14600

[@learnwithlokeshlalwani]

Correct Answer!

[@papputiwari85]

1. Rohan Kapoor - 19500 2. Ramesh Iyer - 14900 3. Vikram Mishra - 14600 4. Mohit Gupta - 14500 5. Vikram Iyer -14400

[@UmeshAgrawal-t6t]

Mobile m hota kya ye work

[@learnwithlokeshlalwani]

@@UmeshAgrawal-t6t Laptop or a Desktop is required.

[@learnwithlokeshlalwani]

Right Answer!

[@Mdkhan-bz2bf]

1 kavita malhotra 40% 2 kavita Nair 16% 3 kavita patel 16% 4 kavita sharma 16% 5 kavya menon 12% This excel homework My task completed in excel show in chart top 5 irshad khan

[@learnwithlokeshlalwani]

Please check your answer again.

[@tanmoygoswami3926]

split by left and right function

[@vikash5033]

Hii sir t The answer is of top5 client are Mohit Gupta 14500 Ramesh Iyer 14900 Rohan Kapoor 19500 Vikram Iyer 14400 Vikram Mishra 14600 hope my answer is correct and you like it if there is any mistake then correct me thank you

[@talhaali2553]

Yes Data can be split by using Flash fill .

[@Its_anju_life]

Yes sir mujhe pta tha data ko split krna

[@dapcubalangir5011]

Yes, I have converted PDF to Excel in 2018.