Switch from Excel to Sheets
On this page
Add charts
Excel: | Sheets: |
---|---|
Excel 2013
Excel 2010 |
You can also add a Sheets chart to a Slides presentation. For details about adding charts, see Add and edit a chart orgraph. |
Add charts to Docs and Slides
Excel: | Sheets: |
---|---|
Excel 2013 and 2010 | Help people visualize data in a presentation or document by adding charts
|
Functions in Sheets and Excel
Most Excel functions are the same in Sheets. For a list of common functions, see the Sheets Cheat Sheet.
Some unique functions in Sheets:
FILTER | Returns a filtered version of the source range, returning only rows or columns that meet specified conditions. |
SORTN | Returns a specified number of items in a data set after a sort. |
SPARKLINE | Creates a miniature chart in a single cell. |
QUERY | Runs a Google Visualization API Query Language query across data. |
GOOGLEFINANCE | Gets current or historical securities information from Google Finance. |
GOOGLETRANSLATE | Translates text from one language into another. |
IMPORTRANGE | Imports a range of cells from a specified spreadsheet. |
For a list of all functions in Sheets, see the Google Sheets function list.
Add pivot tables
Excel: | Sheets: |
---|---|
Excel 2013 and 2010 |
For details, see Create & use pivot table. |
Back to top
Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companieswith which they are associated.
Need more help?
Try these next steps:
Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.