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 or graph.
|
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. |
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.