Google Sheets Beginners: Remove Duplicates from a Range (22)

Google Sheets

If you are anything like me, you may find yourself regularly tidying up imported datasets or data from users that contain duplicates that could potentially corrupt your data analysis.

Fortunately, Google Sheets has a quick tool to help you to remove duplicates with a simple click of the button.

In this tutorial, I’ll cover,

  1. Why you might need to remove duplicates. 00:10
  2. How to remove duplicates for a single row 00:30
  3. How to remove duplicates that contain a header row. 01:20
  4. Removing duplicates from multiple selected rows 02:02
  5. What data ‘Remove Duplicates’ will and won’t match. 04:48
Watch this video on YouTube.

If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Linking (21)

Google Sheets 

Find out how to effectively link to websites, your own Google docs and within your very own Google Sheets. In this tutorial, I’ll cover,

  1.  Types of linking in Google Sheets 00:00
  2. Simple copy and paste approach 00:11
  3. How the link is displayed and it’s properties 00:20
  4. Add a link to an existing cell with text in it. 00:50
  5. Other access points to use the link tool. 01:22
  6. The link window tools. 01:34
  7. The shortcut command to the link tool 02:05
  8. Add both the title and the link with the link tool. 02:30
  9. Link to another Google doc in your Drive 02:48
  10. Link to another Sheet Tab within your Google Sheet 03:35
  11. Link to a cell within your Google sheet 04:30
  12. Link to a selected range within your Google Sheet 05:34
  13. Link to a specific piece of text within a string of text in a cell 04:30
  14. Different links to different pieces of text within a cell 07:22
  15. Get a URL to a specific cell in a specific Sheet Tab and share it. 08:33
Watch this video on YouTube.

Linking can be a really handy tool for you when building your Google Sheet project. You can use it to reference a long list of external documents. Create a table of contents Google Sheet Tab for your monster of a Google Sheets project. Or even create a mini centralised information hub for your organisation or team.

Oh! Did you know that there is also a Google Sheets functions for HYPERLINKS. Why use it over the link too? Well, it is great for concurrent automation of cells down a row. Or you might want to add it to a greater formula to, say, add URL extensions automatically.

Cheers,

Yagi

Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets

Google Apps Script: WebApp, HtmlService, LockService; Google Sheets

In this tutorial, we are going to create an interactive story chain app that we can embed into a Google Site or your own site like WordPress.

What’s a chain story, Yagi? 

Maybe you did this in school. Someone wrote the first part of a story. You then gave that story to someone else to continue writing. They then pass the story onto someone else to write the next part. And so on and so forth. In the end, the story is read out and everyone laughs at the direction the story went – except that one kid silently raging of their lack of control of the narrative.

Why are we making this? How’s it going to help me?

Well, for one, I thought it would be fun. More importantly, this will allow us to have a look at how Google Apps Scripts communicates client to server-side and vice versa in a little more advanced environment than our previous tutorial. It will also give us an opportunity to look at some more parts of Google Apps Script as they relate to creating a WebApp.

Our chain story WebApp tutorial will also give us an opportunity to look at some of the pitfalls of using WebaApp. Particularly when using the execute as me permissions. Finally, this will then launch us into our follow up tutorial on updating the WebApp to execute as the user rather than me, the owner of the app.

This tutorial is the second part of the WebApp series. However, if you can read a bit of JS, CSS and HTML, you should be able to follow along and if you get stuck you can always go back to the first tutorial:

Google Apps Script: How to create a basic interactive interface with Web Apps

Let’s get started…

The Example: An interactive chain story

Embedded below is our interactive Chain Story web app. If you are feeling creative, read the story so far and then add your part to the story. It has been written by readers just like you:

Continue reading “Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets”

Google Sheets Beginners: Sharing your Sheet (20)

The ability to share and co-edit documents live is a powerful tool for organisations. In this tutorial, we will dive in deep on sharing a Google Sheet. In this tutorial, I’ll cover,

  1. What is sharing? Who can you share your Google Sheet with and what permissions can you give them? 00:00
  2. How to share your Google Sheet 0:20
  3. Understanding the share dialogue window. 00:50
  4. How to share your Google Sheet with people and/or groups 00:58
  5. Sharing with a group of users. 01:37
  6. Introduction to the top-bar of the comment dialogue box. 02:45
  7. Change users share permissions. 02:57
  8. Notify users that you are sharing a Google Sheet with them. 03:46
  9. See the number of people you have shared and the permissions that you have given them. 04:39
  10. A view of the email notification the user will receive. 04:59
  11. A warning on notification messages 05:25
  12. Viewing a shared Google Sheet as an editor. 05:45
  13. See the results of an edit from another shared account. 06:32
  14. Setting up custom people and group share settings. 07:02
  15. Change the permission level of existing shared user 08:48
  16. Make a shared user the owner of the document. 09:10
  17. The ‘View’ permission. What it looks like for the user. 10:43
  18. Requesting permissions from the owner. 11:13
  19. The ‘Get Link’ share settings. 12:19
  20. How anonymous users appear on your sheet. 14:30
Watch this video on YouTube.

While understanding the basics of sharing is quite simple, it can be a huge benefit up understand the different aspects of sharing. Your Google Sheet.

In the tutorial, we mentioned that we have a tutorial on how to handing a multitude of users making edit privilege request in your Gmail. Here is the tutorial:

How to stop getting Google document requests to edit from users outside your organisation from publicly viewable files.

Finally, here is a link to the Google Sheet that we have set to share fory anyone with a link can view: 

Shareing in Google Sheets tutorial link.

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Google Sheets Beginners: Communicating with Comments (19)

Google Sheets

One of the beauties of Google Sheets is collaboration. In this tutorial, we will cover how to insert comments in Google Sheets so that you can target cells and ranges for discussion with comments. In this tutorial, I’ll cover,

  1. Uses of comments in Google Sheets. 00:16 
  2. Who can access comments (Permissions)? 01:08
  3. How to create a comment. 01:21
  4. Create a general comment 01:28
  5. What comments look like in a sheet. 02:15
  6. Introduction to the top-bar of the comment dialogue box. 02:45
  7. Replying to comments in Google Sheets. 03:24
  8. Viewing comment history. 04:18
  9. Resolving comments. 04:35
  10. Other ways to create a comment in Google Sheets. 04:55
  11. Specifically addressing users in comments. 05:29
  12. Assigning comments to users. 06:52
  13. Viewing comment notifications in Gmail. 07:38
  14. Manually setting notifications for comments 09:30
  15. A final example using comments 10:35
  16. Seeing how many comments there are in a Google Sheets tab. 11:20

There is a lot to comments. Mostly learning comments is quite intuitive, however, it is important that your users know what they need to in order to be able to effectively communicate with each other in the Google Sheet. 

 

Watch this video on YouTube.