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.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons