Top 10 Google Sheets Tips for Productive Professionals!

👨🏻‍💻 If you're anything like me, you love yourself a sexy Google Sheets or Microsoft Excel spreadsheet. In this video I share the Top 10 Google Sheets Tips for Productive Professionals so you can increase your efficiency at work and come off as more professional at the same time!

If you're trying to increase productivity at work, then getting better at creating, managing, and sharing Google Sheets or Excel spreadsheets should probably be top of mind for you. While you don't have to know crazy advanced formulas and Google Sheets functions to impress others, making sure you get the basics right will allow you utilize more "fancy" tips and tricks. For example yes you can create drop-down menus using the Data Validation feature but you can also use "Insert, Checkboxes" to upgrade the look and feel of your spreadsheet.

Or if you're pressed for time you can use the "Organization Chart" feature to quickly create an org chart directly in Google Sheets and paste the linked image into Google Slides.

Hope you enjoy this video made specifically for productive students and professionals and please let me know if you notice an increase in efficiency and/or productivity! 🌟

TIMESTAMPS
00:00 Create Filtered View
02:30 Link to Custom Range
02:54 Protect and Lock Ranges
03:39 Show Edit History
04:34 Create Org Chart Quickly
05:37 Turn Off Notifications
06:10 Best Formatting Tips
07:39 Copy Tab Quickly
08:26 Remove Duplicates
09:10 Convert Currencies

RESOURCES I MENTION IN THE VIDEO

MY FAVORITE GEAR

MY FAVORITE SOFTWARE

BE MY FRIEND:
👋🏻 Clubhouse - @jsushie

👨🏻‍💻 WHO AM I:
I'm Jeff, a full time Product Marketer. In my spare time I like to tinker with tools and create systems that help me get things done faster - or as one of my friends puts it: "Get better at being lazy" 😏

PS: Some of the links in this description are affiliate links I get a kickback from 😇

Disclaimer: My opinions are my own and may not reflect that of my employer

#googleSheets #excel #productivity

[JeffSu]

Have you ever received a spreadsheet that you were instantly impressed with? 😏

TIMESTAMPS
00:00 Create Filtered View
02:30 Link to Custom Range
02:54 Protect and Lock Ranges
03:39 Show Edit History
04:34 Create Org Chart Quickly
05:37 Turn Off Notifications
06:10 Best Formatting Tips
07:39 Copy Tab Quickly
08:26 Remove Duplicates
09:10 Convert Currencies

[ksmith]

If someone would've told me five years ago that I'd be enjoying watching Google sheets instructional videos, I would've told them they were crazy. You've made the 'overwhelming' into 'easily understood and actionable'. THANK YOU! 🙏🏻💛☺️

[wafiuddinsuhairi]

10 seconds into the video and already laughing like crazy..love your humor Jeff

[phillipconleyjr]

Org chart tip. CHANGED MY LIFE! Thanks dude!

[kellybingold]

This may be the most useful Google Sheets video I've ever seen. Clear, concise and informative. Nice work!

[klomax]

Excellent video! I will using the tip to protect part of my sheet today! 🙌🏽👍🏽👏🏽💃🏽

[carolene-meli-ghostwriter]

i have been in google sheets all week creating spreadsheets, so this is amazing Jeff!

[piiak]

Okay, the organizational chart was something new. Thanks!

Btw, your G-tools series has really changed my life. I suddenly am able to manage my workload and, honestly, feel guilty because I no longer feel like I'm drowning like everyone else 😁🙈 But it's also a bit frustrating when I'm trying to share the good and no one believes that these actually help 🤦🏼‍♀️

[bebelynsemiho]

I find your video amazing. Its easy to understand. Impressive!

[SeanClarke]

That currency tip is awesome. More like that please Jeff.

[kevinlamboy]

Thanks great video. Your channel has been super helpful. Just wanted to say thank you.

[shirosahab]

Bro your videos and thumbnails are of the best quality I have seen by far.. keep doing it.. you are rocking🔥🔥💪💪

[lafamillecarrington]

I'm retired, and no longer have to deal with spreadsheets - but here I am! Love an array formula.

[thamonwanbanjongkliang]

Thank you so much for making this video, Jeff. This is awesome!

[JuanGarcia-judm]

This is awesome, Jeff! Thank you for taking the time to share this valuable info.

[janeo]

Thanks! I didn’t know about the check box
Also lol on the empty tab for the sake of tab grouping!!

[geriivagyok]

OMG that filtered view is a life saver! Thanks a lot!

[akhilachanta]

I barely even know the basics of spreadsheets. This was an excellent Foray into that undiscovered land. Thanks Jeff.

[eagleeyemind]

These were sick, I wonder if I'll ever need to use them ever though haha. Thanks Jeff

[mariaisabelescobar]

I love you you made my job alot easier I have no experience what so ever and just by looking at your videos I am improving in my job that you