15 POWERFUL GOOGLE SHEETS TIPS & TRICKS (Insanely Useful Productivity Tips For Beginners)

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 พ.ย. 2024

ความคิดเห็น • 116

  • @LearnWithSeb
    @LearnWithSeb  11 หลายเดือนก่อน +1

    📝 FREEBIE: Download my free CHATGPT and MIDJOURNEY Cheatsheets ►www.learnwithseb.com/go/newsletter/
    ✨Want to learn AI Marketing Secrets Used By The Top 1%. Get my AI Marketing Blueprint ►www.learnwithseb.com/go/ai-marketing-blueprint/

  • @calvincrane
    @calvincrane 2 ปีที่แล้ว +53

    No silly animations and you don't feel the need to green screen your face. It's much better for the learner. Thank you for making a no nonsense tutorial.

  • @ratnadeepsaha7675
    @ratnadeepsaha7675 2 ปีที่แล้ว +49

    TIMESTAMPS:
    0:14 Lock top row
    0:54 Resize column
    1:50 Add column
    2:24 Jump to end cells
    2:58 Highlight cells
    3:28 View sum
    4:27 Flip row and column
    5:11 Add date
    7:07 Capitalise names
    7:47 Remove extra spaces
    8:10 Combine formulas
    8:56 Split text cells
    9:36 Join cells
    10:16 Filter data
    11:15 Copy style

    • @Vivian-lr2wz
      @Vivian-lr2wz ปีที่แล้ว +1

      😊😊pp😊😊😊😊😊😊😊😊😊😊😊😊p😊😊😊😊😊

    • @lami.4102
      @lami.4102 ปีที่แล้ว

      Thank you… 💜

  • @gerry8558
    @gerry8558 ปีที่แล้ว +7

    Thank you very clear directions. Easy for beginner. You covered so much great info I subscribed!

  • @NatalieDemott
    @NatalieDemott 4 วันที่ผ่านมา

    Thanks for this video it is very informative and easy to follow. Cheers!

  • @DarelJettSmith
    @DarelJettSmith ปีที่แล้ว +1

    All my conversions had a dollar sign in front of them and I had no clue how to fix it. To be honest, I had no faith you’d answer my question in this video but you sure did! Thank you!

  • @PiefacePete46
    @PiefacePete46 หลายเดือนก่อน

    Excellent, Thank you.
    I have many hundreds of Excel hours under my belt, but have not used it a great deal since retiring. I liked the idea of the portability offered by Google Docs and Sheets for a current family-related project. The task does not require much "horsepower"... mainly keeping lists and transaction details synched over multiple devices. It's working out great.
    Having watched your video, I am delighted to find how many features and shortcuts in Google Sheets are identical to the Excel equivalents. I am happiness filled!
    Thanks again... Liked & Subscribed.

  • @batchrocketproject4720
    @batchrocketproject4720 ปีที่แล้ว +9

    Excellent, thank you. Undoubtedly the most useful 12 minutes I've had today. 👍

  • @ShirleyBHunggim
    @ShirleyBHunggim 10 หลายเดือนก่อน

    This is straight forward..easy to understand. Thank you.

  • @andrewjackman8926
    @andrewjackman8926 ปีที่แล้ว

    GREAT VIDEO!!!!
    Only 1 suggestion......pasting data from outside of Sheets and want to maintain internal formatting that you're already using....
    Control - Shift - V is the fastest way to paste values only. I use it all the time.

  • @mahmoudmuhiz1073
    @mahmoudmuhiz1073 ปีที่แล้ว

    Really needed this, Thank you so much Sir.

  • @pancux670
    @pancux670 ปีที่แล้ว

    Great tips. Transpose is available as a function. You can directly reference it, instead of copy paste

  • @PauPiang
    @PauPiang ปีที่แล้ว +3

    Simple yet perfect 12mins learning

  • @KathleenGuillot
    @KathleenGuillot 10 หลายเดือนก่อน

    You have made love Data Entry again!! May the rest of your life and days be this effecient and enjoyable!

  • @ultradragontamer
    @ultradragontamer หลายเดือนก่อน

    0o0 creating Filters will be godsend for me at work! TYSM!!!!!

  • @wendyp2011
    @wendyp2011 ปีที่แล้ว +1

    OMG you answered my question in the first 30 seconds of the video! love it!

    • @LearnWithSeb
      @LearnWithSeb  ปีที่แล้ว

      I'm so glad! Happy to help.

  • @mmihza
    @mmihza 3 หลายเดือนก่อน

    Thanks for sharing those tips and tricks it made my work easier and benevolent .

  • @information2121
    @information2121 ปีที่แล้ว

    I really needed such information THANK YOU

  • @AinaRonningen
    @AinaRonningen 2 ปีที่แล้ว +4

    Thank you for the informative course; I've learned many new things! Just one thing I noticed:
    Tip 12: on mac, I had to use a semi colon instead of a comma.

  • @bibiBOWMAN
    @bibiBOWMAN หลายเดือนก่อน

    When combining for address labels, what character between the quotation marks in fx will go to new line rather than letting it wrap in awkward places?

  • @leekspinner
    @leekspinner 11 หลายเดือนก่อน

    thank you so much! great video!

  • @jessejames4444
    @jessejames4444 6 หลายเดือนก่อน

    Great video, well explained! Thank you.

  • @a.nahari380
    @a.nahari380 2 ปีที่แล้ว +1

    Thanks man. That really helps

  • @victor25021983
    @victor25021983 6 หลายเดือนก่อน

    tq bro. i surprise all little things is new knowledge for me.

  • @BrookeT9462
    @BrookeT9462 ปีที่แล้ว

    I have learned so much in this video. Thank you for uploading this. Keep it up.

  • @john1802
    @john1802 11 หลายเดือนก่อน

    Very useful and well done tutorial. Thank you

  • @ghilly_one1720
    @ghilly_one1720 2 ปีที่แล้ว

    super SUPER useful. thank you so much.

  • @Srinivasan.Answers
    @Srinivasan.Answers ปีที่แล้ว +1

    Useful tips. Thank you

  • @timothycrossley
    @timothycrossley 2 ปีที่แล้ว +2

    Thanks Seb. Another cracking video - I learned a few new tricks.

  • @EdemFechi
    @EdemFechi หลายเดือนก่อน

    Thank you so much for this video ❤

  • @griseldayoshikawa280
    @griseldayoshikawa280 5 หลายเดือนก่อน

    Thank you so much for your help. 😊

  • @anymancandoitwiththerightools
    @anymancandoitwiththerightools ปีที่แล้ว

    @7:49 Thank you for sharing this. This is huge!

  • @dylanbowater5986
    @dylanbowater5986 ปีที่แล้ว +1

    Your pronunciation of 'spreadsheet' at 11:22 had my girlfriend crying in tears! But in all seriousness, thank you for the good content.

  • @chinyererachel
    @chinyererachel 2 ปีที่แล้ว +2

    Thank you Seb, you are always on point... Great hook!

  • @annasokol9940
    @annasokol9940 8 หลายเดือนก่อน

    So helpful!!! Thank you!!

  • @sanjaybiswas7926
    @sanjaybiswas7926 2 ปีที่แล้ว +2

    Your explanation was very nice. I give you full star rating. Very pleasant voice.

  • @DanTripps
    @DanTripps 4 หลายเดือนก่อน

    Great video, Seb. Thank you. I have a question of a bit more advanced nature. I have a spreadsheet ing Google Sheets with 16 tabs. Within the 16 tabs, there are many formulas pulling information from a tab called "T1 Descriptions." I have copied duplicated T1 Descriptions and called it "T1 Descriptions." I would now like to duplicate the other 15 tabs, HOPING that they would draw information from T2 Descriptions instead of T1 Descriptions. However, I am unable. When I duplicated the 15 tabs, they still try to find information from T1 Descriptions.
    If that makes any sense, do you have any suggestions?
    Thanks.

  • @ProspectivePlans
    @ProspectivePlans 2 ปีที่แล้ว +5

    These productivity tips are just what I needed! 💫 Keep rising to be who you want to be! 💫 #keeprising #risingtobe #aswerise #riser #irise

  • @JamesEnTennessee
    @JamesEnTennessee 8 หลายเดือนก่อน

    Very useful....thank you!

  • @IanArvinPorlaje
    @IanArvinPorlaje 6 หลายเดือนก่อน

    its very useful Thank you so much

  • @AnNa-hk5yg
    @AnNa-hk5yg 10 หลายเดือนก่อน

    Thanks for the information

  • @HelpMeOutGuides
    @HelpMeOutGuides หลายเดือนก่อน

    Great Video!

  • @ashaingunasekera5531
    @ashaingunasekera5531 2 ปีที่แล้ว +1

    Very useful tips! Thanks! 👏🏻

  • @RaySpillane
    @RaySpillane 9 หลายเดือนก่อน

    Hi, some great tips, thank you. I have a question for you if you could help. I have a sheets file spanning several months on different pages. When I open the the file on an android device it always opens on the last created sheet/page, but when I open the file on desktop it always opens on the first created page & not the most recently one. I cannot find a command to make the file open on the last created page. Is there a command or formula I can insert in the sheet file to make it open on the last created page.

  • @robmorris3838
    @robmorris3838 2 ปีที่แล้ว +2

    Top Class - Really useful, great video - Thanks!

  • @rukevweoghwe2882
    @rukevweoghwe2882 2 ปีที่แล้ว +1

    Thank you so much for this great content!

  • @AZ4ZEL666
    @AZ4ZEL666 ปีที่แล้ว +1

    Thanks for this very simple but very clear guide.

    • @LearnWithSeb
      @LearnWithSeb  ปีที่แล้ว +1

      You're welcome. Glad you liked it

  • @erickronquillo6959
    @erickronquillo6959 ปีที่แล้ว

    That ctrl + arrow made me WOW

  • @drof2th
    @drof2th 2 ปีที่แล้ว

    Thanks! As a newbie, do you know if I can track birthday rewards using Google Sheets?

  • @bilkishvazifdar8101
    @bilkishvazifdar8101 2 ปีที่แล้ว +3

    Very clear a really well done video. Thank you so much for this. Was really helpful. :))

  • @ruthsekatheentrepreneur7114
    @ruthsekatheentrepreneur7114 2 หลายเดือนก่อน

    Thx you for sharing 😊

  • @davidblyth5495
    @davidblyth5495 2 ปีที่แล้ว

    An excellent tut!
    Thanks!

  • @Devote3
    @Devote3 2 หลายเดือนก่อน

    I'm watching It in 2024 and it was a great help. Thank you.

  • @CutTiesWithYourCaptor
    @CutTiesWithYourCaptor 2 ปีที่แล้ว +2

    Pressing the F4 key is a quick way to lock cell reference.

  • @elizaporras2612
    @elizaporras2612 ปีที่แล้ว +1

    Wow! Thanks

  • @mmsmg8815
    @mmsmg8815 6 หลายเดือนก่อน

    hi ,
    excellent teaching, sir i want google sheet password protect colunms A to Z and columns B to Z

  • @muhammadsajidali4574
    @muhammadsajidali4574 ปีที่แล้ว

    It is very important for beginners the you sir

  • @billilondin
    @billilondin ปีที่แล้ว +1

    I like this video a lot. It's really helpful

  • @usmaniqbal1836
    @usmaniqbal1836 ปีที่แล้ว

    Perfect 👍 please share data file for practice

  • @mayankkachhwaha225
    @mayankkachhwaha225 2 ปีที่แล้ว

    from where can I download this sheet to practice?? can you pls give the link

  • @ewalletwallet4096
    @ewalletwallet4096 ปีที่แล้ว

    How can I customize or organize the too many sheets tabs appearing at the footer of my spreadsheet?

  • @ivoryquays6661
    @ivoryquays6661 2 ปีที่แล้ว +1

    Excellent teaching style. Subscribed.

  • @zapsuma
    @zapsuma 5 หลายเดือนก่อน

    how to copy formula without draging with mouse? is it possible to use proper function without make new column?

  • @tuhinfokhrul
    @tuhinfokhrul 2 ปีที่แล้ว

    Thanks!

  • @nik.p2
    @nik.p2 10 หลายเดือนก่อน

    Nice! helpful video

  • @oppaceo
    @oppaceo 2 ปีที่แล้ว +1

    Very well done .. you have a de-stressing Voice ha ha makes things easier 2 learn .. Cheers :)

    • @LearnWithSeb
      @LearnWithSeb  2 ปีที่แล้ว

      Thanks. Glad you found it helpful.

  • @ZOANOM
    @ZOANOM ปีที่แล้ว

    I am trying to find a method to insert a column while not interrupting formulas that are calculating a running total across time from left to right. I track events that sometimes need to be inserted, and I need the same formulas to be inserted, and the ones to the right should correspondingly adjust. A simple description is that I need to copy a range of cells, including format and formulas, and insert a copy to their left, including formatting and formulas.

  • @minamalik7358
    @minamalik7358 ปีที่แล้ว

    Thank you sir

  • @sathviksoma042
    @sathviksoma042 ปีที่แล้ว

    Oh my god thanks so much

  • @ynacastillo
    @ynacastillo 7 หลายเดือนก่อน

    Thank you

  • @jamesleleji9470
    @jamesleleji9470 2 ปีที่แล้ว

    Hi , how can i get the developer tap in google sheets. I need to use combo box(Forms Control) becuae i want to create a Leave Tracker. Thanks

  • @memerovira
    @memerovira 2 ปีที่แล้ว

    Gracias!♥

  • @jaagdeeipsingh8385
    @jaagdeeipsingh8385 ปีที่แล้ว

    Thank you..

  • @asifpatni
    @asifpatni ปีที่แล้ว

    Dear Sir,
    I need your help in google sheet, how to insert blank row formula/automatically between data in google sheet.
    For Example :
    I have my working data on google sheet with 7 columns a thousand rows and in my 4th column has a city's name and I want to insert a blank row after the city's name change in my google sheet.
    Excel has that option to select the whole sheet and insert a blank row but I am a new user of google sheet and it's difficult for me for my work.
    I hope you help me for this matter

  • @illybillie9916
    @illybillie9916 ปีที่แล้ว +1

    Really good video

    • @LearnWithSeb
      @LearnWithSeb  ปีที่แล้ว

      Glad you liked it. Thanks for stopping by.

  • @moodkn
    @moodkn 11 หลายเดือนก่อน

    Thanks...!

  • @gwg9320
    @gwg9320 6 หลายเดือนก่อน

    great content

  • @mihirsheth3676
    @mihirsheth3676 2 ปีที่แล้ว

    Super useful. Thanks a lot for the video :)

  • @MaryTrinh-ih8fg
    @MaryTrinh-ih8fg 6 หลายเดือนก่อน

    omg autosize all in google sheets was driving me crazy, how would you split names if there's multiple middle names and some people have 2 -5names?

  • @JhennyD
    @JhennyD 2 ปีที่แล้ว

    Bro! you are awesome!!!

  • @dineshsalunke9598
    @dineshsalunke9598 2 ปีที่แล้ว

    do you know filter drop list short cut for google sheets?

  • @madhun8092
    @madhun8092 2 ปีที่แล้ว

    How to split paragraph text to subsequent columns?
    In excel we can delimit by selecting Other and type control J then the text in single cell will split. Can you show that and want that feature in dynamic way., so everytime I add new data it should split automatically

  • @MuskanChhabria-s6m
    @MuskanChhabria-s6m ปีที่แล้ว

    Proper function is not working in google sheets it is giving as it is formula in that cell how to do camel case the entire column?

  • @zeljkonisic5942
    @zeljkonisic5942 2 ปีที่แล้ว +1

    THANKS FOR VIDEO

    • @LearnWithSeb
      @LearnWithSeb  2 ปีที่แล้ว

      You're welcome. Thanks for watching,

  • @MintaCreativeArts
    @MintaCreativeArts ปีที่แล้ว

    Brilliant video

  • @carwagenservices4571
    @carwagenservices4571 2 ปีที่แล้ว

    merci beaucoup

  • @curingthenaivete1642
    @curingthenaivete1642 2 ปีที่แล้ว

    Do these work on excel?

  • @ellagraceminada8383
    @ellagraceminada8383 ปีที่แล้ว

    SUPER HELPFUL

  • @parthasview
    @parthasview ปีที่แล้ว

    How to copy as picture option

  • @leonardvillanueva4617
    @leonardvillanueva4617 2 ปีที่แล้ว +1

    Thanks for the tip for my new job hahahaha

  • @emmanuelmorales5547
    @emmanuelmorales5547 7 หลายเดือนก่อน

    Need a tutorial for iPads

  • @mankalimanivardhan6904
    @mankalimanivardhan6904 2 ปีที่แล้ว +1

    Amazing video🤩

    • @LearnWithSeb
      @LearnWithSeb  2 ปีที่แล้ว

      Thank you kindly. Appreciate you for stopping by.

  • @lavissonder8502
    @lavissonder8502 2 ปีที่แล้ว

    Nice

  • @ArtVorLord
    @ArtVorLord ปีที่แล้ว

    10:29 they are green not blu :O

  • @manikantanks9715
    @manikantanks9715 2 ปีที่แล้ว

    autocrat is what you leran to use in google sheets

  • @PiefacePete46
    @PiefacePete46 หลายเดือนก่อน

    I MAY BE ABLE TO HELP YOU! But probably not...
    I have just spent a stoopid amount of time trying to find out how to name, or rename a Google Sheets spreadsheet. I created a spreadsheet a few days ago, and gave it a name... easy and logical; no research requiired.
    Today, I tried to create another one, with a different name... I couldn't figure out how to change from the default name. All the search responses said much the same thing: "Click on 'File' at the top-left of the screen"... NOT ONE OF THEM SAID "IF YOU CAN'T SEE 'FILE', CLICK THE DOWN ARROW AT THE RIGHT HAND END OF THE ICON BAR"! 👎 😡
    Like a lot of things... It's easy once you know how! 🥴

  • @Chekspe
    @Chekspe หลายเดือนก่อน +1

    where da fuccin QUERY😢

  • @AnaRitaGoncalves-eg3cw
    @AnaRitaGoncalves-eg3cw 2 หลายเดือนก่อน

    Why do i hear a baby crying in the background? It can be something else, but jesus

  • @rjoptc2444
    @rjoptc2444 หลายเดือนก่อน

    Very helpful! Thank you!

  • @debreale5236
    @debreale5236 ปีที่แล้ว

    So helpful! Thank you!