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

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.

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

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. 

 

 

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Google Sheets Beginners – Alternating Colours (17)

Google Sheets

Find out how to add alternating colours in your rows in Google Sheets. Adding alternating colours in your spreadsheets can really help your viewers to reference data accurately while also allow your spreadsheet to look quite smart and professional.

Google Sheets has a quick and easy alternating colours tool to help you to fancy up your spreadsheets in seconds.

In this tutorial, I’ll cover,

Continue reading “Google Sheets Beginners – Alternating Colours (17)”

Google Sheets Beginners – Inserting Images (18)

Google Sheets 

Find out how to insert images into your Google Sheets. In this tutorial, we will cover the different ways that you can insert images into Google Sheet.

Adding images can be useful for styling up your Google Sheet or providing a visual explanation of some of your data.

You can also add images to cell references. Perhaps you have a parts list that you want to add an image into for your sales team to easily reference. You can do this by inserting images.

Another use of adding images to Google Sheets is to provide instruction on how to use your Google Sheet. You might want to consider providing an Instructions Google Sheets tab for your users so that they know how they are meant to use your sheets. You can even insert a GIF file to display a mini video of steps.

In this tutorial, I’ll cover,
1. Discuss the two options for inserting images in sheets.
2. Inserting images from a file.
3. Inserting images from your Google Drive.
4. Inserting images from a link.
5. Copying and pasting screenshots into your Google Sheet.

Oh, and a very awkward comment about a goat. 🐐

What can I say? A goat likes what a goat likes.

If you up for learning more about Google Sheets basics to make your life easier at work check out the playlist:

Google Sheets Basics playlist

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 
Google Sheets Shortcuts Mousepad
Google Sheets Shortcuts Mousepad
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.
Google Sheets Shortcuts Mousepad Gel
Google Sheets Shortcuts Mousepad Ge

~Yagi

Google Sheets Beginners – Change Your Current Workbook’s Timezone Date & Currency (16)

Google Sheets

As we increasingly start to work from home and work with clients globally, it is vital that we prepare our Google Sheet for the country that our users and clients are from.

In this tutorial, we will cover how to quickly change your current Google Sheet’s timezone, date and currency for the entire document.

In this tutorial, I’ll cover,

Continue reading “Google Sheets Beginners – Change Your Current Workbook’s Timezone Date & Currency (16)”

%d bloggers like this: