“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 SORT PIVOT TABLE IN GOOGLE SHEETS?
Table of Contents WHY AM I NOT ABLE TO SORT MY PIVOT TABLE IN GOOGLE SHEETS? STANDARD WAYS TO SORT ...
Read More
Read More
TRICKS TO CONVERT TIME TO DECIMAL IN GOOGLE SHEETS
Table of Contents HOW TIME IS REPRESENTED AS DECIMAL IN GOOGLE SHEETS? STEPS TO CONVERT TIME TO DECIMAL NUMBER IN ...
Read More
Read More
HOW TO ADJUST ROW HEIGHT IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHERE TO FIND BUTTON LOCATION TO ADJUST ROW HEIGHT IN GOOGLE SHEETS ? SET FIXED ROW ...
Read More
Read More
HOW TO APPLY OR REMOVE BORDER IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHAT IS A BORDER? HOW TO APPLY BORDER TO A TABLE IN GOOGLE SHEETS? HOW TO ...
Read More
Read More
HOW TO USE NOW FUNCTION IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PURPOSE OF NOW FUNCTION IN GOOGLE SHEETS WHAT IS THE SYNTAX OF NOW FUNCTION IN GOOGLE ...
Read More
Read More
HOW TO CREATE A TIMESTAMP IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHAT IS A TIME STAMP IN GOOGLE SHEETS? HOW TO CREATE TIMESTAMP IN GOOGLE SHEETS? CREATING ...
Read More
Read More
HOW TO USE IF FUNCTION IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PURPOSE OF IF IN GOOGLE SHEETS PREREQUISITES TO LEARN IF FUNCTION IN GOOGLE SHEETS WHAT IS ...
Read More
Read More
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: ...
Read More
Read More
HOW TO STRIKETHROUGH IN GOOGLE SHEETS USING CONDITIONAL FORMATTING?
Table of Contents INTRODUCTION WHERE DO YOU FIND CONDITIONAL FORMATTING OPTION IN GOOGLE SHEETS EXAMPLE 1:STRIKETHROUGH THE NUMBERS LESS THAN ...
Read More
Read More
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 ...
Read More
Read More
HOW TO SUBTRACT PERCENTAGE IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHAT IS A PERCENTAGE? HOW TO CALCULATE PERCENTAGE IN GOOGLE SHEETS? IMPORTANT TERMS IN SUBTRACTION WHAT ...
Read More
Read More
HOW TO FORMAT PHONE NUMBERS IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHY TO FORMAT THE PHONE NUMBERS IN GOOGLE SHEETS? EXAMPLE: HOW TO FORMAT THE GIVEN NUMBER ...
Read More
Read More
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 ...
Read More
Read More
HOW TO CHECK IF CELL CONTAINS TEXT OR NUMBER IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN GOOGLE SHEETS? WHEN DO WE NEED TO CHECK IF CELL CONTAINS ...
Read More
Read More
HOW TO COUNT BLANK CELLS USING COUNTBLANK FUNCTION IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PURPOSE OF COUNTBLANK FUNCTION IN GOOGLE SHEETS PREREQUISITES TO LEARN COUNTBLANK FUNCTION WHAT IS THE SYNTAX ...
Read More
Read More
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 ...
Read More
Read More
HOW TO FIND AND COUNT UNIQUE VALUES, UNIQUE TEXT VALUES OR UNIQUE NUMBERS IN GOOGLE SHEETS?
Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN GOOGLE SHEETS? WHAT ARE UNIQUE VALUES? FIND AND COUNT UNIQUE TEXT ...
Read More
Read More
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 / ...
Read More
Read More
HOW TO APPEND TEXT IN GOOGLE SHEETS?
Table of Contents INTRODUCTION HOW TEXT IS HANDLED IN GOOGLE SHEETS? APPEND TEXT IN GOOGLE SHEETS 1.USING & OPERATOR: 2 ...
Read More
Read More
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 ...
Read More
Read More
HOW TO USE AND FUNCTION IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PURPOSE OF AND FUNCTION IN GOOGLE SHEETS PREREQUISITES TO LEARN AND SYNTAX: AND FUNCTION IN GOOGLE ...
Read More
Read More
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 ...
Read More
Read More
HOW TO ADD OR REMOVE DOLLAR SIGN[ $ ] IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHEN TO USE DOLLAR SYMBOL ADD A DOLLAR SIGN IN GOOGLE SHEETS DIRECT KEYBOARD METHOD 1 ...
Read More
Read More
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 ...
Read More
Read More
HOW TO DRAW IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION WHY WE NEED TO DRAW IN GOOGLE SHEETS? WHERE IS THE BUTTON TO DRAW IN GOOGLE ...
Read More
Read More
HOW TO CREATE MACROS IN GOOGLE SHEETS IN A MINUTE?
Table of Contents INTRODUCTION WHERE TO FIND THE BUTTON LOCATION OF MACRO IN GOOGLE SHEETS ? STEPS TO CREATE A ...
Read More
Read More
HOW TO USE INDEX MATCH IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION COMBINING INDEX AND MATCH IN GOOGLE SHEETS PURPOSE OF INDEX-MATCH IN GOOGLE SHEETS SYNTAX: INDEX-MATCH IN ...
Read More
Read More
HOW TO INSERT DATE IN GOOGLE SHEETS?
Table of Contents INTRODUCTION DIFFERENT WAYS TO INSERT DATE IN GOOGLE SHEETS INSERT DATE USING DATE FUNCTION IN GOOGLE SHEETS ...
Read More
Read More
HOW TO INSERT TIME IN GOOGLE SHEETS?
Table of Contents INTRODUCTION DIFFERENT WAYS TO INSERT DATE IN GOOGLE SHEETS DIRECT TIME ENTRY INSERT TIME USING TIME FUNCTION ...
Read More
Read More
WHAT IS INDEX FUNCTION IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PURPOSE OF INDEX FUCTION IN GOOGLE SHEETS PREREQUISITES TO LEARN INDEX SYNTAX: INDEX FUNCTION EXAMPLE 1:RETRIEVE ...
Read More
Read More
HOW TO TYPE OR INSERT RUPEE SYMBOL [₹] IN GOOGLE SHEETS?[₹]
Table of Contents INTRODUCTION WHEN TO USE RUPEE SYMBOL ? TYPE A RUPEE SYMBOL IN GOOGLE SHEETS 1. COPY PASTE ...
Read More
Read More
HOW TO TYPE OR INSERT A DELTA SYMBOL IN GOOGLE SHEETS [Δ or δ] ?
Table of Contents INTRODUCTION WHAT IS A DELTA SYMBOL [ δ or Δ] ? ADD A SMALL OR CAPITAL DELTA ...
Read More
Read More
HOW TO USE CONDITIONAL FORMATTING BASED ON TEXT IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHAT IS CONDITIONAL FORMATTING BASED ON TEXT? HOW TEXT IS HANDLED IN GOOGLE SHEETS? WHAT IS ...
Read More
Read More
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 ...
Read More
Read More
HOW TO SEPARATE LAST NAME AND FIRST NAME IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PURPOSE OF SEGREGATING LAST NAME AND FIRST NAME IN GOOGLE SHEETS HOW TEXT IS HANDLED IN ...
Read More
Read More
HOW TO SET ALTERNATE ROW COLOR IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION WHAT ARE ALTERNATE ROW COLORS IN GOOGLE SHEETS? PURPOSE OF ALTERNATE ROW COLORS IN GOOGLE SHEETS ...
Read More
Read More
HOW TO FIND OUT WORKING DAYS BETWEEN TWO GIVEN DATES IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PURPOSE OF NETWORKDAYS FUNCTION IN GOOGLE SHEETS PREREQUISITES TO LEARN NETWORKDAYS SYNTAX: NETWORKDAYS FUNCTION IN GOOGLE ...
Read More
Read More
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 ...
Read More
Read More
HOW TO USE INDIRECT FUNCTION IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PURPOSE OF INDIRECT FUNCTION IN GOOGLE SHEETS PREREQUISITES TO LEARN TRANSPOSE FUNCTION SYNTAX: INDIRECT FUNCTION IN ...
Read More
Read More
HOW TO USE SUBSTRING FUNCTION IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION PURPOSE OF SUBSTRING EXTRACTION IN GOOGLE SHEETS ? CONCEPT: EXTRACT SUBSTRING FROM THE GIVEN TEXT EXAMPLES ...
Read More
Read More
HOW TO USE TRANSPOSE FUNCTION IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PURPOSE OF TRANSPOSE FUNCTION IN GOOGLE SHEETS PREREQUISITES TO LEARN TRANSPOSE FUNCTION SYNTAX: TRANSPOSE FUNCTION IN ...
Read More
Read More
WHAT ARE SLICERS ? HOW TO USE SLICERS IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PREREQUISITES TO USE SLICER IN GOOGLE SHEETS BUTTON LOCATION FOR SLICER STEPS TO CREATE A SLICER ...
Read More
Read More
HOW TO ADD HOURS IN GOOGLE SHEETS?
Table of Contents INTRODUCTION HOW HOURS ARE HANDLED IN GOOGLE SHEETS? ADD HOURS IN GOOGLE SHEETS HOW TO EXTRACT THE ...
Read More
Read More
SIMPLE WAYS TO DISABLE CELL EDITING IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHAT IS DISABLING THE CELLS, COLUMNS, OR ROWS IN GOOGLE SHEETS? WHY TO DISABLE CELL EDITING ...
Read More
Read More
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 ...
Read More
Read More
HOW TO USE TIME IN GOOGLE SHEETS QUERY LANGUAGE?
Table of Contents INTRODUCTION BASICS OF TIME CALCULATION IN GOOGLE SHEETS QUERY WHAT ARE THE DIFFERENT OPERATIONS ON TIME USING ...
Read More
Read More
HOW TO USE LABEL QUERY IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PURPOSE OF LABEL QUERY CLAUSE IN GOOGLE QUERY LANGUAGE HOW TO USE LABEL CLAUSE WITH OTHER ...
Read More
Read More
HOW TO MANAGE DATES IN GOOGLE SHEETS QUERY ?
Table of Contents INTRODUCTION HOW DATES WORK IN GOOGLE SHEETS ? DIFFERENT OPERATIONS WHICH CAN BE DONE ON DATES USING ...
Read More
Read More
HOW TO USE WHERE QUERY CLAUSE IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION PURPOSE OF WHERE QUERY CLAUSE IN GOOGLE QUERY LANGUAGE EXAMPLES: EXAMPLE DATA: EXAMPLE 1 : DISPLAY ...
Read More
Read More
HOW TO USE PIVOT QUERY CLAUSE IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION PURPOSE OF PIVOT CLAUSE IN GOOGLE QUERY LANGUAGE EXAMPLES: EXAMPLE DATA: EXAMPLE 1 : DISPLAY THE ...
Read More
Read More
HOW TO USE QUERY FUNCTION IN MULTIPLE SHEETS ?
Table of Contents INTRODUCTION PURPOSE OF USING GOOGLE SHEETS QUERIES IN MULTIPLE SHEETS HOW TO USE THE QUERIES IN GOOGLE ...
Read More
Read More
HOW TO USE IMPORTRANGE FUNCTION IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION PURPOSE OF IMPORTRANGE FUNCTION IN GOOGLE SHEETS PREREQUISITES TO LEARN IMPORTRANGE FUNCTION SYNTAX: IMPORTRANGE FUNCTION IN ...
Read More
Read More
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 ...
Read More
Read More
HOW TO USE GROUP BY QUERY CLAUSE IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION PURPOSE OF GOOGLE QUERY LANGUAGE CLAUSE- GROUP BY EXAMPLES: EXAMPLE DATA: EXAMPLE 1 : FIND THE ...
Read More
Read More
HOW TO USE QUERY FUNCTION IN GOOGLE SHEETS ?
INTRODUCTION GOOGLE SHEETS is the spreadsheet application offered by Google which is one of the best spreadsheet application. One of ...
Read More
Read More
WHAT IS GOOGLE QUERY LANGUAGE IN GOOGLE SHEETS ?
INTRODUCTION If you are familiar with SQL SERVER application, you must be knowing the meaning of the Query word. Queries ...
Read More
Read More
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: ...
Read More
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
Read More
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 ...
Read More
Read More
HOW TO CREATE SPARKLINE [ CHART IN A CELL ] IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHEN TO USE SPARKLINE CHARTS ? STEPS TO CREATE SPARKLINES IN GOOGLE SHEETS SYNTAX OF SPARKLINE ...
Read More
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
Read More
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 ...
Read More
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
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
Read More
HOW TO USE CHOOSE FUNCTION IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION PURPOSE OF CHOOSE FUNCTION IN GOOGLE SHEETS PREREQUISITES TO LEARN CHOOSE SYNTAX: CHOOSE FUNCTION EXAMPLE: CHOOSE ...
Read More
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
Read More
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 ] ...
Read More
Read More
HOW TO CALCULATE CAGR [ COMPOUNDED ANNUAL GROWTH RATE ] IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION WHAT IS CAGR [ COMPOUND ANNUAL GROWTH RATE ] ? HOW CAGR IS CALCULATED IN GOOGLE ...
Read More
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
Read More
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 ...
Read More
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
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
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
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
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
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
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
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
Read More
CREATE RADAR CHART IN GOOGLE SHEETS
Table of Contents INTRODUCTION WHAT IS A RADAR CHART ? WHEN DO WE NEED RADAR CHARTS? BUTTON LOCATION FOR INSERTING ...
Read More
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
Read More
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 ...
Read More
Read More
HOW TO HYPERLINK IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION WHY TO USE HYPERLINKS IN GOOGLE SHEETS DIFFERENT WAYS TO INSERT HYPERLINKS IN GOOGLE SHEETS METHOD ...
Read More
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
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
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
Read More
HOW TO INSERT A CHECKBOX IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION WHY TO USE CHECKBOX IN GOOGLE SHEETS ? BUTTON LOCATION FOR INSERTION OF CHECK BOX IN ...
Read More
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
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
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
Read More
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 ...
Read More
Read More
HOW TO INSERT DEGREE SYMBOL [ ° ] IN GOOGLE SHEETS [ °C ]?
Table of Contents INTRODUCTION WHAT IS A DEGREE ? INSERT DEGREE SYMBOL IN GOOGLE SHEETS 1. READY TO USE DEGREE ...
Read More
Read More
HOW TO TYPE OR INSERT EURO SYMBOL [€] IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION WHEN TO USE EURO SYMBOL ADD A EURO SYMBOL IN GOOGLE SHEETS 1. READY TO USE ...
Read More
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
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
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
Read More
HOW TO LOCK OR UNLOCK CELLS IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION HOW TO LOCK CELLS IN GOOGLE SHEETS HOW TO PROTECT COMPLETE SHEET IN GOOGLE SHEETS STEPS ...
Read More
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
Read More
HOW TO CREATE COMBO CHART IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION WHAT ARE COMBO CHART IN GOOGLE SHEETS ? WHERE IS THE OPTION TO CREATE COMBO CHART ...
Read More
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
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
Read More
HOW TO CREATE A PIVOT CHARTS IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHAT IS A PIVOT CHART? PURPOSE OF PIVOT CHARTS IN GOOGLE SHEETS EXAMPLE 1: CREATE PIVOT ...
Read More
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
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
Read More
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 ...
Read More
Read More
HOW TO ZOOM OUT ON GOOGLE SHEETS?
Table of Contents INTRODUCTION WHEN TO ZOOM OUT OR ZOOM IN ON GOOGLE SHEETS ? STANDARD ICONS OF ZOOM IN ...
Read More
Read More
HOW TO SUPERSCRIPT TEXT IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHEN IS SUPERSCRIPT USED IN GOOGLE SHEETS ? WAYS TO SUPERSCRIPT TEXT IN GOOGLE SHEETS SUPERSCRIPT ...
Read More
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
Read More
HOW TO ADD A HEADER AND FOOTER IN GOOGLE SHEETS ?
Table of Contents INTRODUCTION WHERE IS HEADER AND FOOTER OPTION PRESENT IN GOOGLE SHEETS ? STEPS TO INSERT HEADER OR ...
Read More
Read More
HOW TO USE DATE FUNCTION IN GOOGLE SHEETS
Table of Contents INTRODUCTION PURPOSE OF DATE FUNCTION IN GOOGLE SHEETS PREREQUISITES TO LEARN DATE WHAT IS THE SYNTAX OF ...
Read More
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
Read More
HOW TO COPY OR DUPLICATE CONDITIONAL FORMATTING IN GOOGLE SHEETS?
Table of Contents INTRODUCTION DIFFERENT WAYS TO COPY CONDITIONAL FORMATTING IN GOOGLE SHEETS HIGHLIGHTING THE ATTENDANCE BETWEEN 90 AND 95 ...
Read More
Read More
HOW TO USE CONDITIONAL FORMATTING IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHERE DO YOU FIND CONDITIONAL FORMATTING OPTION IN GOOGLE SHEETS EXAMPLE 1:DATA SAMPLE STEPS TO HIGHLIGHT ...
Read More
Read More
HOW TO USE VLOOKUP FUNCTION IN GOOGLE SHEETS
Table of Contents INTRODUCTION PURPOSE OF VLOOKUP IN GOOGLE SHEETS PREREQUISITES TO LEARN VLOOKUP SYNTAX: VLOOKUP FUNCTION IN GOOGLE SHEETS ...
Read More
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
Read More
HOW TO FIND AND HIGHLIGHT THE DUPLICATES IN GOOGLE SHEETS
Table of Contents INTRODUCTION WHEN TO HIGHLIGHT THE DUPLICATES IN GOOGLE SHEETS? STEPS TO FIND AND HIGHLIGHT THE DUPLICATES IN ...
Read More
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
Read More
HOW TO MAKE CHART IN GOOGLE SHEETS?
Table of Contents INTRODUCTION BUTTON LOCATION TO CREATE CHARTS IN GOOGLE SHEETS BENEFITS OF CHARTS STEPS TO INSERT A CHART ...
Read More
Read More
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 ...
Read More
Read More
HOW TO USE MATCH FUNCTION IN GOOGLE SHEETS?
Table of Contents INTRODUCTION PURPOSE OF MATCH IN GOOGLE SHEETS PREREQUISITES TO LEARN MATCH SYNTAX FORMULA OF MATCH FUNCTION IN ...
Read More
Read More
HOW TO USE WRAP TEXT IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHERE TO FIND WRAP TEXT BUTTON IN GOOGLE SHEETS? WHEN TO USE WRAP TEXT IN GOOGLE ...
Read More
Read More
HOW TO INSERT A CALCULATED FIELD IN GOOGLE SHEETS
Table of Contents INTRODUCTION WHAT IS A CALCULATED FIELD IN GOOGLE SHEETS HOW TO INSERT A NEW CALCULATED FIELD IN ...
Read More
Read More
HOW TO CHANGE COLUMN NAMES OF PIVOT TABLES IN GOOGLE SHEETS
Table of Contents INTRODUCTION PROBLEM: HOW TO CHANGE COLUMN NAME OF PIVOT TABLE IN GOOGLE SHEETS SOLUTION: INTRODUCTION PIVOT TABLE ...
Read More
Read More
HOW TO CREATE A PIVOT TABLE IN GOOGLE SHEETS?
Table of Contents INTRODUCTION WHAT IS A PIVOT TABLE IN GOOGLE SHEETS? WHERE DO I FIND PIVOT TABLE OPTION IN ...
Read More
Read More
HOW TO EMAIL GOOGLE SHEET
Table of Contents INTRODUCTION DIFFERENT FORMATS IN WHICH WE CAN EMAIL GOOGLE SHEETS STEPS TO SEND GOOGLE SHEET AS EMAIL ...
Read More
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
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
Read More
HOW TO REVERSE SORT OR UNSORT DATA IN GOOGLE SHEETS
Table of Contents INTRODUCTION WHAT IS UNSORTING OR REVERSE SORTING IN GOOGLE SHEETS? WAYS TO REVERSE SORT DATA IN GOOGLE ...
Read More
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
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
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
Read More
GOOGLE SHEETS FUNCTION-CONCATENATE
Table of Contents INTRODUCTION PURPOSE OF CONCATENATE FUNCTION IN GOOGLE SHEETS PREREQUISITES TO LEARN CONCATENATE FUNCTION SYNTAX: CONCATENATE FUNCTION EXAMPLES: ...
Read More
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
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
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
Read More
HOW TO USE FORMAT PAINTER IN GOOGLE SHEETS
Table of Contents INTRODUCTION WHERE TO FIND THE OPTION TO USE FORMAT PAINTER IN GOOGLE SHEETS? WHAT ARE THE STEPS ...
Read More
Read More
