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

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

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

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

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

[@wendyp2011]

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

[@LearnWithSeb]

I'm so glad! Happy to help.

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

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

[@ultradragontamer]

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

[@timothycrossley]

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

[@LearnWithSeb]

Thanks Timothy.

[@NatalieDemott]

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

[@KathleenGuillot]

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

[@ShirleyBHunggim]

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

[@HelpMeOutGuides]

Great Video!

[@a.nahari380]

Thanks man. That really helps

[@Srinivasan.Answers]

Useful tips. Thank you

[@LearnWithSeb]

Welcome 😊

[@mahmoudmuhiz1073]

Really needed this, Thank you so much Sir.

[@PauPiang]

Simple yet perfect 12mins learning

[@leekspinner]

thank you so much! great video!

[@pancux670]

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

[@information2121]

I really needed such information THANK YOU

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

[@chinyererachel]

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

[@robmorris3838]

Top Class - Really useful, great video - Thanks!

[@ashaingunasekera5531]

Very useful tips! Thanks! 👏🏻

[@BrookeT9462]

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

[@annasokol9940]

So helpful!!! Thank you!!

[@ghilly_one1720]

super SUPER useful. thank you so much.

[@anymancandoitwiththerightools]

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

[@ProspectivePlans]

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

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

[@jessejames4444]

Great video, well explained! Thank you.

[@EdemFechi]

Thank you so much for this video ❤

[@mmihza]

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

[@elizaporras2612]

Wow! Thanks

[@LearnWithSeb]

Welcome!

[@bilkishvazifdar8101]

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

[@griseldayoshikawa280]

Thank you so much for your help. 😊

[@sanjaybiswas7926]

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

[@LearnWithSeb]

Thanks

[@billilondin]

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

[@LearnWithSeb]

Thanks

[@JamesEnTennessee]

Very useful....thank you!

[@rukevweoghwe2882]

Thank you so much for this great content!

[@dylanbowater5986]

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

[@john1802]

Very useful and well done tutorial. Thank you

[@nik.p2]

Nice! helpful video

[@victor25021983]

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

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

[@davidblyth5495]

An excellent tut! Thanks!

[@IanArvinPorlaje]

its very useful Thank you so much

[@JhennyD]

Bro! you are awesome!!!

[@AnNa-hk5yg]

Thanks for the information

[@ruthsekatheentrepreneur7114]

Thx you for sharing 😊

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

[@mihirsheth3676]

Super useful. Thanks a lot for the video :)

[@illybillie9916]

Really good video

[@LearnWithSeb]

Glad you liked it. Thanks for stopping by.

[@ellagraceminada8383]

SUPER HELPFUL

[@ivoryquays6661]

Excellent teaching style. Subscribed.

[@LearnWithSeb]

Awesome, thank you!

[@tuhinfokhrul]

Thanks!

[@CutTiesWithYourCaptor]

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

[@muhammadsajidali4574]

It is very important for beginners the you sir

[@memerovira]

Gracias!♥

[@erickronquillo6959]

That ctrl + arrow made me WOW

[@minamalik7358]

Thank you sir

[@gwg9320]

great content

[@moodkn]

Thanks...!

[@sathviksoma042]

Oh my god thanks so much

[@jaagdeeipsingh8385]

Thank you..

[@MintaCreativeArts]

Brilliant video

[@Devote3]

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

[@ynacastillo]

Thank you

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

[@zeljkonisic5942]

THANKS FOR VIDEO

[@LearnWithSeb]

You're welcome. Thanks for watching,

[@usmaniqbal1836]

Perfect 👍 please share data file for practice

[@ewalletwallet4096]

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

[@leonardvillanueva4617]

Thanks for the tip for my new job hahahaha

[@AZ4ZEL666]

Thanks for this very simple but very clear guide.

[@LearnWithSeb]

You're welcome. Glad you liked it

[@mankalimanivardhan6904]

Amazing video🤩

[@LearnWithSeb]

Thank you kindly. Appreciate you for stopping by.

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

[@DanTripps]

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.

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

[@zapsuma]

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

[@mmsmg8815]

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

[@drof2th]

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

[@mayankkachhwaha225]

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

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

[@carwagenservices4571]

merci beaucoup

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

[@dineshsalunke9598]

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

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

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

[@lavissonder8502]

Nice

[@parthasview]

How to copy as picture option

[@emmanuelmorales5547]

Need a tutorial for iPads

[@curingthenaivete1642]

Do these work on excel?

[@manikantanks9715]

autocrat is what you leran to use in google sheets

[@ArtVorLord]

10:29 they are green not blu :O

[@Chekspe]

where da fuccin QUERY😢

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

[@AnaRitaGoncalves-eg3cw]

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

[@rjoptc2444]

Very helpful! Thank you!

[@debreale5236]

So helpful! Thank you!