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.

👇 USEFUL RESOURCES I RECOMMEND and PERSONALLY USE👇

► CAMTASIA - My #1 Recommended Screen Recorder and Video Editor

► TUBEBUDDY - Grow Your YouTube Channel FAST

► FIVERR - Outsource Your Graphic Design

► NEWSLETTER - Sign up to my mailing list for tutorials straight to your inbox:

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

[ratnadeepsaha]

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

[batchrocketproject]

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

[gerry]

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

[wendyp]

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

[ProspectivePlans]

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

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

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

[gqdvjqs]

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

[sanjaybiswas]

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

[eqfrjns]

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

[andrewjackman]

GREAT VIDEO!!!!
Only 1 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.

[pancux]

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

[anymancandoitwiththerightools]

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

[timothycrossley]

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

[ShirleyBHunggim]

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

[CutTiesWithYourCaptor]

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

[chinyererachel]

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

[victor]

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

[jessejames]

Great video, well explained! Thank you.