347 647 9001+1 714 797 8196Request a Call
Call Me

Get the most out of your Google Spreadsheets

February 16, 2015
, ,

Google spreadsheet is a web based application created by Google that enables you to create and edit your spreadsheets online along with the others.

Why You should use Google Spreadsheets

1.Your data is always backed up, so you don’t have to worry about losing it if your system crashes or something like that.

2.You have the access to your data everywhere irrespective of your location. You can manage your data through desktop computer, laptop, smartphone etc.

3.You and your team can work on the same sheet at the same time across locations.

4.Work is simplified for the companies that use Google spreadsheets, as it saves a lot of time that goes into emailing of the documents.

How to create a Google Spreadsheet

To create a new worksheet follow the below mentioned steps:

1.Visit Google Spreadsheets

2.If you have no spreadsheets present then this (image 1) is how your screen will look.

3.Click on the + sign that reads create new spreadsheet and your spreadsheet shall be created.

4.You can rename the sheet by clicking untitled spreadsheet (image 2) which will launch a new dialog box for renaming.

Image 1

How to create Google spreadsheet

Image 2

How to rename Google spreadsheet

Formatting Google spreadsheets

1.You can easily format the data in currencies, percentages, decimal points, date, time, etc. through the options available on the top of the sheet. (image 3)

2.You can insert rows, columns, images, comment, function link, etc. by clicking on the insert tab or using Alt + I. ( image 4 )

3.You can add a new sheet by clicking on + sign available at the bottom of page. ( image 5)

Image 3

How to format Google spreadsheet

Image 4

How to add rows and columns in Google spreadsheet

Image 5

How to add a new sheet in Google spreadsheets

Get started with the functions

1.Functions make the calculations easy and mechanical. Some of the basic functions like Sum, Average, Count, etc. are available in the top ribbon of your spreadsheet. (image 6)

2.For example, if you want to use the function of sum then you just have to select it from the dropdown and the formula shall be displayed automatically. (image 7) Select the range of cells you want to add (A1:A3 in image 8) and press enter.

Image 6

Using functions in Google spreadsheets

Image 7

Using sum function in Google spreadsheet

Image 8

Using sum function in Google spreadsheet

As they say that every coin has two sides, similarly Google spreadsheets too have a flip side. Here is the list of things that we would like to see improving in Google spreadsheet.

1.Internet connectivity – Unlike Microsoft Excel, Google spreadsheets require internet connectivity which proves to be its major drawback.

2.You cannot organize your sheets since there are no folders

3.Loading of the spreadsheets takes up a lot of time

4.As compared to Microsoft Excel, the features offered by Google spreadsheets are very limited.

Though Google spreadsheets have some drawbacks but we still love the convenience and ease provided by it. Google spreadsheets consists of many more functions and shortcuts that we shall bring to you in our next blog. So stay tuned and do share your views with us in the comments box below.


About the Author

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 71363