Google Spreadsheet & Its Features
q Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people.
q 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.
Excel vs Spreadsheet
q Google sheets and excel are very much same in the terms of formulas and calculations and many of their features of them are same.
q Both have data in the form of a table or in other words rows and columns.
q The major difference between excel and google sheets is that google sheets provide us with us link which can be shared with other users to give them permission to read or edit the sheet at once while in excel only one person can edit the file at a time.
Creating Google Spread Sheet
ü You must have a Gmail account to create a Google sheet.
ü You need to Login to your active Gmail Account.
ü Go to Google drive as shown in Image.
ü Click on New.
ü Then Click on Google Sheets.
ü You will get a new spreadsheet on screen.
Adding Title to Google Spread Sheet
ü You can Change the Name of your sheet here.
ü The changes you will make will be saved automatically in your Drive.
Sharing Google Spread Sheet
ü You can share your sheet with your Colleagues, Seniors Through Email ids or through Link too.
ü To Share your Sheet you need to click on Share button as shown in Image below.
ü You will get this box when you click Share button.
ü You can add Email ID here to share sheet.
Adding E-Mail ID
ü You can add Email Id here & you can click on Notify People to send a notification to His/her Email Id.
ü Then you can select the choice of editing- whether he/she can only view this sheet or can Comment or can Edit if necessary.
ü Then click on Send.
ü You can also edit choice after adding E mail ID.
ü Also you can copy link to share on various Social Platform.
Send E-Mail ID when you Comment
Google Sheets is great for collaborating with others –You can actually send an email to let them know when you’re adding a comment to Google Sheets.
Just add a plus sign (+) and then type their email address (or name) and then when you add your comment they’ll receive an email with your message automatically.
ü Just add a Comment by right clicking mouse or use shortcut key Ctrl+Alt+M.
ü You will get a new dialog box.
ü You can add Email to notify the person to make Changes. It will directly send an Email to the person.
ü Just put @ before adding Email, Click on assign & add Comment.
ü You can Select Comment or Edit Option as per your requirement.
ü Click Comment to add settings.
Protect Data in Cells
ü If lots of people are working on a sheet, then you might want to lock down some of the data to prevent mistakes. You can lock sheets and even individual cells so that data isn’t accidentally changed.
ü If you don’t want completely lock down cells, you also have the option to show a warning before they’re edited.
ü Select row or Column or certain range you want to restrict.
ü Right click on mouse.
ü Then click on Protect Sheet as shown in Image.
ü You will see a new dialog box will open at right side of the sheet.
ü You can enter Description & set Permission as per your requirement.
ü You can now set Warning before editing this range or you can also restrict editing in this range.
When you’re working with large amounts of data in a Google Sheets spreadsheet, it isn’t always convenient to drop a chart into the mix. To help you, you can create one-cell charts using the SPARKLINE function instead.
A sparkline chart is a very small line chart that allows you to quickly visualize your data. It’s useful if you want to quickly see if share price data in a spreadsheet was going up or down, for instance.
The SPARKLINE function in Google Sheets allows you to insert these types of charts into a single cell on your spreadsheet. While a sparkline is typically a line chart, the SPARKLINE function enables you to create alternatives, including single-cell bar and column charts.
Enter your Formula to blank cell
After you press enter you will get a chart
ü You can change chart type also.
ü You need to add chart type as column, bar etc according to your preference.
ü Here we have used column chart type.