“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.

## CHOOSE THE TOPIC OF YOUR CHOICE

#### HOW TO USE NESTED IF STATEMENT IN GOOGLE SHEETS?

Table of Contents INTRODUCTION STANDARD IF FUNCTION USAGE WHAT IS NESTING A FUNCTION? HOW TO NEST IF FUNCTION? EXAMPLE 1: ...

#### HOW TO APPLY FORMULA TO ENTIRE COLUMN IN GOOGLE SHEETS?

Table of Contents INTRODUCTION WHAT DO WE MEAN BY APPLYING THE FORMULA TO THE ENTIRE COLUMN? WAYS TO APPLY FORMULA ...

#### HOW TO COUNT DUPLICATE VALUES IN GOOGLE SHEETS?

INTRODUCTION GOOGLE SHEETS allows us to use many DIRECT-TO-USE functions which we can use to get the desired output. Even ...

#### HOW TO COUNT THE CELLS CONTAINING SPECIFIC TEXT IN GOOGLE SHEETS?

Table of Contents INTRODUCTION PURPOSE EXAMPLE 1: COUNT THE NUMBER OF CELLS WHICH CONTAIN THE TEXT “THE” [EXACT ] IN ...

#### HOW TO TYPE LONG DIVISION SYMBOL [ ⟌ ] IN GOOGLE SHEETS?

Table of Contents INTRODUCTION WHAT IS DIVISION OR DIVIDING? DIFFERENT DIVISION SIGNS DIFFERENT WAYS TO INSERT A LONG DIVISION / ...

#### HOW TO CALCULATE PERCENTILE IN GOOGLE SHEETS?

Table of Contents INTRODUCTION WHAT IS A PERCENTILE ? WHY DO WE NEED TO CALCULATE THE PERCENTILE ? HOW TO ...

#### HOW TO USE CONDITIONAL FORMATTING BASED ON CHECKBOX IN GOOGLE SHEETS?

Table of Contents INTRODUCTION WHAT IS CONDITIONAL FORMATTING BASED ON CHECKBOX? EXAMPLES: EXAMPLE 1: HIGHLIGHT THE CELLS BY CHECKING OR ...

#### HOW TO ASSIGN AND RUN A MACRO USING BUTTON IN GOOGLE SHEETS?

Table of Contents INTRODUCTION WHY DO WE NEED TO RUN A MACRO FROM A BUTTON ? CREATE A BUTTON TO ...

#### HOW TO ENABLE DARK MODE IN GOOGLE SHEETS ?

Table of Contents INTRODUCTION WHAT IS A DARK MODE ? WHY DO WE NEED DARK MODE? IS DARK MODE AVAILABLE ...

#### HOW TO DO FACTORIAL IN GOOGLE SHEETS ?

INTRODUCTION Choosing the ways in which we can make the arrangements creates the pattern in which we multiply the number ...

#### HOW TO SCAN RECEIPTS AND IMPORT TO EXCEL ?

Table of Contents INTRODUCTION WHY TO SCAN THE RECEIPTS? PREREQUISITES TO SCAN AND IMPORT THE RECEIPTS IN EXCEL STEPS TO ...

#### HOW TO USE ORDER BY QUERY CLAUSE IN GOOGLE SHEETS ?

INTRODUCTION GOOGLE SHEETS is a free SPREADSHEET APPLICATION for personal use and it is getting a good attention these days ...

#### HOW TO USE QUERY FUNCTION IN GOOGLE SHEETS ?

INTRODUCTION If you are familiar with SQL SERVER application, you must be knowing the meaning of the Query word. Queries ...

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

Table of Contents INTRODUCTION WHAT IS IRR [ INTERNAL RATE OF RETURN ] ? SYNTAX OF IRR FUNCTION EXAMPLE 1: ...

#### 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 ...

#### HOW TO CREATE WINLOSS SPARKLINE IN GOOGLE SHEETS ?

Table of Contents INTRODUCTION WHAT IS WINLOSS SPARKLINE ? WHEN SHOULD WE USE WINLOSS SPARKLINE ? STEPS TO CREATE WINLOSS ...

#### 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 ...

#### HOW TO USE MODE.SNGL IN GOOGLE SHEETS ?

INTRODUCTION GOOGLE SHEETS is the spreadsheet application offered by GOOGLE and is growing popularity these days. One of the functionalities ...

#### 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 ...

#### 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 ...

#### 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 ...

#### HOW TO CALCULATE ROI IN GOOGLE SHEETS [RETURN ON INVESTMENT] ? – FREE ROI TEMPLATE INCLUDED

Table of Contents INTRODUCTION WHAT IS ROI [ RETURN ON INVESTMENTS ] ? HOW RETURN ON INVESTMENT [ ROI ] ...

#### 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 ...

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

Table of Contents INTRODUCTION NUMBER OF OCCURRENCES IN A COLUMN WHEN THE DATA IS NUMBER USING FREQUENCY FUNCTION PLANNING THE ...

#### 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 ...

#### 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 ...

#### 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 ...

#### 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 ...

#### 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 ...

#### 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 ...

#### 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 ...

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

#### 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 ...

#### CREATE WATERFALL CHART IN GOOGLE SHEETS

Table of Contents INTRODUCTION WHAT IS A WATERFALL CHART WHEN TO USE WATERFALL CHARTS BUTTON LOCATION FOR WATERFALL CHART IN ...

#### 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 ...

#### 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 ...

#### 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, ...

#### 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 ...

#### 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 ...

#### 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 ...

#### HOW TO USE CONDITIONAL FORMATTING BASED ON ANOTHER CELL [DROP DOWN LIST] IN GOOGLE SHEETS ?

Table of Contents INTRODUCTION WHEN WE NEED TO USE CONDITIONAL FORMATTING BASED ON ANOTHER CELL ? EXAMPLE 1: CONTROLLING THE ...

#### 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 ...

#### 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 ...

#### 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 ...

#### 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 ...

#### 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 ...

#### 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 ...

#### 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 ...

#### 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 ...

#### HOW TO INSERT CHECK MARK OR TICK MARK 🗸🗸 SYMBOL IN GOOGLE SHEETS

Table of Contents INTRODUCTION WHAT IS A CHECK MARK SYMBOL ? TYPE A CHECK MARK OR TICK MARK SYMBOL IN ...

#### 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 ...

#### 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 ...

#### 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 ...

#### 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 ...

#### CREATE LINE GRAPH IN GOOGLE SHEETS

Table of Contents INTRODUCTION WHEN TO USE LINE CHARTS BUTTON LOCATION FOR LINE CHARTS STEPS TO INSERT A LINE GRAPH ...

#### HOW TO EMAIL GOOGLE SHEET

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

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

#### 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 ...

#### 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 ...

#### 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 ...

#### GOOGLE SHEETS – SUMIF FUNCTION

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

#### 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 ...