[FREE EXCEL COURSE] Lesson 4 - Working with Cells and Ranges
In this video, you'll learn how to work with cells and ranges in Excel.
Since a worksheet in Excel is made up for cells, if you want to become proficient in Excel, you need to know how to best work with cells and ranges.
And this video will teach you exactly that.
It covers the following topics:
-- Cell address nomenclature
-- Selecting cell/ranges in Excel
-- Copying and moving cells/ranges in Excel
-- Using paste special
-- Selecting special cells
-- Using find and replace to select cells
-- Adding comments and
-- Using quick analysis
☕ If you're the videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: trumpexcel.com/learn-excel/
You can also access the Full Excel Training on KZread here: • Getting Started with E...
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: kzread.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Пікірлер: 87
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😊❤
@meenakshidevanshi
4 ай бұрын
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.
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.
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🙏🏻🙏🏻☺
@trumpexcel
2 жыл бұрын
Glad you're finding the videos useful Jessica :) All the best for your professional journey
Good Job Mr Sumit. Your work is highly appreciated.
best excel tutorial so far thank you !
@trumpexcel
4 ай бұрын
Thank you Devendra... Glad you found the video helpful 🙂
I was find advanced Excel coarse channel and I finded your channel and your all video I understand ... 😊😊
Such a good and informative tutorial! Thank you so much.
Yes, thank you Sumit! Super helpful and easy to understand.
Thanks sir, I have just finished lesson three and now I have began understanding Excel much better
@trumpexcel
6 ай бұрын
Glad you're finding the Excel course useful 🙂
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 A MILLION! YOU ARE GEM OF A TEACHER !
Sumit, I really appreciate your efforts. Thank you.
Highly appreciated work man keep doing such more it helps a lot
This man is *Amaaazzzing!*
Hi Sumit.. thanks again.. enjoying the videos. Thanks for sharing them for free. Thumbs up!
I just started and im loving it. Thank you for all this.
Thank u so much it's really good. and your hard work is appreciable .
Thanks man! You teach very well
Great job.. thanks for making the videos like this..
Your video are very interesting and helpful to me.
Thank you Sumit for these videos. It is helping me so much although I'm watching this in 2024
Thank you for this series.
Really enjoying it, best regards
Sir👏🏻you r remarkable,the way you teach is very clear to understand. Thank you so much..
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
Great video course! Thank you
Hello sir... I am glad to know that your channel all playlist are very useful for me and my all dough are clear...
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
Thanks for the this course.
Thanks for the series bro
Very nice thank you for videos
From 1:42- 1:44, how did you copy and paste with one click/button to all the tabs?
@ashwindeshmukh6853
4 жыл бұрын
Ctl + enter
Thank you so much 😊❤
Thank you friend, you are a friend
Thanks ❤
Thank you!
Thank you sir!!
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
good job Mr Bansal
Helpful.....
super video yayyyyy..
Thanks you
Thanks dude
Thanks Sir
Thank you sunil sir
Amazing video
@trumpexcel
4 ай бұрын
Glad you liked it 🙂
Is these videos still relevant in 2024? BTW very well organised, nice work sir
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.
@mtxdollaryt7395
8 ай бұрын
Just practice it
@dgopalsuri
7 ай бұрын
@@mtxdollaryt7395 sir how to get free date for practicing excel any source?
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?
@shivamkrsinha777
Жыл бұрын
The name has been changed to 'Comments' to 'Note'. Go for NOTE.
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 🙏
keyboard shortcut to open find and replace --> Ctrl+F
shift plus f5 doesnt work anymore to open special dialogue box just telling
Control + G is another short cut for paste special
My dad gave meh money fir computer class and I am here❤
m not getting the option to add comment, why so? and thanks for the course!
@uprayup
3 жыл бұрын
(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.
How did u copy 1 number in all cells at the same time at 1:40
@trumpexcel
3 жыл бұрын
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 :(
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?
@trumpexcel
2 ай бұрын
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
22:04
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
these tutorials are lit man! PS: usually indian accents are annoying, yours is perfect. Not pure english ofc, but nothing which sounds like penguin.
@swapnilgpt1
4 жыл бұрын
yeah try speaking hindi and listen it ...u will sound more annoying, may be like crow!!
@kishorekumar624
4 жыл бұрын
@@swapnilgpt1 haha crow lmao. nice
@sonalikundu4981
2 жыл бұрын
@@swapnilgpt1 perfect!! 😂