…You can reference data from other sheets in Google Sheets.…You can use a special formula to replicate and…copy data from one sheet to another within a single Google spreadsheet.…Referencing data from other sheets means replicating data from one sheet to…another within a single spreadsheet document.…This makes it so…you don't have to manually update the spreadsheet or enter data twice.…And it has the added benefit of automatically changing the data on…multiple sheets when the master data sheet is revised.…Let's walk through how to reference data from other sheets using the sales…data spreadsheet.…
Take a look at this sales data from March 2014.…I have three totals here, one for the total items that were sold, in cell C23.…One for the total amount of items left in stock in cell D23,…and one for the total amount of items on order in cell E23.…I'd like to replicate the data for…these totals to my totals sheet, which I can access by clicking here.…I'd like these totals to be replicated in the March column on the sheet.…
- Navigating Google Sheets
- Creating, naming, and saving spreadsheets
- Importing files
- Converting other file formats such as Microsoft Excel to Google Sheets
- Editing cells
- Inserting, deleting, and moving rows and columns
- Adding hyperlinks and images
- Formatting data
- Using formulas and functions
- Sharing spreadsheets
- Using the Google Sheets mobile app
Skill Level Intermediate
Q: This course was updated on 04/17/2018. What changed?
A: We revised five videos to reflect the latest features and enhancements in Google Sheets.
Q: This course was updated on 10/17/2018. What changed?
A: New videos were added that cover customizing your printed spreadsheet and automating tasks with recorded macros.
1. Getting Started with Google Sheets
2. Creating Spreadsheets
3. Editing Spreadsheets
4. Viewing and Printing Spreadsheets
5. Formatting Spreadsheets
6. Working with Spreadsheet Data
7. Collaborating with Google Sheets
Commenting on a spreadsheet3m 26s
8. Using the Google Sheets Mobile App
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.