GOOGLE SHEETS

“GOOGLE SHEETS is the name given to the spreadsheet software offered by GOOGLE ” which comes bundled with the GSUITE or it is also available free of cost for personal use.

Google Sheets is also becoming a popular option among the users due to the various additional features of sharing and protection which are very easy to use.
Excel is one of the most important component of the office suite.

Spreadsheet or GOOGLE SHEETS is an application which provides calculation tools to make our report making easier. It provides many functions, formulas, tables, charts etc. to analyze the data within minutes.

GOOGLE SHEETS have great features such as what if analysis, pivot tables, pivot charts, graphs, visual basic for application programming for excel etc. which helps people to solve calculation problems.

GOOGLE SHEETS has all the functions of a standard spreadsheet software and a grid of rows and columns where the data is entered and operations are done on it.

IN THIS PAGE, YOU'LL FIND THE DIFFERENT ARTICLES WHICH WILL HELP YOU LEARN THE USE OF GOOGLE SHEETS.

CHOOSE THE TOPIC OF YOUR CHOICE

HOW TO CALCULATE IRR [INTERNAL RATE OF RETURN ] USING GOOGLE SHEETS ?

INTRODUCTION IRR or Internal Rate of Return is another instrument in taking the business decisions financially. INTERNAL RATE OF RETURN ...
Read More

HOW TO CREATE A STOCK PORTFOLIO TRACKER WITH TEMPLATE?

INTRODUCTION As per INVESTOPEDIA.COM, A stock (also known as equity) is a security that represents the ownership of a fraction ...
Read More

HOW TO CREATE WINLOSS SPARKLINE IN GOOGLE SHEETS ?

INTRODUCTION CHARTS are the graphic representation of any data . Analysis of data is the process of deriving the inferences ...
Read More

HOW TO CREATE SPARKLINE [ CHART IN A CELL ] IN GOOGLE SHEETS?

INTRODUCTION INTRODUCTION CHARTS are the graphic representation of any data . Analysis of data is the process of deriving the ...
Read More

HOW TO USE MODE.MULT IN GOOGLE SHEETS ?

INTRODUCTION GOOGLE SHEETS is the spreadsheet application offered by MICROSOFT which is one of the best spreadsheet application. One of ...
Read More

HOW TO USE MODE.SNGL IN GOOGLE SHEETS ?

INTRODUCTION GOOGLE SHEETS is the spreadsheet application offered by MICROSOFT which is one of the best spreadsheet application. One of ...
Read More

HOW TO USE MODE FUNCTION IN GOOGLE SHEETS ?

INTRODUCTION GOOGLE SHEETS is the spreadsheet application offered by Google which provides many great functionalities to the users. One of ...
Read More

GOOGLE SHEETS FOR KIDS [ 3-5 YEARS]- RECOGNIZE THE NUMBERS AND ALPHABET

INTRODUCTION Kids are always curious about learning new things. When kids are growing they start learning alphabet and numbers. They ...
Read More

HOW TO USE CHOOSE FUNCTION IN GOOGLE SHEETS ?

INTRODUCTION Life is full of choices and so is our GOOGLE SHEETS. Whenever we try to create smart sheets, we ...
Read More

HOW TO FILTER DATA IN GOOGLE SHEETS ?

INTRODUCTION In practical applications, in maximum cases , we have a large data which can’t be managed by just having ...
Read More

HOW TO CALCULATE ROI [ RETURN ON INVESTMENT ] IN GOOGLE SHEETS ?

INTRODUCTION We all make investments through different instruments but how would we decide which one is best for us. It ...
Read More

HOW TO CALCULATE CAGR [ COMPOUNDED ANNUAL GROWTH RATE ] IN GOOGLE SHEETS ?

INTRODUCTION We all make investments through different instruments but how would we decide which one is best for us. It ...
Read More

HOW TO CHECK THE EDITING HISTORY IN GOOGLE SHEETS?

INTRODUCTION “GOOGLE SHEETS is the name given to the spreadsheet software offered by GOOGLE ” which comes bundled with the ...
Read More

HOW TO COUNT THE NUMBER OF OCCURRENCES IN A COLUMN IN GOOGLE SHEETS

INTRODUCTION Knowledge is not complete unless we know how to apply it in our day to day applications. So we’ll ...
Read More

HOW TO RANDOMIZE DATA IN GOOGLE SHEETS ?

HOW TO RANDOMIZE THE DATA IN GOOGLE SHEETS ? INTRODUCTION RANDOMIZING can emerge as a requirement in GOOGLE SHEETS if ...
Read More

