Converting a Microsoft Excel spreadsheet to a Google Sheet comes with the benefits of taking up no storage space as well as sharing capabilities. Jess Stratton shows best practices for converting an Excel file to a Google Sheet.
- [Instructor] I'm looking at a list of all my files…that are currently in Google Drive.…Here I can see a Google Sheet called Invoice…and I can that it's a Google Sheet because of the icon.…Here's a Google Doc.…And I can tell by this icon…that this is a Microsoft Excel file.…I can also tell because of the extension.…If I double click on the Excel file to open it…I'm given a preview of the document.…I can see the tabs that are down at the bottom.…And I can even navigate through those tabs.…On the top right I can print it,…I can download it back to my computer,…but what I can't do right now is edit it.…
To edit it I need to open it in Google Sheets.…If I select Open with Google Sheets…it's also going to convert it to Google Sheets format.…This is going to give me the benefits…of being able to do most of the things…that we've talked about in this course.…Including other things like sharing it…and working on it simultaneously with somebody else.…I'm going to close out of it…by clicking the arrow in the top left hand side.…
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.