KZhead
Тәжірибелік нұсқаулар және стиль

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

Learn With Seb
2024 ж. 20 Мам.
222 621 Рет қаралды
Жүктеу

In this video I’m going to show you 15 useful Google Sheets Tips & Tricks to help you save time and improve your productivity. These are 15 powerful Google Sheets Time-Savers you wish you knew earlier.
📝 FREEBIE: Download my free CHATGPT and MIDJOURNEY Cheatsheets ►www.learnwithseb.com/go/newsl...
🎓 Join my FREE KZhead Growth Skool Community: www.learnwithseb.com/go/youtu...
✅ Get 1000+ KZhead Titles, Hooks & Frameworks To Grow Your KZhead Channel: www.learnwithseb.com/go/youtu...
👇 USEFUL RESOURCES I RECOMMEND and PERSONALLY USE👇
► CAMTASIA - My #1 Recommended Screen Recorder and Video Editor
bit.ly/2N1rV5o
► TUBEBUDDY - Grow Your KZhead Channel FAST
www.tubebuddy.com/Learnwithseb
► FIVERR - Outsource Your Graphic Design
track.fiverr.com/visit/?bta=1...
► NEWSLETTER - Sign up to my mailing list for tutorials straight to your inbox:
www.Learnwithseb.com

Пікірлер

  • 📝 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/

    @LearnWithSeb@LearnWithSeb5 ай бұрын

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

    @calvincrane@calvincrane Жыл бұрын

  • 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

    @ratnadeepsaha7675@ratnadeepsaha7675 Жыл бұрын

    • 😊😊pp😊😊😊😊😊😊😊😊😊😊😊😊p😊😊😊😊😊

      @Vivian-lr2wz@Vivian-lr2wz Жыл бұрын

    • Thank you… 💜

      @lami.4102@lami.41029 ай бұрын

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

    @AinaRonningen@AinaRonningen Жыл бұрын

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

    @batchrocketproject4720@batchrocketproject4720 Жыл бұрын

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

    @gerry8558@gerry8558 Жыл бұрын

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

    @chinyererachel@chinyererachel Жыл бұрын

  • So helpful! Thank you!

    @debreale5236@debreale52369 ай бұрын

  • Simple yet perfect 12mins learning

    @PauPiang@PauPiang Жыл бұрын

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

    @bilkishvazifdar8101@bilkishvazifdar8101 Жыл бұрын

  • Top Class - Really useful, great video - Thanks!

    @robmorris3838@robmorris3838 Жыл бұрын

  • 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!

    @DarelJettSmith@DarelJettSmith Жыл бұрын

  • Thank you so much for this great content!

    @rukevweoghwe2882@rukevweoghwe28822 жыл бұрын

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

    @ProspectivePlans@ProspectivePlans2 жыл бұрын

  • Thanks man. That really helps

    @a.nahari380@a.nahari380 Жыл бұрын

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

    @BrookeT9462@BrookeT9462 Жыл бұрын

  • Very useful tips! Thanks! 👏🏻

    @ashaingunasekera5531@ashaingunasekera5531 Жыл бұрын

  • An excellent tut! Thanks!

    @davidblyth5495@davidblyth5495 Жыл бұрын

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

    @ShirleyBHunggim@ShirleyBHunggim4 ай бұрын

  • 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

    @madhun8092@madhun8092 Жыл бұрын

  • SUPER HELPFUL

    @ellagraceminada8383@ellagraceminada83838 ай бұрын

  • Really needed this, Thank you so much Sir.

    @mahmoudmuhiz1073@mahmoudmuhiz10736 ай бұрын

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

    @pancux670@pancux6706 ай бұрын

  • I really needed such information THANK YOU

    @refikguney6413@refikguney641311 ай бұрын

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

    @andrewjackman8926@andrewjackman89266 ай бұрын

  • thank you so much! great video!

    @leekspinner@leekspinner5 ай бұрын

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

    @ZOANOM@ZOANOM Жыл бұрын

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

    @timothycrossley@timothycrossley2 жыл бұрын

    • Thanks Timothy.

      @LearnWithSeb@LearnWithSeb2 жыл бұрын

  • Gracias!♥

    @memerovira@memerovira Жыл бұрын

  • Great video, well explained! Thank you.

    @jessejames4444@jessejames44444 күн бұрын

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

    @RaySpillane@RaySpillane3 ай бұрын

  • Thanks for the information

    @AnNa-hk5yg@AnNa-hk5yg3 ай бұрын

  • Very useful....thank you!

    @JamesEnTennessee@JamesEnTennessee2 ай бұрын

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

    @anymancandoitwiththerightools@anymancandoitwiththerightools7 ай бұрын

  • super SUPER useful. thank you so much.

    @ghilly_one1720@ghilly_one1720 Жыл бұрын

  • merci beaucoup

    @carwagenservices4571@carwagenservices45712 жыл бұрын

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

    @victor25021983@victor2502198315 күн бұрын

  • Thanks...!

    @moodkn@moodkn5 ай бұрын

  • Thanks!

    @tuhinfokhrul@tuhinfokhrul Жыл бұрын

  • Super useful. Thanks a lot for the video :)

    @mihirsheth3676@mihirsheth3676 Жыл бұрын

  • 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

    @jamesleleji9470@jamesleleji9470 Жыл бұрын

  • Thank you sir

    @minamalik7358@minamalik73586 ай бұрын

  • Bro! you are awesome!!!

    @JhennyD@JhennyD Жыл бұрын

  • Perfect 👍 please share data file for practice

    @usmaniqbal1836@usmaniqbal18369 ай бұрын

  • its very useful Thank you so much

    @IanArvinPorlaje@IanArvinPorlaje3 күн бұрын

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

    @wendyp2011@wendyp20119 ай бұрын

    • I'm so glad! Happy to help.

      @LearnWithSeb@LearnWithSeb9 ай бұрын

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

    @user-gq3dv5jq3s@user-gq3dv5jq3s4 ай бұрын

  • Thank you..

    @jaagdeeipsingh8385@jaagdeeipsingh8385 Жыл бұрын

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

    @drof2th@drof2th Жыл бұрын

  • Nice! helpful video

    @nicp1649@nicp16494 ай бұрын

  • Thank you

    @ynacastillo@ynacastilloАй бұрын

  • Wow! Thanks

    @elizaporras2612@elizaporras26129 ай бұрын

    • Welcome!

      @LearnWithSeb@LearnWithSeb8 ай бұрын

  • Oh my god thanks so much

    @sathviksoma042@sathviksoma0428 ай бұрын

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

    @dineshsalunke9598@dineshsalunke9598 Жыл бұрын

  • It is very important for beginners the you sir

    @muhammadsajidali4574@muhammadsajidali4574 Жыл бұрын

  • Brilliant video

    @MintaCreativeArts@MintaCreativeArts Жыл бұрын

  • That ctrl + arrow made me WOW

    @erickronquillo6959@erickronquillo6959 Жыл бұрын

  • 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

    @asifpatni@asifpatni Жыл бұрын

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

    @CutTiesWithYourCaptor@CutTiesWithYourCaptor Жыл бұрын

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

    @ewalletwallet4096@ewalletwallet40965 ай бұрын

  • Useful tips. Thank you

    @Srinivasan.Answers@Srinivasan.Answers Жыл бұрын

    • Welcome 😊

      @LearnWithSeb@LearnWithSeb Жыл бұрын

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

    @sanjaybiswas7926@sanjaybiswas7926 Жыл бұрын

    • Thanks

      @LearnWithSeb@LearnWithSeb Жыл бұрын

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

    @mayankkachhwaha225@mayankkachhwaha225 Жыл бұрын

  • Excellent teaching style. Subscribed.

    @ivoryquays6661@ivoryquays66612 жыл бұрын

    • Awesome, thank you!

      @LearnWithSeb@LearnWithSeb2 жыл бұрын

  • Very useful and well done tutorial. Thank you

    @john1802@john18025 ай бұрын

  • Really good video

    @illybillie9916@illybillie99168 ай бұрын

    • Glad you liked it. Thanks for stopping by.

      @LearnWithSeb@LearnWithSeb8 ай бұрын

  • THANKS FOR VIDEO

    @zeljkonisic5942@zeljkonisic59422 жыл бұрын

    • You're welcome. Thanks for watching,

      @LearnWithSeb@LearnWithSeb2 жыл бұрын

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

    @mmsmg8815@mmsmg881516 күн бұрын

  • Nice

    @lavissonder8502@lavissonder8502 Жыл бұрын

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

    @oppaceo@oppaceo2 жыл бұрын

    • Thanks. Glad you found it helpful.

      @LearnWithSeb@LearnWithSeb Жыл бұрын

  • 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?

    @user-wv4mq3zl7j@user-wv4mq3zl7j7 ай бұрын

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

    @billilondin@billilondin Жыл бұрын

    • Thanks

      @LearnWithSeb@LearnWithSeb Жыл бұрын

  • Thanks for the tip for my new job hahahaha

    @leonardvillanueva4617@leonardvillanueva4617 Жыл бұрын

  • Thanks for this very simple but very clear guide.

    @AZ4ZEL666@AZ4ZEL6669 ай бұрын

    • You're welcome. Glad you liked it

      @LearnWithSeb@LearnWithSeb9 ай бұрын

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

    @dylanbowater5986@dylanbowater5986 Жыл бұрын

  • 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?

    @MaryTrinh-ih8fg@MaryTrinh-ih8fg18 күн бұрын

  • Amazing video🤩

    @mankalimanivardhan6904@mankalimanivardhan69042 жыл бұрын

    • Thank you kindly. Appreciate you for stopping by.

      @LearnWithSeb@LearnWithSeb2 жыл бұрын

  • Do these work on excel?

    @curingthenaivete1642@curingthenaivete1642 Жыл бұрын

  • How to copy as picture option

    @parthasview@parthasview Жыл бұрын

  • Need a tutorial for iPads

    @emmanuelmorales5547@emmanuelmorales5547Ай бұрын

  • 10:29 they are green not blu :O

    @SnejanaJens@SnejanaJens10 ай бұрын

  • autocrat is what you leran to use in google sheets

    @manikantanks9715@manikantanks9715 Жыл бұрын

  • So helpful!!! Thank you!!

    @annasokol9940@annasokol99402 ай бұрын
KZhead