HOW TO REVERSE THE SORT ORDER OF THE DATA IN GOOGLE SHEETS ?

INTRODUCTION Sorting is putting up a number of things in a particular fashion as per the selected criteria. Sorting in ...
Read More

HOW TO USE ARRAYFORMULA FUNCTION IN GOOGLE SHEETS ?

INTRODUCTION ARRAYFORMULA is one of the very powerful and useful formulae in GOOGLE SHEETS which can be used as a ...
Read More

HOW TO USE RANDARRAY FUNCTION IN GOOGLE SHEETS ?

INTRODUCTION RANDARRAY FUNCTION is one of the very important and useful functions in GOOGLE SHEETS. It is an array function ...
Read More

HOW TO USE FIND FUNCTION IN GOOGLE SHEETS ?

INTRODUCTION FIND FUNCTION is one of the very important and useful functions in GOOGLE SHEETS. As FIND FUNCTION is concerned ...
Read More

HOW TO USE SEARCH FUNCTION IN GOOGLE SHEETS ?

INTRODUCTION SEARCH FUNCTION is one of the very important and useful functions in GOOGLE SHEETS . As SEARCH FUNCTION is ...
Read More

HOW TO CREATE A GANTT CHART IN GOOGLE SHEETS – WITH TEMPLATE

INTRODUCTION GANTT CHART is a special kind of chart which was made for assessing the progress of any task or ...
Read More

HOW TO ADD COLUMNS IN GOOGLE SHEETS

Rows and columns are the building blocks of any spreadsheet application like GOOGLE SHEETS which makes it mandatory to learn ...
Read More

CREATE RADAR CHART IN GOOGLE SHEETS

INTRODUCTION CHARTS are the graphic representation of any data . Google Sheets provide us a number of visualization options in ...
Read More

CREATE HISTOGRAM CHART IN GOOGLE SHEETS

INTRODUCTION CHARTS are the graphic representation of any data . As we know that GOOGLE SHEETS is a super analytical ...
Read More

CREATE WATERFALL CHART IN GOOGLE SHEETS

INTRODUCTION CHARTS are the graphic representation of any data . As we know that GOOGLE SHEETS provide us with a ...
Read More

HOW TO HYPERLINK IN GOOGLE SHEETS ?

INTRODUCTION When we are using any reports, we might need to go different locations in the workbook, or any website, ...
Read More

CREATE TIMELINE CHART IN GOOGLE SHEETS

INTRODUCTION CHARTS are the graphic representation of any data . Google Sheets provide us a number of visualization options in ...
Read More

HOW TO SHOW THE FORMULA USED IN GOOGLE SHEETS ?

INTRODUCTION We use a number of functions and formulas in our calculation sheets. We create various reports in Google Sheets ...
Read More

HOW TO GET MILITARY TIME IN GOOGLE SHEETS

INTRODUCTION DATES and TIME , if you are new to GOOGLE SHEETS and you have already tried using those format, ...
Read More

HOW TO INSERT A CHECKBOX IN GOOGLE SHEETS ?

INTRODUCTION A CHECKBOX is a visible element which returns a TRUE if checked and FALSE if the checkbox is unchecked ...
Read More

HOW TO ROTATE TEXT BOX IN GOOGLE SHEETS ?

INTRODUCTION We already learnt few things about the TEXT BOX here. But it is not enough to simply insert the ...
Read More

HOW TO INSERT TEXTBOX IN GOOGLE SHEETS ?

INTRODUCTION All of us have entered text in a cell by selecting the cell and simply typing the text in ...
Read More

HOW TO CREATE A DROP DOWN LIST IN GOOGLE SHEETS ?

INTRODUCTION Data validation means to check the data before entry. It gives us the power to condition the values which ...
Read More

HOW TO USE CONDITIONAL FORMATTING BASED ON ANOTHER CELL IN GOOGLE SHEETS ?

INTRODUCTION Conditional formatting is the formatting [ font, color, fill color , size etc. ] of data as per its ...
Read More

HOW TO INSERT DEGREE SYMBOL IN GOOGLE SHEETS

INTRODUCTION Degree symbol is known to everybody as it is used commonly. Every day differs from the other in respect ...
Read More

HOW TO INSERT EURO SYMBOL IN GOOGLE SHEETS

Let us start another exciting session of GOOGLE SHEETS Tricks with gyankosh.net. This article will let you know how to ...
Read More

HOW TO SPLIT CELL IN GOOGLE SHEETS

