Earned Rs 3000 by using simple Excel trick || Data cleaning work from home
HTML-код
- Опубликовано: 8 май 2022
- #excel #earnmoneyonline
FREE Live Masterclass on How to earn Second Salary Through Excel. Register Now. 🔥🔥
event.webinarjam.com/register...
Download the File -- bit.ly/3MXNA7B
Steps - Click on the link -- Click on File from left top corner -- click on Download and practice.
In this video I have explained how you can Earned Rs 3000 by using simple Excel trick || Data cleaning work from home.
FREE Live Masterclass on How to earn Second Salary Through Excel. Register Now. 🔥🔥
event.webinarjam.com/register/3/98xw7cw
Sir is this webinar going on for several days or is it just a recorded one? Because it's still showing the registration for a webinar? Please clarify
sir flash fill not working, saying that didn't see any pattern
I am starting follow you bro...I also wants to start second source of Income as like you.As I am having 5+ years of experience in Excel/Advance Excel.
piyary bhai, kiya hota amount nikalny k leay (right) ya (mid) ka formula use karty yo???
Request you to while using Shortcuts please appear that shortcut in the form of text on Screen...then we can easily understand..
Ctrl + Shift + ⬇️ = Selection of all data
Ctrl + Backspace = go to first row
Alt + E + S + V = Value Paste
Alt + E + D + C = Delete entire column
Ctrl + E = Flash Fill
Alt + H + B + A = border
For Deleting entire column ---> 1st select entire column(Ctrl+space) then remove(ctrl+ -).
It is worth to see ur video rather than spening time on insta reels,loved ur shortcut technique
Thanks a ton. You can follow me on Instagram and watch some knowledgeable reels as well. :)
Exactly what i did now. Closed insta, found this on youtube
Coll center youj hone bala Tarika
Yes
Ekdum 100 taka sach bola bro🔥💯👌
I just watched your two videos and I have fallen in love. Your style is neither too slow nor too fast, just perfect. Looking forward to some great learning and earning thru your videos. God bless.
Outstanding way to teach, You are speaking only on the topic instead of unnecessary things. I learn so much from this video. I appreciate you amazing work. I found exactly what I wanted from long time. 👏👏
many times people ask for like subscribe, share but it always comes by heart and your videos are really helpful Last part was worth watching till last👌
Thank you 😊
Hi Sir Very nice way of teaching. It very informative and engraved in mind at the same time
Thanks a lot
🙌🙌
The best channel I've found in RUclips! Thanks for this video sir 😊❤️ and I'll definitely buy your course today with my all buddies.
Very Good Techniques, Very recently, I have done an online course for excel but these techniques are not there. Thanks and appreciated
sir watched ur first video...Im impressed... wonderful job❤️❤️
Subscribed ur channel 💗💗
Thanks for video. Mr. Lokesh, the example that you demonstrated had a fixed 9 digit account number, decimal(7,2) and constant 2 character text, for which the solution worked well. However, for a real life example, the account number could be variable (1 thru 9 digits or greater), similarly dollar/rupee amount could be variable and lastly text length could be variable. So, how to create a solution for this type of variable scenarios with both the approaches ( old and new(Flash Fill)) methods? And how to cleanse bad data when there is a need for it with few sample examples. I know trim function is widely used, but any others which you may used would be good to know. Thanks!
Please try "Text before" /"text after" functions.
Kamal ho yrr, what a way to explain all of this. Man i never see this type of video. Aaj bhut bdi problem solve ki h.
Good evening sir, your explanation ,clarity and tricks are mind blowing excellent ...
Hello Sir,
Recently i have enrolled ur Power Bi course. The way you are explaining is very nice and i am also interested in freelancing work..Thanks for this video🙏
Thank you 🙌
Hello Can u plz give me ur details wanna talk to u ..Thanks in advace
@Rakesh Mallick 9999 rs
Dear Lokesh, I am amazed that you not only look like my class fellow, who is now a university professor in England but you also speak like him. The physical resemblance is common, but physical as well as style resemblance between people who are not even related to each other is quite amazing. Passion is another common feature between you two. Stay blessed.
The service and the knowledge that you are providing is need a good heart and you have that .😇
Excellent technique and way of teaching. Superb
Hi a kind request, please provide the sessions in English it would be helpful and would reach a wider audience on this platform! The content which you are sharing are worth and it should reach and benefit wider users.
Noted
@@learnwithlokeshlalwani Hindi walo ko zyada zarurat hai
All those upsc aspirants
@Lokesh you can do one thing here Add english subtitle to your video so it will work for both
This video makes me more interesting and I registered that webinar tomorrow and I want to learn more
Sure, see you 😊
Best teacher I ever found on youtube ❤
Wooow amazing. U r outstanding. An excellent teacher. Best wishes and thanku from Pakistan ❤
U r amazing bro...
thanks sir for this wonderful video. To delete multiple columns instead of ALT-E-D-C we can use CNTRL Minus.
Absolutely true👍
Bro ur way of teaching is amazing. Thanks a lot for sharing such type of skill free of cost u r really deserve for appreciation. Thanks again
Great explain smoothly parctial with example given fabulous teaching I really appreciate you thank you so much sir
Sir I want to work from home for second salary as showing your vedio. I handle excel worksheet easily with formula and function, please guide for these types of excle works for extra earning🙂🙂
Sure Narendra, kindly join the free masterclass :)
Sir, it can be done by FlashFill. The required data will be available in less than a minute
Btw, today I got to know the shortcut to go the first cell in a particular selection. CTRL+Backspace and thank u for that 🙏
How he remove the formula and keeps the value ??
@@faezakamal6445 ALT ESV (Paste Special)
Do you do freelancing by Excel ?
2nd trick n to mera bhi dil le liya....💝 Thanks brother..
Thank you sir I am maitaining my family expenses by accuiring knowleges from you sir and working regularly.
Great video Sir,
You are doing something different and very useful for all new learners
Thank u
Keep Learning. All the best !!!
hi brother, your video is really amazing.
can you please teach how to clean duplicate values.
Thanks, sure 🙌
Great mentor to guide the next generation
First I thought I can do it with python(Automation with Excel).
But this knowledge is also awesome
Thankyou Lokesh ! I will definitely learn and practice. Cna this be done on Google Sheets too?
👍yes
Nice video Lokesh, lot of people can benefit from you, working on excel can help you really earn a second income
Knowledge matters love ur way of teaching.
Hi Lokesh, I lost my job during the pandemic last year. I have decided to learn and master Microsoft Excel and have started learning it through videos found on RUclips and other materials like pdf and books. I've come across this video of yours and am speechless about the way you've explained the steps involved and the tricks you employed to get the job done. I really need your help. Can you provide some material for practice?
Thank you,
Warm regards.
You can find exercise files with all my Excel videos.
@@learnwithlokeshlalwani Thank you.
@@learnwithlokeshlalwani Sir plz plz rply Do you have refer system in your course for our extra benefits?
Sir, Many times I ve heard ,By the name of freelancing they trap the people and fraud threating legal action in different ways. I mean they intentionally do this. Can u plz guide us the genuine freelancing websites to avoid this type of fraud or harassments.
Yes its true. See, you will face it everywhere. One way to figure out is to is if they ask you money and promise to give you work in return then simply avoid it. Its a scam.
Hope this helps.
Happy learning:)
Thanks sir for this information and for this video by which so many people get the knowledge
Hi Lokesh Sir, I have learned a lot from your Excel videos, Internet has softened the borders so I could learn while sitting in Lahore, Pakistan. God bless you.
Hi, It's a very informative video.
I have a small doubt; what is the command you have used to remove the 'trim' formula. Does that work with windows7?
Its ALT E S V then press enter. Yes it works.
Thank you very much Lokesh ji.
@@learnwithlokeshlalwani Unfortunately, this command doesn't work for me. I have multiple times but no use.
@@janardhangatti9482 bhai 1 overview de sakte ho kya kaise kamaye
Sir is this webinar going on for several days or is it just a recorded one? Because it's still showing the registration for a webinar? Please clarify
I keep on doing it on regular basis.
@@learnwithlokeshlalwani sir how can I start freelancing by learning ms excel??
Just wow kitni zaroort thi is ki ik bar yeh flash fill ghalti sy use hua tha fr dobara ab mila
Very informative video. Thanks to spread the knowledge 👍
Sir I m loving Vedic maths..how can I get online client for teaching?
Try teacheron.com
@@learnwithlokeshlalwani ok sir thank you
@vaja parag Can u plz teach me Vedic mathematics
Clint also watching this video 🤭😂
Amazing Video! I came here for the first time on your channel and this video compelled me to subscribe your channel. Love and Respect from Pakistan.
Kya baat hai sir ji aap mahaan ho. I selute you.
excellent work Sir, thanks a lot for master class, God bless you more.
🙌🙌
Lokesh sir me apka ehsan kabhi nhi bhulunga sir your great sir❤️❤️❤️is hi type ki aur trick le aaye bs sir gazab sir wo bhi hindi jese yeh hai❤️❤️
Thank you ✨
simple way of explaining, great work
YOUR LEARNING PROCIDURE IS VERY GOOD.
A very nice video...I liked it and now going to subscribe....very good teaching style.
Excellent job you did brother be honesty ur teaching golden things to us. However you have given us sample data also thank you so much brother. Inshallah almighty give you good health and wealth.
It's very useful video which you have uploaded.
Please future whichever video ur uploading please upload dammy data also . It's very useful to practice us.
Please give me ur what's up number brother and give me the idea about how to take project. Then how we can earn money in freelance.
Still i don't have any idea about the any project first time i heard about we can earn money in offline , independent also please help me on this.
Thank you sir... The way you teach is very simple & easy to understand... No need to watch again... 👍🏼👍🏼👈
Keep watching
@@learnwithlokeshlalwani always sir👍🏼🙏
AS EXCEL IS A MAGIC !!..... YOU ARE A MAGICIAN OF EXCEL!!😊
It's really amazing 👌. I am really shocked when you use the second part trick ❤️. This type video we really want more.
Thanks 🙌🙌
Great words sir knowledge makes people to think wisely. Nice
Sir your using tricks is extremely amazing...im fan of you..
Thank you so much sir... Very informative video.
The way of explanation is very simple and easy .
appreciated....i will during export from SAP ERP.....thumbs up bro
i just love way of your teching styles
Thank You for Providing such valuable tricks and for Your Time,
Love From Pakistan ❤️
this is call proper explanation for fresher, new subbie, keep providing good work sir
Keep Learning. All the best !!!
That's why your course is need to buy. You are super hero sir. Great sir.
Today understand you.
Thank you Rahul 🙌🙌
Great teacher
Small small steps ko भी samjhate ho bhai ( ye youtube ke baki teachers se alag chij hai aap me) ✌️✌️✌️
💥💥
Keep it on
Thanks you :)
Nice to learn these excel trick and your method of teaching
Great mentorship 😍☺️👌
thanks lokesh worthy session 💐💐
excellent video..very useful thanks for the wonderful tips, god bless you
🙌🙌
Flash Fill command is the amazing, i amaze to see this command in this video
I really liked all of ur videos & i'm learning from it. Thanks to you sir.
Thank you so much for your comment.
Also we can use proper ( left (find ( find vlauw )-1)
The way of teaching is super sir
Thanks ❤
You are a brillent teacher sir
I was thinking about flash fill. But Honestly worth watching. I have learnt other techniques.
🙌🙌
Love U Sir, I have been following you since last one year & have become your fan. Your way of training/teaching is excellent. Me Sikandar from HYDERABAD SINDH PAKISTAN. Please let me know about your Master Classes. I am your SHESHAK.❤❤❤👍👍👍
Join my free webinar. Here all you doubts will be cleared. Here is the link: event.webinarjam.com/register/13/m4851s2
Thank You So Much Sir i am a student i will Start This Love From Pakistan
Great sir lokesh keep it up really really appreciated 👍
🙌🙌
Maza aagaya bhai! Kya cheez hai ye excel! Wow!!!
Keep Learning. All the best !!!
I am glade that I found part time earning and this is you for this credit goes. I think that you will continuous this help . Thanks
Hi Ramzan, i am glad to hear that and congratulations 🎉🎉
Also, would you like to inspire others by sharing your success story with us. If yes, then kindly share your email id and will approach you👍
much useable sir thank you so much
Great tutorial..... THANKS
Amazing bhai u r a real example of smart work....
Keep Learning. All the best !!!
Thanks for giving such valuable and time saving and money eraning information.
V clear n informative tips sir..thanks a lott!!
Always welcome
explanation is excellent....
Hi I am from Pakistan, I saw your video and it was really really helpful.
I have subscribed your channel and hope to learn more from you videos.
Thanks 🙌 🙌
Sir very thankful Great full from Pakistan
Left and right formula sir ❤️
Prabu Ji thank you soo much
Great video. Learnt new things.
Hi Lokesh,
Myself Sunil .. loved the way you explain .. from my early age ive been crazy for excel.
Please reply ..
I glad to subscribe you and already liked your videos
Excellent sir... But one thing I appreciate that your explanation is very excellent sir... Thank you
Thank you 🙌
@@learnwithlokeshlalwani sir I have no laptop or PC but I have knowledge of excel.😍 I am practicing in my phone with keyboard connect ...in mobile excel app ....can I earn from mobile phone excel ???
Thanks good and informative 👍🏻
wow super sir, i newly learned this trick... thank you
Thank you so much for your comment.
THANK YOU for this wonderful video.
🙌🙌
Gazab bhai. Subscribed.
🙌🙌