Skip to content

7. Sheets: Insert Links, Images, Forms and Drawings

Playback speed:
Transcript

At this point in the lesson, your spreadsheet contains charts and tables to help you visualize and summarize the data. In this video, you will add more non-text elements to your spreadsheet, including links and images.

These elements will provide additional context for the data you’ve already included and help your collaborators interpret the contents of the sheets.

You might want to link to a company website, to show the shirt designs available, a social media profile to help others connect with your company, or an online portfolio of a particular salesperson or team.

To start, open the “Sales by Team Member” sheet to add links.

Open the starter project linked next to this video and make a copy. This example uses a scanned copy of an invoice. This is helpful to include if a customer has placed an order but has not yet paid, so the salesperson can be sure to follow up.

Then, get a shareable URL, and copy it.

In the “invoice” column of your spreadsheet, paste the URL.

Then, insert an image. This example uses a scanned copy of an invoice. You could also include: a headshot for each salesperson, a photo of the t-shirt designs, or a scanned picture of a size chart.

Images are often saved as JPG files.

Download the JPG starter project and save it to Google Drive.

Then insert a link to the image in Drive.

Move the image so it doesn’t overlap with any important data.

Next, insert a drawing. You might want to show a mockup of a t-shirt design, a company logo, or an advertisement for an event. If you don’t have a design in mind, create a drawing just to practice.

You can also add forms, to link to a survey and collect more feedback, charts, to create a visual for a presentation, and links to other sheets, to help collaborators quickly navigate from one section to another.

In the online sales column, link to the filter views sheet so that anyone using the spreadsheet can find information quickly without needing to create their own filters.

Nice work! Now you can include other elements in your spreadsheet to make it more professional and give collaborators a fuller picture of the data.

Now, it’s your turn: Make a copy of the starter projects and save them to Google Drive; Insert a link to the document; Insert the image of the invoice; Insert a drawing; and insert a link to another sheet in the spreadsheet.

Next

Instructions

  1. Make a copy of the starter projects and save them to Google Drive.
  2. Insert a link to the document.
  3. Insert the image of the invoice.
  4. Insert a drawing.
  5. Insert a link to another sheet in the spreadsheet.