Analyze data in Sheets

Next: 5. Use macros and add-ons
Want to get more out of Google apps at work or school? Sign up for a free Google Workspace trial
In this section:

4.1 Add charts
4.2 Get automatic charts
4.3 Add charts to Docs and Slides
4.4 Functions in Sheets and Excel
4.5 Add pivot tables
4.6 Get automatic pivot tables

4.1 Add charts
” ”
Excel:
Insert charts
Sheets:
Add a new chart
Assorted charts in 2013 version

Excel 2013

Line, pie, bar, area charts from 2010 version

Excel 2010

In a spreadsheet, highlight the range of data that you want to create a chart for.
Click Insertand thenChart.
(Optional) To customize the chart, click More””and thenEdit chart.
You can also add a Sheets chart to a Slides presentation.

For details about adding charts, see Add and edit a chart or graph.

Pie chart appears atop columns with Data in a Sheets file

4.2 Get automatic charts
” ”
Get summaries and charts of your data with the click of a button in Sheets. It’s kind of like having an expert in data analysis sitting next to you.

Sheets: Get automatic charts

In a spreadsheet, select a range of cells, columns, or rows. Otherwise, you’ll get insights based on where your cursor is.
At the bottom, click Explore Open Explore.
Choose an option:
Point to a chart and click Insert chart Insert chart.
Ask a question about your data under Answers.
The results can include charts. To add one, point to it and click Insert chart Insert chart.
Tip: To customize a chart, click More””and thenEdit chartand thenCustomize.

Explore to see an analysis in a sheet

4.3 Add charts to Docs and Slides
” ”
Excel:
Copy and paste
Sheets:
Copy and paste
Cut, copy, paste, and use the Format Painter in 2010 and 2013 versions

Excel 2013 and 2010

Help people visualize data in a presentation or document by adding charts
from Sheets. If the source data changes, you can update the chart with the
click of a button.

In Sheets, open the spreadsheet and in the chart, click More””and thenCopy chart.
In Docs or Slides, paste the chart.
Choose an option:
To update the chart if the source data changes, keep Link to spreadsheet selected. Then, if source data changes, at the top of the chart, click Update.
To keep the chart unlinked (not updated), select Paste unlinked.
Click Paste.
Slides with a pie chart on the first slide

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

Sheet with a sigma or sum symbol
4.5 Add pivot tables
” ”
Excel:
Insert a pivot table
Sheets:
Add a new pivot table
Add a pivot table in 2013 version

Excel 2013 and 2010

Highlight data in your spreadsheet.
Click Dataand thenPivot table. A pivot table opens in a new sheet (tab).
In the Pivot table editor, add rows, columns, values, and filters.
For details, see Create & use pivot table.

A pivot table opens in a new tab, with the “Explore” feature nearby

4.6 Get automatic pivot tables
” ”
Excel:
Insert a pivot table
Sheets:
Get automatic pivot tables
Add a pivot table in 2013 version

Excel 2013 and 2010

admin January 3, 2022

0 230 5 minutes read

A WordPress Commenter
Hi, this is a comment. To get started with moderating, editi...
Georgia Waltrip
Hi, this is a comment. To get started with moderating, editi...
Donald Allbright
Hi, this is a comment. To get started with moderating, editi...
Ivy Torres
Hi, this is a comment. To get started with moderating, editi...
Donald Allbright
Hi, this is a comment. To get started with moderating, editi...

admin

Leave a Reply Cancel reply

A Refined Seattle Restaurant, Hold the Table Linens

Bosch looking to smart devices to get ahead in the cloud

Nintendo Details Next Miitomo Update

admin

Subscribe to our mailing list to get the new updates!

how to analyse data from google forms

4 Steps for Quick and Easy Data Analysis with Google Sheets

Related Articles

Controlling PWM fans with the Raspberry Pi CM4 IO Board’s EMC2301

Mini-ITX Seaberry adds 11 PCIe slots to a Raspberry Pi

Turing Pi 2: 4 Raspberry Pi nodes on a mini ITX board

Install Python 3.9 on Raspberry Pi OS or Debian 10 (for Ansible or other uses)

Leave a Reply Cancel reply

A Refined Seattle Restaurant, Hold the Table Linens

Bosch looking to smart devices to get ahead in the cloud

Nintendo Details Next Miitomo Update