Link to a selected range within your Google Sheet 05:34
Link to a specific piece of text within a string of text in a cell 04:30
Different links to different pieces of text within a cell 07:22
Get a URL to a specific cell in a specific Sheet Tab and share it. 08:33
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.
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.
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,
What is sharing? Who can you share your Google Sheet with and what permissions can you give them? 00:00
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:
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.
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,
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.
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.
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.
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 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.
