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

[@laksha8888]

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]

SAME HERE

[@TOACQUIRE111]

Me reading your comment in 2025

[@thaddcorbett2148]

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.

[@devendrapilkhane507]

best excel tutorial so far thank you !

[@trumpexcel]

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

[@durga8868]

Shortcuts 4:04 Ctrl key (to select non-adjacent cells) 4:30 to select entire row/column 4:53 column + shift +arrow keys (extend the selection) 4:58 row+ shift + arrow keys(extend the selection) 5:17 Ctrl + space ( to select entire column) 5:26 Shift + Space( to select entire Row) 5:41 Ctrl+A 6:47 to replicate change in one sheet to multiple sheets by grouping Ctrl + select your sheet 8:00 insert cells or column

[@ashishrawat1003]

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

[@jgp17]

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]

Glad you're finding the videos useful Jessica :) All the best for your professional journey

[@venusv445]

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]

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

[@priyankachourasiya9712]

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

[@mosadiq123]

Good Job Mr Sumit. Your work is highly appreciated.

[@Amol_5050]

Legends watching in 2024 😅 but it's very helpful

[@someonet]

True

[@ananthavenkata]

Thank You for this, watching in 2024❤

[@gloriakulundu7672]

Thanks sir, I have just finished lesson three and now I have began understanding Excel much better

[@trumpexcel]

Glad you're finding the Excel course useful 🙂

[@anilkumar-vx7it]

Super explanation sir❤

[@uprayup]

This man is *Amaaazzzing!*

[@anuvinu25]

THANKS A MILLION! YOU ARE GEM OF A TEACHER !

[@vickeyvloger9014]

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 ❤

[@jackiegonzalez2340]

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

[@harshgehlot1430]

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

[@samarthdeshpande8738]

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

[@wayneedmondson1065]

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

[@FamilyWanderLust-iz1fc]

Great video course! Thank you

[@pradeeptarak8217]

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

[@nurinamni2674]

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

[@anudeepyelkoti6982]

Sir thank you your videos have improved my efficiency

[@bhavikvora6997]

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

[@lucasoliveira7016]

Thank you friend, you are a friend

[@NicolasBelkin]

Thanks man! You teach very well

[@user-jm7ux9gd8f]

Sumit, I really appreciate your efforts. Thank you.

[@shwethareddy407]

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

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@ankitverma9003]

Thanks for the series bro

[@SnapWild164]

Thank you for this series.

[@priyankasaha9133]

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

[@rinkuthakur2888]

Your video are very interesting and helpful to me.

[@priyankachourasiya9712]

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

[@MuhammadSohaib-qm6iw]

Very nice thank you for videos

[@Govindkumar-xl3gs]

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

[@mohammadirkanansari671]

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

[@adityapatil6323]

Amazing video

[@trumpexcel]

Glad you liked it 🙂

[@eliasgivans7973]

Thank you sir!!

[@ayubshaikh8542]

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

[@MonkeyDLuffy-zi9vi]

Thank you so much 😊❤

[@TheHoshmanddeeba]

Really enjoying it, best regards

[@PersianPartyRock]

Thank you!

[@swazahswazah9571]

Thank you sunil sir

[@Wisal911]

Thanks dude

[@zain...4187]

Thanks ❤

[@himi1509]

Thanks Sir

[@Kawsarjamil]

good job Mr Bansal

[@keweiteh871]

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

[@ashwindeshmukh6853]

Ctl + enter

[@pratikshajain6379]

Ctrl G for the back option after changing any function in Excel is it available in Microsoft 2013

[@manishsoni1652]

super video yayyyyy..

[@AD-pe8mo]

Helpful.....

[@krishna.sathya]

thank you

[@ushnahassan1564]

the shortcut key of copying data by selecting it and then press control key is not working in my laptop when i press the control key it shows options like formatting, charts, totals.

[@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]

Just practice it

[@dgopalsuri]

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

[@yatharthagarwal7770]

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

[@pratikshajain6379]

Please explain sumit how to delete delete directly without using any key

[@darvinbisen6361]

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 🙏

[@MuskaanSareen]

how did u paste 1 in all selected cells in a go without ctrl+v???? time stamp: 1:57, can someone help?

[@trumpexcel]

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

[@madcap4444]

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?

[@sayemmurtaza5490]

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.

[@vishruthtallam1587]

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

[@alokranjan7323]

Control + G is another short cut for paste special

[@Hamsini_ReddyK]

How did u copy 1 number in all cells at the same time at 1:40

[@trumpexcel]

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

[@Updatesbysachin]

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

[@durga8868]

11:36 16:12

[@rajvideocreations]

22:04

[@BEYOUNCkk26]

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

[@learnwithsimple]

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

[@swapnilgpt1]

m not getting the option to add comment, why so? and thanks for the course!

[@uprayup]

(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.

[@snowty96]

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]

yeah try speaking hindi and listen it ...u will sound more annoying, may be like crow!!

[@kishorekumar624]

@@swapnilgpt1 haha crow lmao. nice

[@sonalikundu4981]

@@swapnilgpt1 perfect!! 😂

[@LUCKYTECHTUBE]

You made a mistake at 10:18 you couldn't selected entire colum

[@sisterafsheentajweed735]

MANY OF THESE OPTIONS ARE OBSOLETE IN EXCEL 2019 :(

[@deekshasingh5209]

datasheet

[@RohitThakur-zb2wi]

20 min ki videos mein 50 min ki toh ads lagwai hai

[@yashuchettri3053]

Hindi me nhi samjha sakte ho kya aap

[@simuislam5752]

Thanks you