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
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.
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👌
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.
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🙏
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. 👏👏
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!
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.
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 🙏
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.
Sir I am from Pakistan but I really appreciate your professional effort for us as being a motivation for me now I am also learning excel from you from youtube.
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🙂🙂
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.
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:)
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 UA-cam 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.
@@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 ???
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👍
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.❤❤❤👍👍👍
no need to use text to columns , can be done using mid + find formula ... =MID(B2,FIND("$",B2)+1,FIND(" ",B2,FIND("$",B2))-FIND("$",B2)-1) it will work on any kind of data even if it has a lot of leading or trailing spaces
Mr. Lokesh, online jobs most of them are conned by people. Some con us in India and also from overseas. They charge us Rs.500 in India and $100 overseas as security charges and later vanish.
Where ru sir.... 😭😭😭 I swear itne acche se explain Kiya muj jaise mote dimag waale ko bhe easily smj main aagya....thanku soo mch sir u doing tremendous job ... God bless u
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.
Thank you sir... The way you teach is very simple & easy to understand... No need to watch again... 👍🏼👍🏼👈
Keep watching
@@learnwithlokeshlalwani always sir👍🏼🙏
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 😊
Best teacher I ever found on youtube ❤
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.
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.
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
2nd trick n to mera bhi dil le liya....💝 Thanks brother..
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 ✨
sir watched ur first video...Im impressed... wonderful job❤️❤️
Subscribed ur channel 💗💗
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. 👏👏
Hi Sir Very nice way of teaching. It very informative and engraved in mind at the same time
Thanks a lot
🙌🙌
Maza aagaya bhai! Kya cheez hai ye excel! Wow!!!
Keep Learning. All the best !!!
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.
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.
This video makes me more interesting and I registered that webinar tomorrow and I want to learn more
Sure, see you 😊
I am Naveed Ahmad from pakistan
Bug hands for you respected sir
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 ?
Very Good Techniques, Very recently, I have done an online course for excel but these techniques are not there. Thanks and appreciated
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
Sir I am from Pakistan but I really appreciate your professional effort for us as being a motivation for me now I am also learning excel from you from youtube.
Thank you so much. Glad to hear it!
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 :)
Thank You So Much Sir i am a student i will Start This Love From Pakistan
Great video Sir,
You are doing something different and very useful for all new learners
Thank u
Keep Learning. All the best !!!
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.
thanks sir for this wonderful video. To delete multiple columns instead of ALT-E-D-C we can use CNTRL Minus.
Absolutely true👍
Wooow amazing. U r outstanding. An excellent teacher. Best wishes and thanku from Pakistan ❤
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:)
The service and the knowledge that you are providing is need a good heart and you have that .😇
U r amazing bro...
Just wow kitni zaroort thi is ki ik bar yeh flash fill ghalti sy use hua tha fr dobara ab mila
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 UA-cam 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?
Excellent technique and way of teaching. Superb
hi brother, your video is really amazing.
can you please teach how to clean duplicate values.
Thanks, sure 🙌
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
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
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??
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 ???
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
this is call proper explanation for fresher, new subbie, keep providing good work sir
Keep Learning. All the best !!!
Clint also watching this video 🤭😂
Hahaha maja agaya🤣😂
AS EXCEL IS A MAGIC !!..... YOU ARE A MAGICIAN OF EXCEL!!😊
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
Great explain smoothly parctial with example given fabulous teaching I really appreciate you thank you so much sir
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 :)
Flash Fill command is the amazing, i amaze to see this command in this video
Sir first yt channel mujhe mila jo real job based videos dikha rahe hai
🙌🙌
That's why your course is need to buy. You are super hero sir. Great sir.
Today understand you.
Thank you Rahul 🙌🙌
Thank you sir I am maitaining my family expenses by accuiring knowleges from you sir and working regularly.
Kya baat hai sir ji aap mahaan ho. I selute you.
Sir very thankful Great full from Pakistan
Great job brother... Love from a proud Pakistani.
Thank you for your comment.
Amazing bhai u r a real example of smart work....
Keep Learning. All the best !!!
appreciated....i will during export from SAP ERP.....thumbs up bro
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👍
Thanks sir for this information and for this video by which so many people get the knowledge
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 for Providing such valuable tricks and for Your Time,
Love From Pakistan ❤️
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.
no need to use text to columns , can be done using mid + find formula ...
=MID(B2,FIND("$",B2)+1,FIND(" ",B2,FIND("$",B2))-FIND("$",B2)-1)
it will work on any kind of data even if it has a lot of leading or trailing spaces
I was thinking about flash fill. But Honestly worth watching. I have learnt other techniques.
🙌🙌
Kuch sikhne mila bro aapke videos se maja aa gaya
Keep learning. All the best !!!
The best channel I've found in UA-cam! Thanks for this video sir 😊❤️ and I'll definitely buy your course today with my all buddies.
Knowledge matters love ur way of teaching.
Good evening sir, your explanation ,clarity and tricks are mind blowing excellent ...
Great mentor to guide the next generation
The way of explanation is very simple and easy .
Nice video Lokesh, lot of people can benefit from you, working on excel can help you really earn a second income
i just love way of your teching styles
The way of teaching is super sir
Thanks ❤
Mr. Lokesh, online jobs most of them are conned by people. Some con us in India and also from overseas. They charge us Rs.500 in India and $100 overseas as security charges and later vanish.
Thank u for ur free utube class
Most Welcome.
thanks lokesh worthy session 💐💐
simple way of explaining, great work
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 🙌 🙌
Where ru sir.... 😭😭😭
I swear itne acche se explain Kiya muj jaise mote dimag waale ko bhe easily smj main aagya....thanku soo mch sir u doing tremendous job ...
God bless u
:)
thank you
Thank you sir.. mujhe aacha khasa aata hai Excel. But still mujhe kuch or new or intresting chahiye tha.. thank you so much ❤️
Happy learning :)
=Trim(clean(substitute(select the cell,char,"")
Left and right formula sir ❤️
Nice to learn these excel trick and your method of teaching
Awesome sir it was unbelievable
Keep learning. All the best !!!
Excellent sir. From Bangladesh
Great teacher ever..🥰
Thank you! 😃
Sir 🙏🏼
Maan gaye👍🏼
Inshaallah very soon 10 lakh subscriber brother i help you to get more subscriber inshaallah very soon.
I really liked all of ur videos & i'm learning from it. Thanks to you sir.
Thank you so much for your comment.
Excellent,but also teach how to separate Dr and CR in different columns???????
A very nice video...I liked it and now going to subscribe....very good teaching style.
YOUR LEARNING PROCIDURE IS VERY GOOD.
Great, amazing , - where to find excel tutorials like this
Very informative video. Thanks to spread the knowledge 👍
CTL+ALT+V for value paste more easily.
excellent video..very useful thanks for the wonderful tips, god bless you
🙌🙌
wow super sir, i newly learned this trick... thank you
Thank you so much for your comment.
explanation is excellent....
Great words sir knowledge makes people to think wisely. Nice