“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?
Read More
TRICKS TO CONVERT TIME TO DECIMAL IN GOOGLE SHEETS
Read More
HOW TO ADJUST ROW HEIGHT IN GOOGLE SHEETS?
Read More
HOW TO APPLY OR REMOVE BORDER IN GOOGLE SHEETS?
Read More
HOW TO USE NOW FUNCTION IN GOOGLE SHEETS?
Read More
HOW TO CREATE A TIMESTAMP IN GOOGLE SHEETS?
Read More
HOW TO USE IF FUNCTION IN GOOGLE SHEETS?
Read More
HOW TO USE NESTED IF STATEMENT IN GOOGLE SHEETS?
Read More
HOW TO STRIKETHROUGH IN GOOGLE SHEETS USING CONDITIONAL FORMATTING?
Read More
HOW TO APPLY FORMULA TO ENTIRE COLUMN IN GOOGLE SHEETS?
Read More
HOW TO SUBTRACT PERCENTAGE IN GOOGLE SHEETS?
Read More
HOW TO FORMAT PHONE NUMBERS IN GOOGLE SHEETS?
Read More
HOW TO COUNT DUPLICATE VALUES IN GOOGLE SHEETS?
Read More
HOW TO CHECK IF CELL CONTAINS TEXT OR NUMBER IN GOOGLE SHEETS ?
Read More
HOW TO COUNT BLANK CELLS USING COUNTBLANK FUNCTION IN GOOGLE SHEETS?
Read More
HOW TO COUNT THE CELLS CONTAINING SPECIFIC TEXT IN GOOGLE SHEETS?
Read More
HOW TO FIND AND COUNT UNIQUE VALUES, UNIQUE TEXT VALUES OR UNIQUE NUMBERS IN GOOGLE SHEETS?
Read More
HOW TO TYPE LONG DIVISION SYMBOL [ ⟌ ] IN GOOGLE SHEETS?
Read More
HOW TO APPEND TEXT IN GOOGLE SHEETS?
Read More
HOW TO CALCULATE PERCENTILE IN GOOGLE SHEETS?
Read More
HOW TO USE AND FUNCTION IN GOOGLE SHEETS?
Read More
HOW TO USE CONDITIONAL FORMATTING BASED ON CHECKBOX IN GOOGLE SHEETS?
Read More
HOW TO ADD OR REMOVE DOLLAR SIGN[ $ ] IN GOOGLE SHEETS?
Read More
HOW TO ASSIGN AND RUN A MACRO USING BUTTON IN GOOGLE SHEETS?
Read More
HOW TO DRAW IN GOOGLE SHEETS ?
Read More
HOW TO CREATE MACROS IN GOOGLE SHEETS IN A MINUTE?
Read More
HOW TO USE INDEX MATCH IN GOOGLE SHEETS ?
Read More
HOW TO INSERT DATE IN GOOGLE SHEETS?
Read More
HOW TO INSERT TIME IN GOOGLE SHEETS?
Read More
WHAT IS INDEX FUNCTION IN GOOGLE SHEETS?
Read More
HOW TO TYPE OR INSERT RUPEE SYMBOL [₹] IN GOOGLE SHEETS?[₹]
Read More
HOW TO TYPE OR INSERT A DELTA SYMBOL IN GOOGLE SHEETS [Δ or δ] ?
Read More
HOW TO USE CONDITIONAL FORMATTING BASED ON TEXT IN GOOGLE SHEETS?
Read More
HOW TO ENABLE DARK MODE IN GOOGLE SHEETS ?
Read More
HOW TO SEPARATE LAST NAME AND FIRST NAME IN GOOGLE SHEETS?
Read More
HOW TO SET ALTERNATE ROW COLOR IN GOOGLE SHEETS ?
Read More
HOW TO FIND OUT WORKING DAYS BETWEEN TWO GIVEN DATES IN GOOGLE SHEETS?
Read More
HOW TO DO FACTORIAL IN GOOGLE SHEETS ?
Read More
HOW TO USE INDIRECT FUNCTION IN GOOGLE SHEETS?
Read More
HOW TO USE SUBSTRING FUNCTION IN GOOGLE SHEETS ?
Read More
HOW TO USE TRANSPOSE FUNCTION IN GOOGLE SHEETS?
Read More
WHAT ARE SLICERS ? HOW TO USE SLICERS IN GOOGLE SHEETS?
Read More
HOW TO ADD HOURS IN GOOGLE SHEETS?
Read More
SIMPLE WAYS TO DISABLE CELL EDITING IN GOOGLE SHEETS?
Read More
HOW TO SCAN RECEIPTS AND IMPORT TO EXCEL ?
Read More
HOW TO USE TIME IN GOOGLE SHEETS QUERY LANGUAGE?
Read More
HOW TO USE LABEL QUERY IN GOOGLE SHEETS?
Read More
HOW TO MANAGE DATES IN GOOGLE SHEETS QUERY ?
Read More
HOW TO USE WHERE QUERY CLAUSE IN GOOGLE SHEETS ?
Read More
HOW TO USE PIVOT QUERY CLAUSE IN GOOGLE SHEETS ?
Read More
HOW TO USE QUERY FUNCTION IN MULTIPLE SHEETS ?
Read More
HOW TO USE IMPORTRANGE FUNCTION IN GOOGLE SHEETS ?
Read More
HOW TO USE ORDER BY QUERY CLAUSE IN GOOGLE SHEETS ?
Read More
HOW TO USE GROUP BY QUERY CLAUSE IN GOOGLE SHEETS ?
Read More
HOW TO USE QUERY FUNCTION IN GOOGLE SHEETS ?
Read More
WHAT IS GOOGLE QUERY LANGUAGE IN GOOGLE SHEETS ?
Read More
HOW TO CALCULATE IRR [INTERNAL RATE OF RETURN ] USING GOOGLE SHEETS ?
Read More
HOW TO CREATE A STOCK PORTFOLIO TRACKER WITH TEMPLATE?
Read More
HOW TO CREATE WINLOSS SPARKLINE IN GOOGLE SHEETS ?
Read More
HOW TO CREATE SPARKLINE [ CHART IN A CELL ] IN GOOGLE SHEETS?
Read More
HOW TO USE MODE.MULT IN GOOGLE SHEETS ?
Read More
HOW TO USE MODE.SNGL IN GOOGLE SHEETS ?
Read More
HOW TO USE MODE FUNCTION IN GOOGLE SHEETS ?
Read More
GOOGLE SHEETS FOR KIDS [ 3-5 YEARS]- RECOGNIZE THE NUMBERS AND ALPHABET
Read More
HOW TO USE CHOOSE FUNCTION IN GOOGLE SHEETS ?
Read More
HOW TO FILTER DATA IN GOOGLE SHEETS ?
Read More
HOW TO CALCULATE ROI IN GOOGLE SHEETS [RETURN ON INVESTMENT] ? – FREE ROI TEMPLATE INCLUDED
Read More
HOW TO CALCULATE CAGR [ COMPOUNDED ANNUAL GROWTH RATE ] IN GOOGLE SHEETS ?
Read More
HOW TO CHECK THE EDITING HISTORY IN GOOGLE SHEETS?
Read More
HOW TO COUNT THE NUMBER OF OCCURRENCES IN A COLUMN IN GOOGLE SHEETS
Read More
HOW TO RANDOMIZE DATA IN GOOGLE SHEETS ?
Read More
HOW TO REVERSE THE SORT ORDER OF THE DATA IN GOOGLE SHEETS ?
Read More
HOW TO USE ARRAYFORMULA FUNCTION IN GOOGLE SHEETS ?
Read More
HOW TO USE RANDARRAY FUNCTION IN GOOGLE SHEETS ?
Read More
HOW TO USE FIND FUNCTION IN GOOGLE SHEETS ?
Read More
HOW TO USE SEARCH FUNCTION IN GOOGLE SHEETS ?
Read More
HOW TO CREATE A GANTT CHART IN GOOGLE SHEETS – WITH TEMPLATE
Read More
HOW TO ADD COLUMNS IN GOOGLE SHEETS
Read More
CREATE RADAR CHART IN GOOGLE SHEETS
Read More
CREATE HISTOGRAM CHART IN GOOGLE SHEETS
Read More
CREATE WATERFALL CHART IN GOOGLE SHEETS
Read More
HOW TO HYPERLINK IN GOOGLE SHEETS ?
Read More
CREATE TIMELINE CHART IN GOOGLE SHEETS
Read More
HOW TO SHOW THE FORMULA USED IN GOOGLE SHEETS ?
Read More
HOW TO GET MILITARY TIME IN GOOGLE SHEETS
Read More
HOW TO INSERT A CHECKBOX IN GOOGLE SHEETS ?
Read More
HOW TO ROTATE TEXT BOX IN GOOGLE SHEETS ?
Read More
HOW TO INSERT TEXTBOX IN GOOGLE SHEETS ?
Read More
HOW TO CREATE A DROP DOWN LIST IN GOOGLE SHEETS ?
Read More
HOW TO USE CONDITIONAL FORMATTING BASED ON ANOTHER CELL [DROP DOWN LIST] IN GOOGLE SHEETS ?
Read More
HOW TO INSERT DEGREE SYMBOL [ ° ] IN GOOGLE SHEETS [ °C ]?
Read More
HOW TO TYPE OR INSERT EURO SYMBOL [€] IN GOOGLE SHEETS ?
Read More
HOW TO SPLIT CELL IN GOOGLE SHEETS
Read More
HOW TO USE SPLIT FUNCTION IN GOOGLE SHEETS
Read More
HOW TO CONVERT TEXT TO COLUMN IN GOOGLE SHEETS ?
Read More
HOW TO LOCK OR UNLOCK CELLS IN GOOGLE SHEETS ?
Read More
CREATE ORG CHART IN GOOGLE SHEETS
Read More
HOW TO CREATE COMBO CHART IN GOOGLE SHEETS ?
Read More
HOW TO CREATE 3D PIE CHART IN GOOGLE SHEETS
Read More
CREATE PIE CHART IN GOOGLE SHEETS
Read More
HOW TO CREATE A PIVOT CHARTS IN GOOGLE SHEETS?
Read More
HOW TO SUBTRACT IN GOOGLE SHEETS
Read More
HOW TO FORMAT CELLS TO SHOW EURO SYMBOL WITH NUMBERS
Read More
HOW TO INSERT CHECK MARK OR TICK MARK 🗸🗸 SYMBOL IN GOOGLE SHEETS
Read More
HOW TO ZOOM OUT ON GOOGLE SHEETS?
Read More
HOW TO SUPERSCRIPT TEXT IN GOOGLE SHEETS?
Read More
HOW TO SUBSCRIPT TEXT IN GOOGLE SHEETS
Read More
HOW TO ADD A HEADER AND FOOTER IN GOOGLE SHEETS ?
Read More
HOW TO USE DATE FUNCTION IN GOOGLE SHEETS
Read More
HOW TO USE TEXT FUNCTION IN GOOGLE SHEETS
Read More
HOW TO COPY OR DUPLICATE CONDITIONAL FORMATTING IN GOOGLE SHEETS?
Read More
HOW TO USE CONDITIONAL FORMATTING IN GOOGLE SHEETS?
Read More
HOW TO USE VLOOKUP FUNCTION IN GOOGLE SHEETS
Read More
HOW TO SEND EMAIL FROM GOOGLE SHEETS
Read More
HOW TO FIND AND HIGHLIGHT THE DUPLICATES IN GOOGLE SHEETS
Read More
HOW TO CREATE A TABLE IN GOOGLE SHEETS?
Read More
HOW TO MAKE CHART IN GOOGLE SHEETS?
Read More
CREATE LINE GRAPH IN GOOGLE SHEETS
Read More
HOW TO USE MATCH FUNCTION IN GOOGLE SHEETS?
Read More
HOW TO USE WRAP TEXT IN GOOGLE SHEETS?
Read More
HOW TO INSERT A CALCULATED FIELD IN GOOGLE SHEETS
Read More
HOW TO CHANGE COLUMN NAMES OF PIVOT TABLES IN GOOGLE SHEETS
Read More
HOW TO CREATE A PIVOT TABLE IN GOOGLE SHEETS?
Read More
HOW TO EMAIL GOOGLE SHEET
Read More
HOW TO DOWNLOAD GOOGLE SHEET IN PC AS PDF FILE
Read More
HOW TO DOWNLOAD GOOGLE SHEET IN PC AS MICROSOFT EXCEL FORMAT
Read More
HOW TO REVERSE SORT OR UNSORT DATA IN GOOGLE SHEETS
Read More
HOW TO SORT DATA BY COLOR IN GOOGLE SHEETS
Read More
HOW TO SORT DATA IN GOOGLE SHEETS
Read More
HOW TO USE MERGE CELLS IN GOOGLE SHEETS?
Read More
GOOGLE SHEETS FUNCTION-CONCATENATE
Read More
GOOGLE SHEETS – SUMIF FUNCTION
Read More
HOW TO FREEZE ROWS IN GOOGLE SHEETS
Read More
GOOGLE SHEETS FUNCTION-COUNTIF
Read More
HOW TO USE FORMAT PAINTER IN GOOGLE SHEETS
Read More