7 Google Sheets Tips that will Save You So Much Time!

Need a better workspace for your remote team? Get started with SpatialChat: lnk.spatial.chat/3Yqs5Tt
Want to save time with Google Sheets? In this video, Scott Friesen shares 7 time-saving tips that will have you working both faster and smarter. Whether you use Google Sheets for work or personal use, these tips and tricks will help you save so much time and effort!
00:00 Add a series in seconds
01:39 Clean up your sheet
03:21 Quickly filter your data
06:13 Make columns freeze in place
07:22 Make your sheets easier to read
08:42 Create drop-down menus
10:15 Visualize your data
MY FREE GUIDES:
✅ The 2-Do List Method - Build a better task list - www.simpletivity.com/free
🕑 7 Free Time-Saving Apps You Need to Know - bit.ly/freetimesavingapps
MY FAVORITE SOFTWARE:
👩 CRM for Gmail (NetHunt) - bit.ly/nethunt
📚 Best book summaries (Shortform) - shortform.com/simpletivity
📄 Powerful form builder (Jotform) - bit.ly/createjotform
📨 Easy email marketing (MailerLite) - www.mailerlite.com/a/simpleti...
CONNECT WITH ME:
📧 Sign up to my weekly email newsletter - bit.ly/scottsthoughts
🌎 My website - www.simpletivity.com
👨 Facebook: / simpletivity
📷 Instagram: / simpletivity
🔗 LinkedIn: / simpletivity
🐦 Twitter: / simpletivity
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 shares productivity tips, technology apps, time management ideas, and more to help you get more done and enjoy less stress at the same time. If you’re an entrepreneur, business owner, or professional who wants to get more out of your day, make sure to subscribe for helpful training videos ( / @simpletivity .
​​Icons made by Freepik from www.flaticon.com
#simpletivity #googlesheets #spreadsheet

Пікірлер: 16

  • @jacksonmacd
    @jacksonmacd Жыл бұрын

    Column stats was new info for me. Always find something of value in your videos. I almost always place my data with about 5 blank rows above. Then freeze the rows, then use filters just like you demonstrated. The real benefit comes after adding Subtotal() functions within the blank rows, based on the filtered data. Stuff like Sum, Count, Min, etc. They always remain visible because of the frozen rows, and they respond to the current filter. Very useful! Learned that technique about 30 years ago.

  • @Simpletivity

    @Simpletivity

    Жыл бұрын

    That's a great tip, Jack. Thanks for sharing!

  • @jessejames4444
    @jessejames4444 Жыл бұрын

    Great video!

  • @BillRocklin
    @BillRocklin Жыл бұрын

    Couple of nice ones there Scott! Thanks again. 😁

  • @Simpletivity

    @Simpletivity

    Жыл бұрын

    Any time, Bill!

  • @ajaym6795
    @ajaym6795 Жыл бұрын

    Data cleanup and column stats are features that I wasn't aware of before. Thanks Scott.

  • @Simpletivity

    @Simpletivity

    Жыл бұрын

    You are very welcome, Ajay.

  • @hwinsemius
    @hwinsemius Жыл бұрын

    Great video Scott. Thanks. 2 Questions left: 1. Did you use chapeters in this video and how can I see them in playing the video and 2. How do you make such video 's ? Which tools you use?

  • @22boali
    @22boali Жыл бұрын

    Thank you 👍

  • @Simpletivity

    @Simpletivity

    Жыл бұрын

    You bet!

  • @huzaifahshah3841
    @huzaifahshah3841 Жыл бұрын

    Thanks sir

  • @Simpletivity

    @Simpletivity

    Жыл бұрын

    Welcome

  • @idmakhan5699
    @idmakhan5699 Жыл бұрын

    More good sheet video

  • @jjrwass
    @jjrwass Жыл бұрын

    Thanks

  • @Simpletivity

    @Simpletivity

    Жыл бұрын

    Welcome

  • @idmakhan5699
    @idmakhan5699 Жыл бұрын

    We need more and advance video of Google sheets, please upload