What is Google Sheets?
Google Sheets is a free, web-based spreadsheet application that is provided by Google within the Google Drive service. That means you open it in your browser window like a regular webpage, but you have all the functionality of a full spreadsheet application for doing powerful data analysis.
Why you should use Google Sheets?
It is free and easy to use.
It is cloud-based and works from any device.
It is collaborative, so team members can see and work with the same spreadsheet in real-time.
It has enough features to do complex analysis.
How to create Google Sheets?
Step 1: Login to Google Drive
Google Sheets is available inside Google Drive, so you have to login to Google Drive first. Search with “Google Drive” and click on the appropriate search result which will take you to Google Drive.
You need to enter your Gmail Id and password to login.
Step 2: Create a spreadsheet
Click on +New button. This will create and open your new spreadsheet.
You can rename your Sheet in the top left corner. Click on where it says Untitled spreadsheet and type in whatever name you want to give your Sheet.
What are the key terminology and the fundamental concept of Google Sheets?
So let’s introduce some key terminology and the fundamental concept upon which spreadsheets work:
There are two menu rows above your Sheet.
Each sheet has cells, columns and rows.
Cell: Is a single data-point. Cells allow you to store data and make calculations based on the data in other cells.
Column: A vertical range of cells. Columns are indicated alphabetically.
Row: A horizontal range of cells. Rows are indicated numerically.
Range: A selection of multiple cells that runs across a column, row, or a combination of both.
Worksheet: Sets of columns and rows that make up a spreadsheet.
Spreadsheet: It is the entire document, One spreadsheet can have more than one worksheet.
Function: A built-in feature in Google Sheet that is used to calculate values and manipulate data.
Formula: A combination of functions, columns, rows, cells, and ranges that are used to obtain a specific end result.
How to work with data, row and columns?
Now you will learn Entering, selecting, deleting data.
Click any cell and you’ll see a blue box around the cell, to indicate it’s highlighted. Then you can simply start typing.
Hit enter when you’ve finished entering data and you’ll move down to the next cell.
Clicking ONCE on the cell highlights the whole cell. Clicking TWICE enters into the cell, so you can select or work with the data only.
To delete the data we just entered, either click the cell once and hit the delete key, or, click the cell twice and then press the delete key until all your data is cleared out.
Now you will learn Changing the size of rows and columns.
To change the height of a row, hover your cursor over the grey line denoting the edge of the row.
To change the width of a column, hover your cursor over the grey line denoting the edge of the column.
Now you will learn insert additional rows and columns.
To insert additional rows, click on the existing row next to where you’d like to insert a new row.
To insert additional columns, click on the existing column next to where you’d like to insert a new column.
How to add, delete and rename sheets?
Click the big plus button in the bottom left of your Google Sheet to add a new Sheet.
To rename a sheet, click the small arrow next to the name (e.g. Sheet1) to bring up the menu. Here you’ll see the option to rename Sheets.
Here you’ll also see the option to delete and hide Sheets.
Go to view menu and unhide sheet.
How to add/delete note and comment in your spreadsheets?
You can add simple notes to cells as well if you wish.
You can also add comment and tag people (via their email address) who you want to see the comment too. They can reply and mark it resolved once it’s been acted upon.
The difference between notes and comments in Google Sheets is that notes are just a text box where you can enter information. Comments on the other hand are also text boxes, but these are more dynamic. With comments, you can see comment history, tag others, and reply to comments other people have left.
How to share your Google Sheets?
You can find the Share function under the File tab. Select the Share option and enter email addresses of those whom you wish to access the spreadsheets. You’ll note that you can determine whether others can edit, comment or simply view the document.
You’ll also see an option to create a shareable link that you can distribute separately.
How to download your Google Sheets?
If you wish to have a copy of your spreadsheets locally on your computer, select the “Download as” option under the File tab.
You’ll have several options including the ability to download the document as a Microsoft Excel (.xlsx) file or as a PDF or some more options.
How to email your Google Sheets?
You’ll find this option under the File tab. You may either email collaborators (those with whom you’ve already chosen to share the spreadsheet) or email the spreadsheet to others as an attachment.
How to make specific Google Sheets available offline?
Go to file, click on Make available offline and click on Turn On button.