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.
Sparkline Function
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.
