7. Sheets: Insert Links, Images, Forms and Drawings
At this point in the lesson, your spreadsheet contains charts and tables to help you visualizeand summarize the data. In this video, you will add more non-textelements to your spreadsheet, including links and images.
These elements will provide additional context for the data you’ve already included andhelp your collaborators interpret the contents of the sheets.
You might want to link to a company website, to show the shirt designsavailable, a social media profile to help others connectwith your company, or an online portfolio of a particular salespersonor 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 usesa scanned copy of an invoice. This is helpful to include if a customer has placed an orderbut 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 alsoinclude: 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 companylogo, 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 collaboratorsquickly navigate from one section to another.
In the online sales column, link to the filter views sheet so that anyone using the spreadsheetcan 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 professionaland give collaborators a fuller picture of the data.
Now, it’s your turn: Make a copy of the starter projects and savethem 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.