…When someone shares a Google Sheet spreadsheet with you,…it's helpful to understand how to access the file and…what you can do with the file once you access it.…When someone shares a Google Sheets file with you,…they'll send you a link to access the document.…Although the link may come to you via text or…IM, that link will most often be in an email that looks like this one.…It will be from the person who shared it,…with the words via Google Sheets after their name.…In this case, my colleague Jason shared the document with me.…The subject line will be the title of the document.…
In this case, the spreadsheet title is shared.…And inside the email, there will be a link to the spreadsheet.…If you click the link to the spreadsheet, if you're already signed in to…your Google account, the spreadsheet will open up in a new browser tab.…If you're not signed in, you'll need to sign in.…If you don't have a Google account, you'll need to follow the instructions to sign up…for a Google account before you can access the spreadsheet.…
- 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.