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.

Watch this video on YouTube.

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

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 – 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 – Creating Sheet Tabs (14)

Google Sheets

Sometimes just one Google Sheets tab is not enough. Maybe you want to tidy up your data, create unique insights in a separate tab or generate a spectacular graphic dashboard or all your daw data, knowing how to create a Google Sheets tab is going to be a vital part of your success as a Google Sheets creator.

In this tutorial we’ll cover:

  1. The different ways you can add a new blank sheet tab.
  2. Duplicating a current sheet tab.
  3. Renaming your sheet tab.
  4. Accessing a large number of sheet tabs.
  5. Hiding and unhiding your sheet tab.

Remember!

Don’t forget to let your team know that you are using tabs. They always forget 🤣.

Watch this video on YouTube.

If you want to learn some more Google Sheets basics skills check out the link to the playlist below:

Google  Sheets Basics playlist

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 – Hide and unhide columns and rows(13)

Google Sheets

Sometimes it is helpful to hide and unhide columns in Google Sheets. You may have some completed tasks that you want to indicate as completed to your users or you may want to hide columns that you have used for working. Whatever, the case hiding rows in columns is a helpful trick to have in your Google Sheets toolbox.

In this video tutorial we  will cover:

  1. Why you might want to hide columns and rows in Google Sheets.
  2. Hiding and unhiding individual columns and rows.
  3. Hiding and unhiding ranges of columns and rows.
  4. Hiding and unhiding selected columns or rows.

Check it out now!

Watch this video on YouTube.

If you want to grab more Google Sheets basics, you click in the link below to the playlist:

Google Sheets Beginners playlist

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: Insert Columns and Rows (12)

Google Sheets: Insert and Shift Columns and Row

Even if you are a veteran Google Sheets users you might find a great little tip in this tutorial.

Here we will cover how to insert columns and rows in Google Sheets spreadsheets. Oh, and how to cheat at connect 4.

In this tutorial, I’ll cover,

  1. Inserting columns and sheets from the menu bar.
  2. Insert columns and sheets by right-clicking cells and row and columns references.
  3. Inserting multiple columns and rows at one time.
  4. Shifting a cell set up, down left and right by one or many cells.
Watch this video on YouTube.

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*

~Yagi

*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.