7 Google Sheets Tips Every User Should Know!

Want to save time and edit Google Sheets like a pro? Well, then this list of tips is for you! In this video, Scott Friesen shares 7 different ways to get the most out of Google Sheets. From quick charts and dropdown menus to currency exchange and date formatting, you'll learn something new, guaranteed!

00:00 Adding dropdown menu or checkbox
02:41 Apply alternating colors
03:57 Sum up new rows
05:20 Dynamic currency exchange
07:02 Sparkline mini graph
08:14 Pick date from a calendar pop-up
09:37 View column stats

MY FREE GUIDE:

RESET PRODUCTIVITY MASTERCLASS:

MY FAVORITE SOFTWARE:

CONNECT WITH ME:

ABOUT ME:
Scott Friesen is a productivity specialist and founder of Simpletivity Training Inc.. He is also a prolific public speaker, workshop leader, and time management coach. Scott helps people to focus more time on what they want to get done and to experience less stress by simplifying their technology.

#simpletivity #googlesheets #sheets

[samgiroux]

I am adding the calendar trick right now!!!!

[kenji]

Love the dropdown menu bit. God bless u!

[dakshbhatnagar]

I feel QUERY and FILTER functions are absolutely great to get more done with the data

[chimak]

I like the tip about summing a growing column 👍

[HomeBudgetComputing]

Thank you. Good tips, and useful. There was one I didn't know about and will start using.

[BillRocklin]

As always ... Some really good tips Scott. I've started using Google sheets more to get svle to share easily with my team. These will really come in handy!

[fahimfaisalshantu]

Thanks for your information.its really helpful

[magniferacanal]

Really great video, a 100% recommended

[JamesStrickland]

Wow! Those are some great tips! Thank you for putting this together!

[biffcorbot]

Wow, I learned a lot of useful tips. Thank you for that video.

[frankstone]

Outstanding, very helpful.. thank you

[lauripiacentini]

Love your tips and tricks, keep them coming 😉

[liberospadaccino]

Thankx. Have you Any video of how to’ copy Gmails ( from one receiver ) to Google sheets automatically ? Thank you

[cassioalexan]

Actually those tips are not new ones, there are many other videos showing them. But the examples are good and easy to understand for those who haven't noticed these hints yet.

[KaushalPandit-ru]

Hi, I work with an export house in India, I want to make a conditional formatting time and action table, where if I miss my sample submission date, production start date and shipment it should be highlighted. If over 3 days due, color 1, if over 7 days due color 2. Pls.can you help me?