[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

  • @Amol_5050
    @Amol_50502 ай бұрын

    Legends watching in 2024 😅 but it's very helpful

  • @laksha8888
    @laksha88889 ай бұрын

    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

    @meenakshidevanshi

    4 ай бұрын

    SAME HERE

  • @thaddcorbett2148
    @thaddcorbett21482 жыл бұрын

    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
    @ashishrawat10034 жыл бұрын

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

  • @venusv445
    @venusv44510 ай бұрын

    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
    @ryanmdsouzaa3 жыл бұрын

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

  • @jgp17
    @jgp172 жыл бұрын

    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

    @trumpexcel

    2 жыл бұрын

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

  • @mosadiq123
    @mosadiq1234 жыл бұрын

    Good Job Mr Sumit. Your work is highly appreciated.

  • @devendrapilkhane507
    @devendrapilkhane5074 ай бұрын

    best excel tutorial so far thank you !

  • @trumpexcel

    @trumpexcel

    4 ай бұрын

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

  • @priyankachourasiya9712
    @priyankachourasiya97122 жыл бұрын

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

  • @nurinamni2674
    @nurinamni26743 жыл бұрын

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

  • @AmandaMoranBANDALOOP
    @AmandaMoranBANDALOOP4 жыл бұрын

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

  • @gloriakulundu7672
    @gloriakulundu76726 ай бұрын

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

  • @trumpexcel

    @trumpexcel

    6 ай бұрын

    Glad you're finding the Excel course useful 🙂

  • @jackiegonzalez2340
    @jackiegonzalez23406 ай бұрын

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

  • @vickeyvloger9014
    @vickeyvloger90149 ай бұрын

    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 ❤

  • @anuvinu25
    @anuvinu25 Жыл бұрын

    THANKS A MILLION! YOU ARE GEM OF A TEACHER !

  • @user-jm7ux9gd8f
    @user-jm7ux9gd8f4 жыл бұрын

    Sumit, I really appreciate your efforts. Thank you.

  • @bhavikvora6997
    @bhavikvora69972 жыл бұрын

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

  • @uprayup
    @uprayup3 жыл бұрын

    This man is *Amaaazzzing!*

  • @wayneedmondson1065
    @wayneedmondson10655 жыл бұрын

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

  • @harshgehlot1430
    @harshgehlot143010 ай бұрын

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

  • @Govindkumar-xl3gs
    @Govindkumar-xl3gs3 жыл бұрын

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

  • @NicolasBelkin
    @NicolasBelkin4 жыл бұрын

    Thanks man! You teach very well

  • @ayubshaikh8542
    @ayubshaikh85423 жыл бұрын

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

  • @rinkuthakur2888
    @rinkuthakur28884 жыл бұрын

    Your video are very interesting and helpful to me.

  • @priyankasaha9133
    @priyankasaha91336 ай бұрын

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

  • @SnapWild164
    @SnapWild1643 жыл бұрын

    Thank you for this series.

  • @TheHoshmanddeeba
    @TheHoshmanddeeba4 жыл бұрын

    Really enjoying it, best regards

  • @shwethareddy407
    @shwethareddy407 Жыл бұрын

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

  • @samarthdeshpande8738
    @samarthdeshpande87383 жыл бұрын

    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

  • @FamilyWanderLust-iz1fc
    @FamilyWanderLust-iz1fc7 ай бұрын

    Great video course! Thank you

  • @priyankachourasiya9712
    @priyankachourasiya97122 жыл бұрын

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

  • @pradeeptarak8217
    @pradeeptarak821710 ай бұрын

    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

  • @margad-erdeneboldbaatar4704
    @margad-erdeneboldbaatar47042 жыл бұрын

    Thanks for the this course.

  • @ankitverma9003
    @ankitverma9003 Жыл бұрын

    Thanks for the series bro

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

    Very nice thank you for videos

  • @keweiteh871
    @keweiteh8714 жыл бұрын

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

  • @ashwindeshmukh6853

    @ashwindeshmukh6853

    4 жыл бұрын

    Ctl + enter

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

    Thank you so much 😊❤

  • @lucasoliveira7016
    @lucasoliveira70162 жыл бұрын

    Thank you friend, you are a friend

  • @zain...4187
    @zain...418715 күн бұрын

    Thanks ❤

  • @PersianPartyRock
    @PersianPartyRock3 жыл бұрын

    Thank you!

  • @eliasgivans7973
    @eliasgivans797310 ай бұрын

    Thank you sir!!

  • @mohammadirkanansari671
    @mohammadirkanansari6713 жыл бұрын

    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

  • @krishnasathya5272
    @krishnasathya52724 жыл бұрын

    thank you

  • @Kawsarjamil
    @Kawsarjamil4 жыл бұрын

    good job Mr Bansal

  • @AD-pe8mo
    @AD-pe8mo4 жыл бұрын

    Helpful.....

  • @manishsoni1652
    @manishsoni16522 жыл бұрын

    super video yayyyyy..

  • @simuislam5752
    @simuislam57522 жыл бұрын

    Thanks you

  • @Wisal911
    @Wisal91111 ай бұрын

    Thanks dude

  • @himi1509
    @himi15092 жыл бұрын

    Thanks Sir

  • @swazahswazah9571
    @swazahswazah9571 Жыл бұрын

    Thank you sunil sir

  • @adityapatil6323
    @adityapatil63235 ай бұрын

    Amazing video

  • @trumpexcel

    @trumpexcel

    4 ай бұрын

    Glad you liked it 🙂

  • @yatharthagarwal7770
    @yatharthagarwal77703 ай бұрын

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

  • @DeepaShetty-nq3yj
    @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.

  • @mtxdollaryt7395

    @mtxdollaryt7395

    8 ай бұрын

    Just practice it

  • @dgopalsuri

    @dgopalsuri

    7 ай бұрын

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

  • @madcap4444
    @madcap44447 ай бұрын

    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
    @sayemmurtaza54902 жыл бұрын

    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

    @shivamkrsinha777

    Жыл бұрын

    The name has been changed to 'Comments' to 'Note'. Go for NOTE.

  • @darvinbisen6361
    @darvinbisen636115 күн бұрын

    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 🙏

  • @vishruthtallam1587
    @vishruthtallam15873 жыл бұрын

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

  • @BEYOUNCkk26
    @BEYOUNCkk2623 күн бұрын

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

  • @alokranjan7323
    @alokranjan73232 жыл бұрын

    Control + G is another short cut for paste special

  • @Updatesbysachin
    @Updatesbysachin3 ай бұрын

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

  • @swapnilgpt1
    @swapnilgpt14 жыл бұрын

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

  • @uprayup

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

  • @hamsinich5716
    @hamsinich57163 жыл бұрын

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

  • @trumpexcel

    @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

  • @sisterafsheentajweed735
    @sisterafsheentajweed7354 жыл бұрын

    MANY OF THESE OPTIONS ARE OBSOLETE IN EXCEL 2019 :(

  • @learnwithsimple
    @learnwithsimple3 жыл бұрын

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

  • @MuskaanSareen
    @MuskaanSareen2 ай бұрын

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

  • @trumpexcel

    @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

  • @rajvideocreations
    @rajvideocreations Жыл бұрын

    22:04

  • @deekshasingh5209
    @deekshasingh5209 Жыл бұрын

    datasheet

  • @RohitThakur-zb2wi
    @RohitThakur-zb2wi10 ай бұрын

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

  • @LUCKYTECHTUBE
    @LUCKYTECHTUBE5 ай бұрын

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

  • @yashuchettri3053
    @yashuchettri3053 Жыл бұрын

    Hindi me nhi samjha sakte ho kya aap

  • @snowty96
    @snowty964 жыл бұрын

    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

    @swapnilgpt1

    4 жыл бұрын

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

  • @kishorekumar624

    @kishorekumar624

    4 жыл бұрын

    @@swapnilgpt1 haha crow lmao. nice

  • @sonalikundu4981

    @sonalikundu4981

    2 жыл бұрын

    @@swapnilgpt1 perfect!! 😂