Whenever we prepare any report in GOOGLE SHEETS , generally we have two constituents in any report. The Text portion ...
Read More

HOW TO USE SPLIT FUNCTION IN GOOGLE SHEETS

INTRODUCTION SPLITTING is required frequently in any spreadsheet while manipulating the text. Splitting means to break any text into two ...
Read More

HOW TO CONVERT TEXT TO COLUMN IN GOOGLE SHEETS ?

INTRODUCTION We frequently need many operations in GOOGLE SHEETS when we are cleaning the data or making it more usable ...
Read More

HOW TO LOCK OR UNLOCK CELLS IN GOOGLE SHEETS ?

INTRODUCTION GOOGLE SHEETS has many great features. One of these great features is its Sharing Capabilities which gives us a ...
Read More

CREATE ORG CHART IN GOOGLE SHEETS

INTRODUCTION CHARTS are the graphic representation of any data . Google Sheets provide us a number of visualization options in ...
Read More

HOW TO CREATE COMBO CHART IN GOOGLE SHEETS

INTRODUCTION CHARTS are the graphic representation of any data . Google Sheets provide us a number of visualization options in ...
Read More

HOW TO CREATE 3D PIE CHART IN GOOGLE SHEETS

HOW TO CREATE 3D PIE CHART IN GOOGLE SHEETS INTRODUCTION CHARTS are the graphic representation of any data . Google ...
Read More

CREATE PIE CHART IN GOOGLE SHEETS

INTRODUCTION CHARTS are the graphic representation of any data . Google Sheets provide us a number of visualization options in ...
Read More

HOW TO CREATE A PIVOT CHART IN GOOGLE SHEETS?

INTRODUCTION PIVOT TABLE is a well known feature of GOOGLE SHEETS which everybody of us might have heard of. But ...
Read More

HOW TO SUBTRACT IN GOOGLE SHEETS

INTRODUCTION Mathematical operations are the basic tasks of any spreadsheet application. Similarly , we can perform all the basic operations ...
Read More

HOW TO FORMAT CELLS TO SHOW EURO SYMBOL WITH NUMBERS

INTRODUCTION So , we have discussed the different ways to INSERT EURO SYMBOL IN GOOGLE SHEETS. But what about the ...
Read More

HOW TO INSERT CHECK MARK SYMBOL IN GOOGLE SHEETS

INTRODUCTION Let us start another exciting session of LEARNING GOOGLE SHEETS with gyankosh.net This article will let you know how ...
Read More

HOW TO ZOOM IN GOOGLE SHEETS

INTRODUCTION Every person in this world has his own perception of big or small, good or bad, slow or fast ...
Read More

HOW TO SUPERSCRIPT TEXT IN GOOGLE SHEETS

INTRODUCTION Have you ever tried to insert a copyright symbol in GOOGLE SHEETS which is raised above the normal text ...
Read More

HOW TO SUBSCRIPT TEXT IN GOOGLE SHEETS

INTRODUCTION You must have seen the subscripted text or a number such as Log represented with a base or the ...
Read More

HOW TO INSERT HEADER AND FOOTER IN GOOGLE SHEETS ?

INTRODUCTION Header and Footer are very important portions of a report or presentation, when we are finalizing the reports. First ...
Read More

HOW TO USE DATE FUNCTION IN GOOGLE SHEETS

INTRODUCTION DATE function comes under the DATE FUNCTIONS category in GOOGLE SHEETS. DATE FUNCTION simply converts a given YEAR, MONTH ...
Read More

HOW TO USE TEXT FUNCTION IN GOOGLE SHEETS

INTRODUCTION TEXT FUNCTION is found under the TEXT FUNCTION CATEGORY of GOOGLE SHEETS. TEXT FUNCTION is specially created to format ...
Read More

HOW TO COPY CONDITIONAL FORMATTING IN GOOGLE SHEETS?

INTRODUCTION To have the knowledge of Conditional formatting is very important if we want to apply GOOGLE SHEETS in our ...
Read More

HOW TO USE CONDITIONAL FORMATTING IN GOOGLE SHEETS?

INTRODUCTION To have the knowledge of Conditional formatting is very important if we want to apply GOOGLE SHEETS in our ...
Read More

HOW TO USE VLOOKUP FUNCTION IN GOOGLE SHEETS

INTRODUCTION Welcome to the step by step guide to VLOOKUP in GOOGLE SHEETS. The article covers the introduction , basics ...
Read More

HOW TO SEND EMAIL FROM GOOGLE SHEETS

INTRODUCTION EMAIL is one of the most important mode of communication today. It is reliable , fast, realtime and green ...
Read More

