After searching and skipping lots of tutorials for excel, finally i come to find this awesome playlists. The way of explaining each step is amazing . Thanks for doing such effort. Lots of love from PAKISTAN.
This video is good. If u really want to get into all aspects of text to column, do search "off to office". U will become literally an expert. This video is good.Along with this Check this 1. A must watch from my side ua-cam.com/video/RhamuSEieQ0/v-deo.html
This series of excel is very well explained and feels like classroom. Thanks for such a great effort. Can make videos on SQL. If possible, please do it.
sir you explain every thing very deliberately.. you are a true champ. 👍 one thing you should do if you can . I suggest that it would be great if you also provide us the practice sheet of given tutorial?
text to columns --> suppose i have written name and surname in the same columns. bit i need names in one and surnames in another one . then what i need to do is to select those cells --> go to data-->text and columns-->next-->click on space -->that's it. i will get expected result.
U can use fixed width of text to column if all domain r the same. Or add @in the end after separation with de limiter. This video is good. If u really want to get into all aspects of text to column, do search "off to office". U will become literally an expert.
I would like to thank you so much for all of these very interesting Excel 2013 Tutorial, sincerely they are very interesting videos, I hope for you Mr Lalwani all the best.
Hi, can you please let me know how to keep the zero value after hyphen? Let suppose... I want to separate "SWYD-20-00382 " this value into 3 different columns. 1st column shows = "SWYD" 2nd column shows = "20" 3rd column shows = "382" Now my query is, can I keep the exact value as "00382" instead of "382"...
You can convert the delimited data to Text to preserve zeros or you can use other formulas like, LEFT, MIDDLE, RIGHT etc. You should ask such questions in Quora to get an answer quickly. If you don't get any quick answers on Quora, request me there search for (BALAJI REDDY in Quora, the first person will be me) www.quora.com/profile/Balaji-Reddy-77
Excellent training sir, but I have excel 2013, and I have write formula for each cell separaty for table in word 2013 , is there any setting required to be done in Option?
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
One and only youtuber who does't beg for likes and subscribers.
You are one of the best trainers..so easier to understand excel.
After searching and skipping lots of tutorials for excel, finally i come to find this awesome playlists. The way of explaining each step is amazing . Thanks for doing such effort.
Lots of love from PAKISTAN.
Check this 1. Must watch from my side.
ua-cam.com/video/RhamuSEieQ0/v-deo.html
The best ever channel on UA-cam for Excel learning.
Best tutorial, easy to understand, the trainer speaks clearly and fluently!
Please provide your feedback on this video too. You seem really nice and sincere ua-cam.com/video/GrbLzPXBxfg/v-deo.html
#pavanlalwani
Excellent training skills I am happy as my doubts are clear and I am also a faculty Of Physics
Best computer tutorials ever , it helped me to teach a student as a tutor which helped to to earn some more money while learning myself too❤
I am very thankful to bumped to your video.. i managed to solved my manager's issue within second! you are my hero! Thankyou
Amazing way of teaching sir.
Keep it up
Love from Kabul,Afghanistan
This video is good. If u really want to get into all aspects of text to column, do search "off to office". U will become literally an expert.
This video is good.Along with this Check this 1. A must watch from my side
ua-cam.com/video/RhamuSEieQ0/v-deo.html
This text to column feature i was never aware of. Thanks sir.
Sir your reference and technic of teaching skills is very nice so we understand easily
A am learning from your playlist of excel videos bit by bit everyday. So easy to learn from your videos. Thank you.
Wow, I knew some of it but you made it clearer! Great!
All your videos of excel teaching is awesome
This series of excel is very well explained and feels like classroom. Thanks for such a great effort. Can make videos on SQL. If possible, please do it.
Whenever I need to clear my doubts in excel....my mind prefers your video...nice explanation...expecting more such videos
One of the best tutor thanks for the valuable information.
A nice initiative to teach students.
Thank you Sir and your team
Really awesome explanation God bless you keep rocking
Clear conception, have a nice day to come in your life...
Very well explained
Thank you very much for sharing your valuable knowledge. easy to understand
I really appreciated your video with a clear explanation.
Thanks to you and your team
Thank you so much sir!!! You explain very well .God bless you ..
im god and i bless you
Good work. It's easy to understand. And lecturer Pavan is explaining clearly.
Nicely explained
Thanks! Exactly what I needed.
normally indians are...u know...indians😢
but this dude is a better-grade of indian. gives me hope.
well, it was a great video and by the way, i have already purchased your course...which too is great.
Amazing teaching
No time pass at all
check out riley reed
Thanks sir..all videos are very useful and nice
Gr8 class
Thnq so much buddy
Thanks a lot , first time I could understand
You are excellent man ...... great watching your videos
You just saved my time!!! THANK YOU
Please attach the spreadsheet on which you are doing. It will be very helpful for us.And thanks for your amazing teaching.loads of love.
You are a saviour Sir❤
Very good teaching method... Easily understood...
Sir I really appreciate ur way of teaching
you should apply for head at furness academy
YOU ARE THE BEST TEACHER
NO IM NOT
@@lukepritchard9581 tereko kon bol rahe be ch**a.
You are awesome man... just watched one video & immediately subscribed only for Excel, loved your way of teaching... keep up the good work
SHUTUP
Very nice explanation sir ...awsommm
What an explanation THANK YOU
Thank you sir ☺️ you are teaching excellent ✨
brilliant explanation. very useful
sir you explain every thing very deliberately.. you are a true champ. 👍
one thing you should do if you can .
I suggest that it would be great if you also provide us the practice sheet of given tutorial?
like john cena a true champ
You are the man and thank you.Keep up the good work
Thank you for sharing the information!
Gudmorning Sir, thanks sir Iam obliged to u
Thank you so much sir, we are learning excell very well sir
Keep up the good work!!!! Congrats..
Thanks a lot for teaching.
Superb sir very useful..
Ur awesome teaching way sir
Thank you
Thank you very much sir, it would be more appreciable if you tag that excel file in the description for practice
This video is good.Along with this Check this 1. A must watch from my side
ua-cam.com/video/RhamuSEieQ0/v-deo.html
pleb
@@lukepritchard9581 ?
text to columns
-->
suppose i have written name and surname in the same columns.
bit i need names in one and surnames in another one .
then what i need to do is to select those cells --> go to data-->text and columns-->next-->click on space -->that's it.
i will get expected result.
Awesome. Love ur videos.
your teaching is very nice, thank you so much
no problem leave a like
Awsm way of teaching 👌
Sir u are best
delightful... you teach well . thank you.
Great video and well put together.
This is world class Sir
Your way of teaching is awsme sir hats off from pak 😍
Try this too. share me your valuable feedback
ua-cam.com/video/GrbLzPXBxfg/v-deo.html
Perfect way of teaching... great
ask johnpaul duck
very excellent training gd keep it up bro
Very Nice Sir. Thanks a lot. God bless you.
GAJAB...AWESOME SIR...
Superb teaching method sir 🙏
Fantastic work , really thank you friend.
your not my friend.
Your teaching is very nice .
Keep going, move ahead great work sir
will do cheers bro
You are great sir , amazing way of teaching
the queen nobles you
Helpful Video .. thanks a lot
Lucidly explained.
excellent, well explained sir
Great videos --- very well explained
Is there a way to keep the separator(like @ ) with the data, even after separating them ?
U can use fixed width of text to column if all domain r the same. Or add @in the end after separation with de limiter. This video is good. If u really want to get into all aspects of text to column, do search "off to office". U will become literally an expert.
Thanks for your effort.
sir you save my 10.000
good job sir👏👏👏
Thank you bhai for teaching this
I would like to thank you so much for all of these very interesting Excel 2013 Tutorial, sincerely they are very interesting videos, I hope for you Mr Lalwani all the best.
Thanks Amine :)
Super duper thank you so much 🙏😊
What might be the possible practical usage of fixed-width option in excel?
Nice explanation sir
Wow sir your English speaking is well
stay blessed sir
Hi, can you please let me know how to keep the zero value after hyphen?
Let suppose...
I want to separate "SWYD-20-00382
" this value into 3 different columns.
1st column shows = "SWYD"
2nd column shows = "20"
3rd column shows = "382"
Now my query is, can I keep the exact value as "00382" instead of "382"...
You can convert the delimited data to Text to preserve zeros or you can use other formulas like, LEFT, MIDDLE, RIGHT etc. You should ask such questions in Quora to get an answer quickly. If you don't get any quick answers on Quora, request me there search for (BALAJI REDDY in Quora, the first person will be me) www.quora.com/profile/Balaji-Reddy-77
Yes you can
@@Educated478
Would love to know the procedure, please...
Thanks man. Helped me a lot.
No problem women
Very helpful.
I love your videos sir
Superb ❤️✌️
WAH......... SIR JI
THANKS A LOT
Super explanations
Superb 👍
you are just right on spot where is the need
This is helpful
heartfelt Thanks
Thank you!! 😊
Excellent training sir, but I have excel 2013, and I have write formula for each cell separaty for table in word 2013 , is there any setting required to be done in Option?