[FREE EXCEL COURSE] Lesson 4 - Working with Cells and Ranges

Рет қаралды 297,017

Күн бұрын

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 KZfaq 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: kzfaq.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 87

@Amol_5050 2 ай бұрын

Legends watching in 2024 😅 but it's very helpful

@laksha8888 9 ай бұрын

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

@thaddcorbett2148 2 жыл бұрын

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.

@ashishrawat1003 4 жыл бұрын

It is very easy to learn excel made by you sumit these lock down days i am learning from u.

@jgp17 2 жыл бұрын

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

@venusv445 10 ай бұрын

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...!!! 😊

@ryanmdsouzaa 3 жыл бұрын

Thank you Sumit for sharing your knowledge and helping us learn for no cost whatsoever. Thank you.

@mosadiq123 4 жыл бұрын

Good Job Mr Sumit. Your work is highly appreciated.

@devendrapilkhane507 4 ай бұрын

best excel tutorial so far thank you !

@trumpexcel 4 ай бұрын

Thank you Devendra... Glad you found the video helpful 🙂

@priyankachourasiya9712 2 жыл бұрын

I was find advanced Excel coarse channel and I finded your channel and your all video I understand ... 😊😊

@jackiegonzalez2340 6 ай бұрын

thank youuuuuu so much amazing professor very detailed, I'm watching this video in 2024 and cannot thank you enough 🙏

@nurinamni2674 3 жыл бұрын

Such a good and informative tutorial! Thank you so much.

@AmandaMoranBANDALOOP 4 жыл бұрын

Yes, thank you Sumit! Super helpful and easy to understand.

@anuvinu25 Жыл бұрын

THANKS A MILLION! YOU ARE GEM OF A TEACHER !

@vickeyvloger9014 9 ай бұрын

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 ❤

@user-jm7ux9gd8f 4 жыл бұрын

Sumit, I really appreciate your efforts. Thank you.

@bhavikvora6997 2 жыл бұрын

Highly appreciated work man keep doing such more it helps a lot

@uprayup 3 жыл бұрын

This man is *Amaaazzzing!*

@gloriakulundu7672 6 ай бұрын

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 🙂

@harshgehlot1430 10 ай бұрын

I just started and im loving it. Thank you for all this.

@samarthdeshpande8738 3 жыл бұрын

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

@priyankasaha9133 6 ай бұрын

Thank you Sumit for these videos. It is helping me so much although I'm watching this in 2024

@wayneedmondson1065 5 жыл бұрын

Hi Sumit.. thanks again.. enjoying the videos. Thanks for sharing them for free. Thumbs up!

@NicolasBelkin 4 жыл бұрын

Thanks man! You teach very well

@SnapWild164 3 жыл бұрын

Thank you for this series.

@Govindkumar-xl3gs 3 жыл бұрын

Thank u so much it's really good. and your hard work is appreciable .

@rinkuthakur2888 4 жыл бұрын

Your video are very interesting and helpful to me.

@ayubshaikh8542 3 жыл бұрын

Great job.. thanks for making the videos like this..

@TheHoshmanddeeba 4 жыл бұрын

Really enjoying it, best regards

@shwethareddy407 Жыл бұрын

Sir👏🏻you r remarkable,the way you teach is very clear to understand. Thank you so much..

@FamilyWanderLust-iz1fc 7 ай бұрын

Great video course! Thank you

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks for the this course.

@pradeeptarak8217 10 ай бұрын

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

@priyankachourasiya9712 2 жыл бұрын

Hello sir... I am glad to know that your channel all playlist are very useful for me and my all dough are clear...

@ankitverma9003 Жыл бұрын

Thanks for the series bro

@keweiteh871 4 жыл бұрын

From 1:42- 1:44, how did you copy and paste with one click/button to all the tabs?

@ashwindeshmukh6853 4 жыл бұрын

Ctl + enter

@lucasoliveira7016 2 жыл бұрын

Thank you friend, you are a friend

@MuhammadSohaib-qm6iw Жыл бұрын

Very nice thank you for videos

@MonkeyDLuffy-zi9vi Жыл бұрын

Thank you so much 😊❤

@PersianPartyRock 3 жыл бұрын

Thank you!

@mohammadirkanansari671 3 жыл бұрын

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

@eliasgivans7973 10 ай бұрын

Thank you sir!!

@Kawsarjamil 4 жыл бұрын

good job Mr Bansal

@zain...4187 17 күн бұрын

Thanks ❤

@AD-pe8mo 4 жыл бұрын

Helpful.....

@krishnasathya5272 4 жыл бұрын

thank you

@swazahswazah9571 Жыл бұрын

Thank you sunil sir

@himi1509 2 жыл бұрын

Thanks Sir

@simuislam5752 2 жыл бұрын

Thanks you

@adityapatil6323 5 ай бұрын

Amazing video

@trumpexcel 5 ай бұрын

Glad you liked it 🙂

@Wisal911 11 ай бұрын

Thanks dude

@sayemmurtaza5490 2 жыл бұрын

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.

@manishsoni1652 2 жыл бұрын

super video yayyyyy..

@madcap4444 8 ай бұрын

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?

@yatharthagarwal7770 3 ай бұрын

Is these videos still relevant in 2024? BTW very well organised, nice work sir

@darvinbisen6361 17 күн бұрын

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 🙏

@DeepaShetty-nq3yj Жыл бұрын

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.

@ProgKnowledge 9 ай бұрын

Just practice it

@dgopalsuri 7 ай бұрын

@@ProgKnowledge sir how to get free date for practicing excel any source?

@alokranjan7323 2 жыл бұрын

Control + G is another short cut for paste special

@vishruthtallam1587 3 жыл бұрын

keyboard shortcut to open find and replace --> Ctrl+F

@BEYOUNCkk26 25 күн бұрын

shift plus f5 doesnt work anymore to open special dialogue box just telling

@Updatesbysachin 3 ай бұрын

My dad gave meh money fir computer class and I am here❤

@hamsinich5716 3 жыл бұрын

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

@MuskaanSareen 2 ай бұрын

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

@sisterafsheentajweed735 4 жыл бұрын

MANY OF THESE OPTIONS ARE OBSOLETE IN EXCEL 2019 :(

@learnwithsimple 3 жыл бұрын

4:15 after selecting ctrl key, now i can't able to type. Which key should i used to get back normal😂

@swapnilgpt1 4 жыл бұрын

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.