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
|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|