Switching to Sheets from Microsoft Excel
Overview: Differences between Sheets and Excel
Want to get more out of Google apps at work or school? Sign up for a free G Suite trial.
|
Now that you've switched from Microsoft® Excel® to G Suite, learn how to use Google Sheets as your new spreadsheet program.What you need: |
Note: Comparisons are based on Microsoft® Office® versions 2010, 2013, and 2016.
In Microsoft Excel... | In Google Sheets... |
---|---|
Collaborate in Excel for the web | Collaborate in real-time from Sheets |
Share using Excel for the web or a shared workbook | Share directly from Sheets |
Save automatically using SharePoint® or OneDrive® | Save automatically to Drive |
Manage versions with History or Version History in OneDrive | Manage versions with version history |
Add formulas and use Formula AutoComplete for suggestions |
Add formulas and use formula suggestions that appear as you enter text |
Record macros or use VBE | Record macros or use Google Apps Script |
Create filters | Create filters and filter views |
Insert recommended pivot tables or create one manually | Create pivot tables manually or automatically with Explore |
Create charts manually | Create charts manually or automatically with Explore |
Set notifications in OneDrive | Set notifications in Sheets |
Table of contents
Was this helpful?
How can we improve it?