I am watching all these lectures in 2023😂 but its so helpful because of your standard format in which you teach everything step by step sequencialy, there are many vdos available on YT but those are not in the proper sequence , thanks for these awesome vdos😊❤
man I'm surprised with how you go out of your way to show us so many uses for everything. Only on video 4 and I've already learned so much. Thanks dude.
Sir you are amazing... I recently joined office and i couldn't even do a simple thing i was so scared but now after going through your videos i find excel so interesting... Thanks to you i feel a bit confident now🙏🏻🙏🏻☺
I was looking for this for so long, and I think I found them too late as well. But I'm very happy to get such amazing detailing of Excel, which makes it more interesting to use. Thank you so much for the full course...!!! 😊
May god bless u brother 🙏 what a wonderful lessons u made for us its really very simple to understand nd we are learning lots knowledge. from u its helping us more
Sir can you give some exercises to do for particilar lessons that you teach in this course by which student can practise this for perfection in that commands that you teach . Sir plzz can you help me by doing this 🙏
i am a slow learner so its difficult to grab everything when its going fast.. i want to learn one at a time n be perfect in one thing than getting messed with many things. i just want to know how can i start with the very basic of using and excel especially inserting rows and coloumn and than bordering and lining them and entering data numbers ,in a simplest way. also do u give personal coaching online?
Hello. In the excel version of 2022, the find comment option is not available in the edit group. So how can we find cells which have comments in them on a large scale?
I selected the range, entered the value in the top left cell (which is the active cell in the selection), and the used Control + Enter. So hold the Control key and press the Enter key and it will fill the same value in all the cells
Selected the range, entered a value in the active cell, and then used Control + Enter (hold the Control key and press the Enter key) instead of just using the Enter key. It fill the cell content of the active cell to all the selected cells
(ex) There are times in a cell you are waiting to get the true amount and you may insert a comment to say "the amount will be updated by Wednesday". Therefore you will know that your spreadsheet is not completed.
![[FREE EXCEL COURSE] Lesson 5 - Managing Worksheets in Excel](http://i.ytimg.com/vi/u1GZVWU7g6Q/mqdefault.jpg)
![[FREE EXCEL COURSE] Lesson 5 - Managing Worksheets in Excel](/img/tr.png)
Legends watching in 2024 😅 but it's very helpful
I am watching all these lectures in 2023😂 but its so helpful because of your standard format in which you teach everything step by step sequencialy, there are many vdos available on YT but those are not in the proper sequence , thanks for these awesome vdos😊❤
SAME HERE
man I'm surprised with how you go out of your way to show us so many uses for everything. Only on video 4 and I've already learned so much. Thanks dude.
Sir you are amazing... I recently joined office and i couldn't even do a simple thing i was so scared but now after going through your videos i find excel so interesting... Thanks to you i feel a bit confident now🙏🏻🙏🏻☺
Glad you're finding the videos useful Jessica :) All the best for your professional journey
It is very easy to learn excel made by you sumit these lock down days i am learning from u.
I was looking for this for so long, and I think I found them too late as well. But I'm very happy to get such amazing detailing of Excel, which makes it more interesting to use.
Thank you so much for the full course...!!! 😊
Thank you Sumit for sharing your knowledge and helping us learn for no cost whatsoever. Thank you.
best excel tutorial so far
thank you !
Thank you Devendra... Glad you found the video helpful 🙂
Good Job Mr Sumit. Your work is highly appreciated.
I was find advanced Excel coarse channel and I finded your channel and your all video I understand ... 😊😊
thank youuuuuu so much amazing professor very detailed, I'm watching this video in 2024 and cannot thank you enough 🙏
I have learn many things from your videos which I never know from anybody Thank you so much Sir salute to you for this Video's ❤
Thanks sir, I have just finished lesson three and now I have began understanding Excel much better
Glad you're finding the Excel course useful 🙂
Dear Sumit i am CA by profession but average in excel, but your videos are help me lot in my advanced work..... Thanks a lot..... God bless you Dear
THANKS A MILLION! YOU ARE GEM OF A TEACHER !
This man is *Amaaazzzing!*
Thank you Sumit for these videos. It is helping me so much although I'm watching this in 2024
I just started and im loving it. Thank you for all this.
Sir👏🏻you r remarkable,the way you teach is very clear to understand. Thank you so much..
Sumit, I really appreciate your efforts. Thank you.
Such a good and informative tutorial! Thank you so much.
Highly appreciated work man keep doing such more it helps a lot
May god bless u brother 🙏 what a wonderful lessons u made for us its really very simple to understand nd we are learning lots knowledge. from u its helping us more
Thank you for this series.
Hi Sumit.. thanks again.. enjoying the videos. Thanks for sharing them for free. Thumbs up!
Hello sir... I am glad to know that your channel all playlist are very useful for me and my all dough are clear...
Thanks man! You teach very well
Your video are very interesting and helpful to me.
Thanks ❤
Yes, thank you Sumit! Super helpful and easy to understand.
Great video course! Thank you
Thank you friend, you are a friend
Thank u so much it's really good. and your hard work is appreciable .
Thanks for the this course.
Thanks for the series bro
SIR I AM VERY HAPPY TO LEARN THIS LESSON BY YOU BECOUSE YOU TEACH CRYSTAL CLEAR TO NOT ANY ONE DOUBT COME IN MY MIND
Thank you sir!!
good job Mr Bansal
Amazing video
Glad you liked it 🙂
Thank you so much 😊❤
Very nice thank you for videos
Thank you!
Is these videos still relevant in 2024?
BTW very well organised, nice work sir
My dad gave meh money fir computer class and I am here❤
Thanks Sir
Great job.. thanks for making the videos like this..
Thank you sunil sir
Thanks dude
Thanks you
Really enjoying it, best regards
Helpful.....
From 1:42- 1:44, how did you copy and paste with one click/button to all the tabs?
Ctl + enter
super video yayyyyy..
thank you
keyboard shortcut to open find and replace --> Ctrl+F
Sir can you give some exercises to do for particilar lessons that you teach in this course by which student can practise this for perfection in that commands that you teach .
Sir plzz can you help me by doing this 🙏
Hi Sumit, can you please also suggest on how to memorize these steps, cause its not easy for me to remember everything you are teaching.
Just practice it
@@ProgKnowledge sir how to get free date for practicing excel any source?
Control + G is another short cut for paste special
i am a slow learner so its difficult to grab everything when its going fast.. i want to learn one at a time n be perfect in one thing than getting messed with many things. i just want to know how can i start with the very basic of using and excel especially inserting rows and coloumn and than bordering and lining them and entering data numbers ,in a simplest way. also do u give personal coaching online?
Hello. In the excel version of 2022, the find comment option is not available in the edit group. So how can we find cells which have comments in them on a large scale?
The name has been changed to 'Comments' to 'Note'.
Go for NOTE.
shift plus f5 doesnt work anymore to open special dialogue box
just telling
22:04
4:15 after selecting ctrl key, now i can't able to type.
Which key should i used to get back normal😂
how did u paste 1 in all selected cells in a go without ctrl+v???? time stamp: 1:57, can someone help?
I selected the range, entered the value in the top left cell (which is the active cell in the selection), and the used Control + Enter. So hold the Control key and press the Enter key and it will fill the same value in all the cells
How did u copy 1 number in all cells at the same time at 1:40
Selected the range, entered a value in the active cell, and then used Control + Enter (hold the Control key and press the Enter key) instead of just using the Enter key. It fill the cell content of the active cell to all the selected cells
MANY OF THESE OPTIONS ARE OBSOLETE IN EXCEL 2019 :(
m not getting the option to add comment, why so?
and thanks for the course!
(ex) There are times in a cell you are waiting to get the true amount and you may insert a comment to say "the amount will be updated by Wednesday". Therefore you will know that your spreadsheet is not completed.
these tutorials are lit man!
PS: usually indian accents are annoying, yours is perfect. Not pure english ofc, but nothing which sounds like penguin.
yeah try speaking hindi and listen it ...u will sound more annoying, may be like crow!!
@@swapnilgpt1 haha crow lmao. nice
@@swapnilgpt1 perfect!! 😂
datasheet
20 min ki videos mein 50 min ki toh ads lagwai hai
You made a mistake at 10:18 you couldn't selected entire colum
Hindi me nhi samjha sakte ho kya aap