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

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 KZbin Growth Skool Community: www.learnwithseb.com/go/youtu...
✅ Get 1000+ KZbin Titles, Hooks & Frameworks To Grow Your KZbin 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 KZbin 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

[@LearnWithSeb]

📝 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]

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]

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]

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

[@lami.4102]

Thank you… 💜

[@gerry8558]

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

[@batchrocketproject4720]

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

[@chinyererachel]

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

[@ashaingunasekera5531]

Very useful tips! Thanks! 👏🏻

[@robmorris3838]

Top Class - Really useful, great video - Thanks!

[@a.nahari380]

Thanks man. That really helps

[@debreale5236]

So helpful! Thank you!

[@rukevweoghwe2882]

Thank you so much for this great content!

[@ShirleyBHunggim]

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

[@refikguney6413]

I really needed such information THANK YOU

[@davidblyth5495]

An excellent tut! Thanks!

[@AinaRonningen]

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.

[@PauPiang]

Simple yet perfect 12mins learning

[@bilkishvazifdar8101]

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

[@ghilly_one1720]

super SUPER useful. thank you so much.

[@mahmoudmuhiz1073]

Really needed this, Thank you so much Sir.

[@leekspinner]

thank you so much! great video!

[@BrookeT9462]

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

[@mihirsheth3676]

Super useful. Thanks a lot for the video :)

[@victor25021983]

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

[@jessejames4444]

Great video, well explained! Thank you.

[@timothycrossley]

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

[@LearnWithSeb]

Thanks Timothy.

[@JamesEnTennessee]

Very useful....thank you!

[@IanArvinPorlaje]

its very useful Thank you so much

[@pancux670]

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

[@ProspectivePlans]

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

[@moodkn]

Thanks...!

[@DarelJettSmith]

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!

[@minamalik7358]

Thank you sir

[@AnNa-hk5yg]

Thanks for the information

[@tuhinfokhrul]

Thanks!

[@memerovira]

Gracias!♥

[@nicp1649]

Nice! helpful video

[@anymancandoitwiththerightools]

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

[@ynacastillo]

Thank you

[@carwagenservices4571]

merci beaucoup

[@user-gq3dv5jq3s]

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

[@jaagdeeipsingh8385]

Thank you..

[@JhennyD]

Bro! you are awesome!!!

[@muhammadsajidali4574]

It is very important for beginners the you sir

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

[@sathviksoma042]

Oh my god thanks so much

[@gwg9320]

great content

[@Srinivasan.Answers]

Useful tips. Thank you

[@LearnWithSeb]

Welcome 😊

[@ellagraceminada8383]

SUPER HELPFUL

[@wendyp2011]

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

[@LearnWithSeb]

I'm so glad! Happy to help.

[@ivoryquays6661]

Excellent teaching style. Subscribed.

[@LearnWithSeb]

Awesome, thank you!

[@MintaCreativeArts]

Brilliant video

[@elizaporras2612]

Wow! Thanks

[@LearnWithSeb]

Welcome!

[@erickronquillo6959]

That ctrl + arrow made me WOW

[@jamesleleji9470]

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

[@oppaceo]

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

[@LearnWithSeb]

Thanks. Glad you found it helpful.

[@madhun8092]

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

[@drof2th]

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

[@RaySpillane]

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.

[@john1802]

Very useful and well done tutorial. Thank you

[@zeljkonisic5942]

THANKS FOR VIDEO

[@LearnWithSeb]

You're welcome. Thanks for watching,

[@sanjaybiswas7926]

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

[@LearnWithSeb]

Thanks

[@CutTiesWithYourCaptor]

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

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

[@billilondin]

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

[@LearnWithSeb]

Thanks

[@usmaniqbal1836]

Perfect 👍 please share data file for practice

[@dylanbowater5986]

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

[@dineshsalunke9598]

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

[@illybillie9916]

Really good video

[@LearnWithSeb]

Glad you liked it. Thanks for stopping by.

[@lavissonder8502]

Nice

[@zapsuma]

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

[@mankalimanivardhan6904]

Amazing video🤩

[@LearnWithSeb]

Thank you kindly. Appreciate you for stopping by.

[@ewalletwallet4096]

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

[@AZ4ZEL666]

Thanks for this very simple but very clear guide.

[@LearnWithSeb]

You're welcome. Glad you liked it

[@mmsmg8815]

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

[@leonardvillanueva4617]

Thanks for the tip for my new job hahahaha

[@mayankkachhwaha225]

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

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

[@MaryTrinh-ih8fg]

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?

[@user-wv4mq3zl7j]

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?

[@emmanuelmorales5547]

Need a tutorial for iPads

[@parthasview]

How to copy as picture option

[@curingthenaivete1642]

Do these work on excel?

[@SnejanaJens]

10:29 they are green not blu :O

[@manikantanks9715]

autocrat is what you leran to use in google sheets

[@annasokol9940]

So helpful!!! Thank you!!