5 Google Sheets Tips Every User Should Know!
Google Sheets can transform your data in so many ways. But do you know these 5 spreadsheet tips? In this video, Scott Friesen shares his favorite ways of managing and editing data within Google Sheets.
If you are looking for the formula for Tip #4 (QR Code), please see the pinned comment below.
00:00 Introduction
00:22 Use Sparkline to insert small graph
02:06 Share comments and notifications directly to others
04:20 Validate email addresses in Google Sheets
06:42 Create QR Codes within Google Sheets
09:38 Clean up and trim name fields
---
► SUBSCRIBE to the Simpletivity channel: kzread.info...
► Get your FREE productivity guide: www.simpletivity.com/free
► Visit the website: www.simpletivity.com
Let's Connect!
Facebook: / simpletivity
LinkedIn: / scottdfriesen
Twitter: / scottdfriesen
Instagram: / scottdfriesen
Scott Friesen is a productivity specialist and founder of Simpletivity training and consulting. He is also a prolific public speaker, workshop leader, and time management coach.
Icons made by Freepik from www.flaticon.com
#simpletivity #googledrive #googlesheets
Пікірлер: 415
Here is the formula you will need to use for Tip #4 (QR Code). Just remember to replace 'A1' with the cell you want to reference: =IMAGE("chart.googleapis.com/chart?chs=200x200&cht=qr&chl="&A1&"")
@mysamdinarvand2749
4 жыл бұрын
This code is developed of your code with High error correction and can detect text and Url: =IMAGE("chart.googleapis.com/chart?chs=500x500&cht=qr&chld=H&chl="&A1&")")
@mysamdinarvand2749
4 жыл бұрын
+simpletivity please view my reply
@krackr8089
4 жыл бұрын
The QR code to is useful. Thanks 👍
@koleksidoank
4 жыл бұрын
How to add user id in the google sheet automatically when those user id make any changes in the cell?
@rastatekk
4 жыл бұрын
@@koleksidoank it's done automatical by google. Rightclick in any cell with content, in the meneu is a option called Changehistory (shows history of that cell) Or if you want to see history of the whole document go to file versionhistory. (Not sure if the names are perfectly correct - i use the german UI )
Great tips, Scott! Just a point on copying the QR codes. If you copy and paste this QR code, you'll be pasting the formula, which would be taking the values from a different relative cell and therefore generate a different QR code. You would need to right-click, Paste Special, Paste Values Only. Then you get the exact copy of the original QR code you created.
@TheTruthSeeker756
3 жыл бұрын
Amen. I noticed that the QR code was different
@PhilHibbs
3 жыл бұрын
Ctrl-shift-v will paste as values
@robinherrick2177
Жыл бұрын
@@meilinchen138 paste values is only a command within Sheets
Your channel is pure GOLD. After finding it, I am like a sponge absorbing all the possibilities of Google Suite. My company is now making the transition from Microsoft to Google, and you can imagine how happy I am that I found your channel. You are very easy to follow and understand in a practical way, which is not so often to seen on product reviewers online. Keep it up with the good job👍🙏
Love the QR code one! For tip 5 they created a new command called “trim white spaces” no formulas, copy and paste values, which is lovely!
another great tip. Thanks, Scott.
Thanks for some cool tips. I love the array formulas. You have to edit your traditional formulas to work with it but it really streamlines your sheets and helps then run more efficiently and it works with most your other formulas. Eg. On the Trim formula you would need to show "how" to expand it by including the colum: =trim(A2) becomes =arrayformula(trim(A$2:A))
I learned so much from this video that I can apply right now in marketing and running my business. Thanks so much for the great tips. Keep 'em coming! I like to find free ways to increase productivity and efficiency so I can use them myself and help others by sharing.
Great tips! Especially the cleaning up email and names, super handy.
@Simpletivity
4 жыл бұрын
Glad you liked it!!
I’m only on number 2, and I must say, you’ve already provided value. Thank you, buddy
@Simpletivity
4 жыл бұрын
You are very welcome!
Thank you for having such a detailed video description. Great info 👍🏼
Thanks, Scott. I use macros to save time. You can automate a lot of repetitive tasks.
@Simpletivity
5 жыл бұрын
That's a great tip. Thanks for sharing.
the trim is what i look for. ! thank you so much
Amazing! I learn something new today. Thanks so much for sharing!
Sparkline trick is insane!
@Simpletivity
4 жыл бұрын
Glad you liked that one.
Wow that Trick with the QR Code is amazing!! Thanks for the inspiration!
Yup, love these. Didn’t know the first one but that’s really cool.
Awesome stuff, I'm new to Google docs and this was very helpful!
Lately, In google sheets, I have been putting functions in array formulas to avoid dragging down cells whenever I add new data. I like the sparkling, the QR code, and the trim functions that I learned in this video.
LEFT(A2,FIND(" ",A2)-1), Get the first word from a string. EOMONTH(TODAY(),-1)+1, First day of a month. EOMONTH(C2,0), last day of month. Seems I'm using these more as I get skilled more with Google Sheets. Nice tutorial, Thanks! Oh, and I keep a list of formulas/functions/app scripts I use often. Good idea for other users of Sheets to keep.
@Simpletivity
5 жыл бұрын
Thanks for sharing!
@elvischong9334
4 жыл бұрын
John Deir Thanks for sharing these 3 formula. It's really very useful. Thank you.
Thanks for sharing. Other favorites from my list (and reflexing at this moment) Combination of Filter with Sum countA, importrange, substitute, iferror+arrayformula+vlookup Keep Sharing. 👍
@Simpletivity
4 жыл бұрын
Thanks for sharing!
Thank you very much... I love your tips with QR Code :)
This is great! Just don’t forget to copy- Paste values before deleting the source column! Trim seems more powerful in Google Sheets than the last time I used it in Excel - it didn’t read the extra spaces between words. Sometimes, data cleaning takes longer than actually using or analyzing data!
@Simpletivity
5 жыл бұрын
Good point. Thanks for sharing!
@jacksonmacd
5 жыл бұрын
@@Simpletivity and when you forget to do that... Ctrl-z to the rescue
Super helpful!! Thank you
Love the QR code. Next level!
Thank you so much for this video. I learn a lot.
I am just now figuring out the many different ways I can look at my data in sheets. 2 of the most handy things I have found is the 'Explore' button in the lower left corner which will do like 5 different functions with highlighted cells and will make charts off of suggested data. The other is filter view for sorting and cleaning up data. I can conditionally highlight things and then use filter view to sort the data in a way that tells me stuff or so that I can move it because I don't know how to use more advanced lookup or query functions yet.
Thank you for sharing, It's really helpful and meaningful too
There are a Couple of things it would be nice to do in Google Sheets such as Auto Expanding a Table and Auto Tables...any Ideas !?
Amazing! simply amazing,,, so useful,,,, thanks so much
Subscribed! Thanks!
Brilliant tips! Thank you
very cool. please continue expanding on this. You might get into how to connect sheets and specific cells of specific sheets.
@Simpletivity
5 жыл бұрын
Great suggestions. Thanks for adding!
@omarkhan3491
5 жыл бұрын
You can use the IMPORTRANGE function to copy an entire sheet You can combine IMPORTRANGE with the ADDRESS function to pick a specific call. There are a whole host of IMPORT functions built into Sheets that are very nifty and useful.
@michelelee890
4 жыл бұрын
I've already have done this.
@LuisAzcona
2 жыл бұрын
Use "define range" and "IMPORTRANGE"
so glad you are doing this for us bless u!
Very Interesting. Thanks for those tips... I was surprised by the QR code trick
@Simpletivity
4 жыл бұрын
You're welcome!
Thank you so much for uploading this video. It is helping me get through the pandemic!
@Simpletivity
3 жыл бұрын
You're so welcome!
This tips are awesome. I use a lot Select, If and Vlookup functions
QR code Really awesome. Thanks Man
These were completely unexpected! Thank you for the valuable data
that was something informative as well as interesting!!
Love the QR code one!
@simpletivity - a tips video on youtube that actually has useful tips that a new concept, I like it keep going
Wow these just keep getting better. Way to go Scott
@Simpletivity
2 жыл бұрын
So glad that you are enjoying my videos, Richard. Thanks for watching!
Really loving explaining
Wow! Thank you so much for such great tips!
@Simpletivity
3 жыл бұрын
You are so welcome!
Thanks. Very helpful
Thank you very much bro.
Heavy content!! Thanks!
@Simpletivity
4 жыл бұрын
You're welcome!
What a blast! Can't wait to try it out!!!!
@Simpletivity
Жыл бұрын
Have fun!
That was really useful. Every one of it. 😊👍🏼
Love all your videos ,really helpful .
@Simpletivity
2 жыл бұрын
So nice of you
WOOOOOOW. Crazy things. Thank you SIR
@Simpletivity
4 жыл бұрын
You are very welcome
Great tips.. very useful. My favourite sheet function is CONCAT
This is really helpful! Love this video. Thank you.
@Simpletivity
Жыл бұрын
Thanks so much, Morgan.
Great info. Thank you
Very cool. Thanks
Nice !!! Love it . Thank you 🙏🏻
@Simpletivity
4 жыл бұрын
Glad you like it!
Super helpful! Thanks!
@Simpletivity
4 жыл бұрын
You're welcome!
superb speech & dialogues delivery timing.... Great.
@Simpletivity
3 жыл бұрын
Thanks a lot
You are a life saver!
I like the script editor and being able to use JavaScript in my spreadsheet
These are cool! Thx!
Amazing!!!!
I have been watching your videos for quite some time now & I really appreciate your explanation & the tips you share. I like it keep up the good work
@Simpletivity
4 жыл бұрын
I really appreciate that! Thanks for taking the time to share.
Wow, amazing tricks. bar code generator is my favorite from this video.
@Simpletivity
4 жыл бұрын
Great to hear!
Liked your content. Subscribed!
Great tips, also great voice. Sounds like a younger version of the narrator in "The Stanley Parable".
FYI, you can double click the bottom right dark square of your first square. This fills in formulas for you for every cell to the left. You would do this instead of dragging down to fill in the formulas
@Simpletivity
5 жыл бұрын
Thanks so much for sharing this great tip!
This is really great stuff. I wish to learn how to do more on Google Sheet
@Simpletivity
4 жыл бұрын
So glad you liked this one, Jennifer.
Very good!
The QR code is interesting. Sometimes I screenshare with someone in a skype and it would be great if I showed her a sheet with links in it and she could just aim her phone at her screen and load the page. This is wonderful! Thank you!
@LanaLoveOfficial
4 жыл бұрын
Great idea!
Great information. Would love to get a bullet point in your description of what each point is and where it is on the timeline. I don't have time for the whole 12 minutes, but can quickly grab what value I need and move on. Good for me, good for you, good for all. :) Thanks for putting this together. Grabbed 2 tips and put them into my work flow.
Amazing tips! One of the reasons I don't use Google sheets as much as Excel as because I don't know all of its functions. Thank you!
@Simpletivity
5 жыл бұрын
So glad you enjoyed this one!
@genysisonline8496
4 жыл бұрын
Hi there. I will not mind teaching you some of the basics to get you started with Google Sheets...
@realsdsk
4 жыл бұрын
@@genysisonline8496 thank you for the offer but I will stick Excel for now.
@chrishart8099
4 жыл бұрын
Thank you for letting me know
@chrishart8099
4 жыл бұрын
@@Simpletivity not now
Most "top 5 videos" may have one or two useful tips. This might be the first time every single one will be put to use. Thanks!
@Simpletivity
4 жыл бұрын
Awesome, thank you!
Amazing tips! I knew three of those already ha! But great work regardless, the QR was a gift. Thank you! You got yourself a new subscriber haha
@Simpletivity
2 жыл бұрын
Awesome, thank you!
Great usefull tricks, Thanks very much for your video .
@Simpletivity
3 жыл бұрын
You are welcome!
Tip 4 is definitely my favorite as well. Would you know how to do it for internet access and password
thanks scott this is really useful
@Simpletivity
5 жыл бұрын
You are very welcome!
I have been using Trim since Lotus 1-2-3. The rest of the information in this video is really very useful
@Simpletivity
4 жыл бұрын
Thanks for sharing, Victor.
@wlapp1107
4 жыл бұрын
Its like high school all over again, some guy bragging about using Trim.
Thank you for the Google sheet and Simple tivity.
@Simpletivity
4 жыл бұрын
You are very welcome!
This is the best content now
Great tips! Thank you for sharing.
@Simpletivity
4 жыл бұрын
You are very welcome. Thanks for watching!
excellent video! i would like to know how i can open my sheets and open in the last line written! thank you!!
Great info! Thanks for sharing!
@Simpletivity
5 жыл бұрын
Thanks for watching!
Thanks for the amazing tips! The best feature for me are query and importrange
@Simpletivity
4 жыл бұрын
Great to hear!
@iruns1246
4 жыл бұрын
Query is great. Especially if you have some experience with sql.
I'm a big user of query functions. Making a query based on drop-down dependent lists is neat. Creating your owns formulas in GAS is so powerful as well. Love hopping in and typing something up that I need.
A Classical Tips. Keep On...
Wooot, it saves a lot of effort
Great info. Tnx! But it's kinda lengthy for the topic.
Amazing
Google finance formulae are some of my favourites for stock markets.
You are extra genius 👏 Great Good and very informative video
I would love to use google sheets for a payroll tracker. Do you have any templates or suggestions?
Thanks for Tips. I tried to proceed some new functions in Excel 2016, 2019 , for instance (Filter, Unique,...etc), but it does not work. However it works properly in Google Sheet. My question now how can i utilize it in google sheet then copy it back in excel 2016 as i can not completely depend on Google sheet. Or what is the alternative process to overcome this problem (to use new functions in excel 2016). awaiting for your kind support.
Thanks a ton for all this, Scott. Btw, an out-of-topic question: What font is being used in the sheet at 05:30 ? Looks beautiful.
Cool Video!
Cool stuff
If I already have an image file name from Google Drive on my sheets, can it automatically using formula display images on my sheet not manually? thank you
Thank you.
Very helpful for me. Plz create more content like this!!!
@Simpletivity
4 жыл бұрын
You got it! Thanks for sharing.
Good Work