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
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
Жыл бұрын
That's a great tip, Jack. Thanks for sharing!
Great video!
Couple of nice ones there Scott! Thanks again. 😁
@Simpletivity
Жыл бұрын
Any time, Bill!
Data cleanup and column stats are features that I wasn't aware of before. Thanks Scott.
@Simpletivity
Жыл бұрын
You are very welcome, Ajay.
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?
Thank you 👍
@Simpletivity
Жыл бұрын
You bet!
Thanks sir
@Simpletivity
Жыл бұрын
Welcome
More good sheet video
Thanks
@Simpletivity
Жыл бұрын
Welcome
We need more and advance video of Google sheets, please upload