# 3.Data journalism basics with Google spreadsheets

Google Sheets is a spreadsheet program included as part of a free, web-based software office suite offered by Google within its Google Drive service. \
\
The service also includes Google Docs and Google Slides , a word processor and presentation program respectively. Google Sheets is available as a web application, mobile app for Android, iOS, Windows, BlackBerry, and as a desktop application on Google's ChromeOS. The app is compatible with Microsoft Excel file formats. \
\
The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by user with a revision history presenting changes. \
\
An editor's position is highlighted with an editor-specific color and cursor and a permissions system regulates what users can do. Updates have introduced features using machine learning, including "Explore", offering answers based on natural language questions in a spreadsheet.

\
Google Sheets is a Google Docs product.\
Also called Google Spreadsheet or Google sheet\
Has the same features as MS Excel\
Works online - web-based, except under certain circumstances\
Works with all internet browsers\
You can analyze and visualize your data.\
\
**Common Spreadsheet Statements**\
\
Cell: A single data point or item in a spreadsheet.\
Column: Vertical cell set.\
Row: A horizontal array of cells.\
Range: Select a cell that extends to a row, column, or both.\
Function: An internal process in a spreadsheet application that can be used to calculate cell, row, column, or range values, edit data, and more.\
Formula: Combination of functions, cells, rows, columns, and ranges used to achieve a given result.\
Worksheet: Named sets of rows and columns that make up your spreadsheet; a spreadsheet can contain multiple sheets\
Spreadsheet: the entire document containing your worksheets<br>

![](https://lh3.googleusercontent.com/iYtafMU31VhalcFNZmGp2sVtnGeI4WmecQ6w3JFAMOuC6RI8Xp8Wog8Arw4GjKl8QZn_anE4xFT10AeZWR5_Gj3CvtF9napvxm_mbFZo1HnGPIeq_tK1vgHkaxzQXjhEt8Cvz7M)

**How to use it?**

You must first have a gmail account\
You can then access the New Menu> Google spreadsheets at google drive (drive.google.com)\
You will then be presented with an empty excel file, you can start by changing the name of the file.\
\
![](https://lh3.googleusercontent.com/7EHKXvYysT_s9R-J2OmfdhtkhDELY-FJ_HgyOurtDtcxmEmdSB4KRzpU1bgnvuMuIMOQDsHmPwW1qEqFxK7X0f2lb16mRAGsyKLjebYwX0q8SniDyxZ5uxSJf8Tz1qpYVrKh4gw)<br>

**Share you file**

![](https://lh6.googleusercontent.com/hsd11taH7rAcDbXqeMwedLEROb14HlS1hgCXwtszGFcjZi-MdCE19fLsgmG321kAfTuKEUX7QFljKtLRnvS_OryeGkWir-H_r2gFiSmmzYT6mH4sTjbjxayYqofBV27gCcun1X8)

**Few Features to Make Your Job Easier**\
\
1.Find and Replace\
2.Devrik Paste\
3.Text to Column\
4.Quick Graph Button\
5\. Basic Accounts\
\
**Useful functions**\
\
**Sum, Average, Count, Max, Min**

![](https://lh5.googleusercontent.com/DM8Y0kuW7QtRTwgWHY71DeGYiAz2OB2yjpVy6cx6HlDf5zuyHSPQ7EpxzDlujn9xIbpAGpVeLO3DxmgvL4WB75fgNNItn8vLKgXgmnzSyx4rTP81pCeryyWiQaFwn30mk4mWlWM)

\
**Add a quick chart or graph to a spreadsheet**<br>

![](https://lh4.googleusercontent.com/y0sdaBxqruxpeSCkcs9H7HZPcotPLLiyPM-DHlqch4ebPWNNDpPKui-f_9Q7VDaSKkcXe5dusYU00IqpOg_tjkU18hQQrXVygZDN3zQ3W7kjigPkrPEZFlAKiWLKlw6y7U9lslQ)

**Line-Column-Pie Charts**

![](https://lh5.googleusercontent.com/qB8sQ66WI7lMWWhABPZJSHHY6TtkR5cfSJlr9Bjf6ogZou-idzNwE2knYz2Jb_jfsgUJwN1lCQgdxjmtc_pfitKTozfggcyWRKGAkHYfPNKY0AHUmmxo2z1d2qmwHmf1UgVSaI0)

![](https://lh4.googleusercontent.com/Gfflyv47C0bmB7e7NTGhIZ2j6XW6FlDjpvzhDWuBWQRUp8Kg73mrPHQPCoDLrS5EWyZAiNunU_6iMG2kMsUamI3yTqYZ3Mchqb57LRs_y0pMu4wpcR-lLs2myjat4OEXUb_4JwY)

![](https://lh3.googleusercontent.com/el9WBS3w8XUHRjFHMwL1NCgh5zSwS0FGfwP8V9djEFGz_lkJ1w3vIxiu-QYYIXWxa-KgabD5-CEKCSXXLpgQNed4XHN7abxJbNJxnHBW7zwIxeaHK2f7OYSzUPBt6fArSUxaujg)

![](https://lh3.googleusercontent.com/WWb-qTnTgUvyQzgPyZdDPYD4zm1y2PuKyvpkj1qVN1qWDMQken2k_5OFh-u3MPXD9I8-P2aWw8hoxu0v6p_QLkYYq3naMUUeeuicXYVFT5FFFTJn7Xp4ZvndRPu_FKWX11S5KQo)

{% embed url="<https://www.youtube.com/watch?v=JrpmBWxSczM&list=UUY0XhHtV3XuCMQdBujZ8FbQ&index=17>" %}