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 auto-complete
|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
Google, Google Workspace and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.