A streamlined Google Sheets function guide that can make you a pro in Google Sheets’ Application use. Pick one function from the list, learn it and dig deep into more awesome tutorials related to the same function.

Google Sheets Function Guide

ARRAY

Popular Google Sheets Array Functions. More features related to these functions like complicated criteria use, you can find with in these tutorials.

SUMPRODUCT
TRANSPOSE
ARRAY_CONSTRAIN

DATABASE

The Best Google Sheets Database Functions Guide. Find more details and additional links within this tutorial.

DSUM
DPRODUCT

DATE

The Ultimate Google Sheets All Time and Date related functions.

TIME – A complete time related function guide which includes the following TIME functions.

TIME
NOW
HOUR
MINUTE
SECOND
TIME VALUE
TO_PURE_NUMBER

DATE – All the below Date functions covered in a single guide.

TODAY
DAY
NOW
MONTH
YEAR
DATE
DATEVALUE
DAYS
EDATE
ISOWEEKNUM
NETWORKDAYS
NETWORKDAYS.INTL
WORKDAY
WORKDAY.INTL
YEARFRAC
DATEDIF
WEEKDAY
WEEKNUM
EOMONTH

FILTER

The below guides deal with filter functions not filter command.

FILTER
UNIQUE

GOOGLE

Google Sheets Own Popular Functions. Never miss these functions as they are unique, so powerful and dynamic.

ARRAYFORMULA
IMPORTRANGE
QUERY
SPARKLINE

LOGICAL

Google Sheets IF Logical Functions Guide. These are the functions, that give life to your spreadsheets. Never ever miss these Logical Functions.

IFERROR
IF
IFS
AND & OR
SWITCH

LOOKUP

Vlookup is so popular. But don’t limit to this. There are more powerful lookup functions. Find below Google Sheets Complete Lookup Functions Guide.

INDEX
MATCH
OFFSET
INDIRECT
VLOOKUP & HLOOKUP
ROW

MATH

Google Sheets Important Math Functions Guide

RAND & RANDBETWEEN
COUNT – All count functions at one place.

COUNT
COUNTA
COUNTUNIQUE
COUNTBLANK
COUNTIF
COUNTIFS
DCOUNT
DCOUNTA

SUBTOTAL
SUMIFS
SUMIF
TRUNC & INT
ROUND РThis Guide covers the below Round functions.

ROUND
ROUNDUP
ROUNDDOWN

STATISTICAL

Google Sheets Popular Statistical Functions Guide

RANK
MODE
SMALL

TEXT

Google Sheets Text Function Guide

SPLIT
REGEXEXTRACT
REGEXMATCH
MID
TRIM
CONCATENATE
JOIN, TEXT JOIN
LEN
UPPER, LOWER & PROPER
MID, SEARCH
CHAR
FIND
SUBSTITUTE
LEFT, RIGHT

LEAVE A REPLY

Please enter your comment!
Please enter your name here