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)”

Google Sheets Beginners – Spell Check(15)

Google Sheets

Did you know that you can use spell check in Google Sheets?

No? Not many people do.

Cleaning up your spelling in your Google Sheets can really give your work an edge and save you from any embarrassing moments when you using your data to present.

While Google Sheets spreadsheets is quite primitive it can certainly help you fix the odd spelling fluff here and there.

In this tutorial we will cover:

  1. Using spellcheck on a single cell or sheet.
  2. Ignoring selected mistakes.
  3. Adding special words to your personal dictionary.
  4. Some of the limitations of Spellcheck in Google Sheets

If you up for learning more about Google Sheets basics to make your life easier at work check our 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

 

%d bloggers like this: