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

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:

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 #spreadsheet

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

[ajaym]

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

[BillRocklin]

Couple of nice ones there Scott! Thanks again. 😁

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

[idmakhan]

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