0
0
Google Sheetsspreadsheet~15 mins

Linking Sheets with Slides in Google Sheets - Real Business Scenario

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Scenario Mode
👤 Your Role: You are a sales analyst at a retail company.
📋 Request: Your manager wants a monthly sales report that automatically updates in a Google Slides presentation whenever the sales data changes in Google Sheets.
📊 Data: You have a Google Sheets file with monthly sales data for different products. The data includes Product Name, Units Sold, and Total Sales for each month.
🎯 Deliverable: Create a Google Sheets report with sales data and link it to a Google Slides presentation so that the slides update automatically when the sheet data changes.
Progress0 / 9 steps
Sample Data
Product NameUnits SoldTotal Sales ($)
Notebook1201800
Pen300900
Backpack753750
Calculator502500
Desk Lamp401600
Chair304500
Desk206000
Whiteboard152250
1
Step 1: Open your Google Sheets file containing the sales data.
No formula needed.
Expected Result
You see the sales data table with Product Name, Units Sold, and Total Sales.
2
Step 2: Select the range of cells containing the sales data including headers (A1:C9).
No formula needed.
Expected Result
The sales data range is highlighted.
3
Step 3: Copy the selected range (Ctrl+C or Cmd+C).
No formula needed.
Expected Result
The sales data is copied to clipboard.
4
Step 4: Open your Google Slides presentation where you want to insert the sales report.
No formula needed.
Expected Result
Google Slides presentation is open and ready.
5
Step 5: Go to the slide where you want to add the sales data table and paste it (Ctrl+V or Cmd+V).
No formula needed.
Expected Result
A dialog appears asking if you want to link the table to the spreadsheet.
6
Step 6: In the dialog, choose 'Link to spreadsheet' and click 'Paste'.
No formula needed.
Expected Result
The sales data table appears on the slide and is linked to the Google Sheets data.
7
Step 7: To update the slide when the sheet data changes, click the 'Update' button on the linked table in Slides.
No formula needed.
Expected Result
The table on the slide updates to reflect the latest data from Google Sheets.
8
Step 8: Test the link by changing a value in the Google Sheets sales data (e.g., change Units Sold for 'Pen' from 300 to 350).
No formula needed.
Expected Result
The sheet data changes and the linked table in Slides shows an 'Update' button.
9
Step 9: Go back to Google Slides and click the 'Update' button on the linked table to refresh the data.
No formula needed.
Expected Result
The table updates to show Units Sold for 'Pen' as 350.
Final Result
-----------------------------------------
|           Monthly Sales Report         |
|---------------------------------------|
| Product Name | Units Sold | Total $   |
|---------------------------------------|
| Notebook     | 120        | 1800      |
| Pen          | 350        | 900       |
| Backpack     | 75         | 3750      |
| Calculator   | 50         | 2500      |
| Desk Lamp    | 40         | 1600      |
| Chair        | 30         | 4500      |
| Desk         | 20         | 6000      |
| Whiteboard   | 15         | 2250      |
-----------------------------------------
✓The sales data table in Google Slides is linked to Google Sheets and updates automatically.
✓Changing data in Sheets triggers an update prompt in Slides to keep the report current.
✓This method saves time by avoiding manual copying and pasting for monthly reports.
Bonus Challenge

Create a chart in Google Sheets based on the sales data and link that chart to Google Slides so it updates automatically.

Show Hint
Use Insert > Chart in Google Sheets, then copy the chart and paste it into Google Slides choosing 'Link to spreadsheet'.