Skip to main content

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.

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 JPEG files.

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

Then, insert the image.

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.

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.


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.