Google Spreadsheets Introduction

What is Google Spreadsheet?

Google Sheets is a free, web-based application that is provided by Google which enables users to create, update and modify spreadsheets and share the data online in real time. You will find this application within the google drive services. The Google Drive also includes Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites and Google Keep.

Google Sheets allows users to edit, organize, and analyze different types of information. It allows collaborations, and multiple users can edit and format files in real-time, and any changes made to the spreadsheet can be tracked by a revision history.

How to Use Google Sheets?

Google Sheets is a free-to-use application that can be accessed on the Chrome web browser or the Google Sheets app on Android or iOS platform. Users need a free Google account to get started. To create a new Google Excel Sheet, following the following steps:

• Go to https://www.google.com/ and click on 9 dots menu on top right corner.
• Go to the Google Drive Dashboard, and click the “New” button on the top left corner, and select Google Sheets.
  
• Open the menu bar in the spreadsheet window, go to File then New. It will create a blank spreadsheet, and the interface will be as follows:
  
• To rename the spreadsheet, click on the field on the top left corner, which is titled “Untitled spreadsheet” and type in your preferred name. When a new Google spreadsheet is created, it is automatically saved in the root folder of your drive. To move the spreadsheet to a different folder, click and hold the file, and drag it to the preferred folder.
  
  

What is used of Google Sheets?

Google Sheets is typically used for spreadsheet collaboration across different geographic locations. At same time multiple users can modify a Google Sheets document from different locations, with changes tracked for each individual user.

The Google Sheets online spreadsheet application which allows users to create, edit and format spreadsheets online to organize and analyze information. Google Sheets is often same as to Microsoft Excel, as both applications are used for similar purposes such as data management. Google Sheets is essentially Google's cloud-based version of Microsoft Excel's basic features.

Common Words in Google Sheet

• Cell A single data-point.
• Column: A vertical range of cells that runs down from the top of the sheet.
• Row: A horizontal range of cells that run across from the left side of the sheet.
• Range: A selection of multiple cells that runs across a column, row, or a combination of both.
• 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.
• Worksheet: Sets of columns and rows that make up a spreadsheet.
• Spreadsheet: Entire document that contains Google Excel sheets. One spreadsheet can have more than one worksheet.

What is Google App Script?

Google Appscript is a language which is used to automate google products such as Google Spreadsheet, Google Docs, Gmail, etc. You can make auto flow of data from one spreadsheet to another spreadsheet by using appscript. Google Appscripts is also know as "GAS".

Google Appscript is similar to Javascript which runs on google server side. You can make Advance Level system by using html and appscript by making google sheet as database.

How to use Google Appscript?

By following steps you can use google appscript:-

• First go to Extension in the menu and click on Apps Script.
  
• When you click on Apps Script, a coding panel will be open as per given below image. You can change the name of appscript name by clicking on Untitled project
  
• To create html page, click on plus (+) icon beside Files heading. By HTML code, you can able to make advance layout and have to link with google sheet by using apps script. We have made a different google appscript for google spreadsheet which is commonly used in every office data management now a days.