HOW TO HIGHLIGHT THE DUPLICATE ENTRIES IN GOOGLE SHEETS

INTRODUCTION While analyzing the data, we might come across the repeated data which needs to be replaced or highlighted. If ...
Read More

HOW TO CREATE A TABLE IN GOOGLE SHEETS?

WHAT IS A TABLE IN GOOGLE SHEETS? “A TABLE IS A SET OF RELATED DATA [ FIGURES(DATA) AND DETAILS] PRESENTED ...
Read More

HOW TO MAKE CHART IN GOOGLE SHEETS?

CHARTS are the graphic representation of any data . Analysis of data is the process of deriving the inferences by ...
Read More

CREATE LINE GRAPH IN GOOGLE SHEETS

INTRODUCTION CHARTS are the graphic representation of any data . As we know that GOOGLE SHEETS is an emerging analytical ...
Read More

HOW TO USE MATCH FUNCTION IN GOOGLE SHEETS?

Looking up for values in reports is one of the most important tasks in GOOGLE SHEETS which we’d be needing ...
Read More

HOW TO USE WRAP TEXT IN GOOGLE SHEETS?

INTRODUCTION “WRAP TEXT IN GOOGLE SHEETS IS THE PROCESS OF WRAPPING (folding or compacting) THE TEXT TO MAKE IT VISIBLE ...
Read More

HOW TO INSERT A CALCULATED FIELD IN GOOGLE SHEETS

INTRODUCTION PIVOT TABLE is a well known feature of EXCEL which everybody of us might have heard of. But many ...
Read More

HOW TO CHANGE COLUMN NAMES IN GOOGLE SHEETS

INTRODUCTION PIVOT TABLE is a well known feature of EXCEL which everybody of us might have heard of. But many ...
Read More

HOW TO USE PIVOT TABLE IN GOOGLE SHEETS?

INTRODUCTION PIVOT TABLE is a well known feature of GOOGLE SHEETS which everybody of us might have heard of. But ...
Read More

HOW TO EMAIL GOOGLE SHEET

INTRODUCTION GOOGLE SHEET is growing popularity exponentially due to many benefits it offers to its users. One of the best ...
Read More

HOW TO DOWNLOAD GOOGLE SHEET IN PC AS PDF FILE

INTRODUCTION GOOGLE SHEET is gaining popularity exponentially due to many benefits it offers to its users. One of the best ...
Read More

HOW TO DOWNLOAD GOOGLE SHEET IN PC AS MICROSOFT EXCEL FORMAT

INTRODUCTION GOOGLE SHEET is growing popularity exponentially due to many benefits it offers to its users. One of the best ...
Read More

HOW TO REVERSE SORT OR UNSORT DATA IN GOOGLE SHEETS

INTRODUCTION Sorting is putting up a number of things in a particular fashion as per the selected criteria. Sorting in ...
Read More

HOW TO SORT DATA BY COLOR IN GOOGLE SHEETS

INTRODUCTION Sorting is putting up a number of things in a particular fashion as per the selected criteria. Sorting in ...
Read More

HOW TO SORT DATA IN GOOGLE SHEETS

INTRODUCTION Sorting is putting up a number of things in a particular fashion as per the selected criteria. Sorting in ...
Read More

HOW TO USE MERGE CELLS IN GOOGLE SHEETS?

INTRODUCTION “MERGING IS THE PROCESS OF JOINING THE TWO OR MORE CELL IN GOOGLE SHEETS”. THE CELLS CAN BE IN ...
Read More

GOOGLE SHEETS FUNCTION-CONCATENATE

INTRODUCTION CONCATENATE FUNCTION is one of the frequently used functions in GOOGLE SHEETS. While creating the reports, we come into ...
Read More

GOOGLE SHEETS – SUMIF FUNCTION

INTRODUCTION If you already know the very basic SUM FUNCTION , this SUMIF function is an advanced version of that, ...
Read More

HOW TO FREEZE ROWS IN GOOGLE SHEETS

Freezing panes (Certain Rows/Columns having headings etc.) in GOOGLE SHEETS is very important when we are working with big and ...
Read More

GOOGLE SHEETS FUNCTION-COUNTIF

INTRODUCTION COUNTIF function , as the name suggests, does the counting job in GOOGLE SHEETS , just like the COUNT ...
Read More

HOW TO USE PAINT FORMAT IN GOOGLE SHEETS

INTRODUCTION PAINT FORMAT is a utility given in GOOGLE SHEETS which is used to copy the format of one text ...
Read More