Google Sheets Function Guide [Quickly Learn Popular Functions]

13

A concise guide to Google Sheets functions that can elevate your proficiency in using the application. Choose a function from the list, master it, and explore additional tutorials that delve deeper into the same function.

ARRAY Functions

List of popular Google Sheets ARRAY Functions. Additional features related to these functions, such as complex criteria usage, can be found in these tutorials.

These groups of functions are specifically designed to work with arrays of data.

DATABASE Functions

Database functions are a group specifically designed to work with data structured like a database, even within a spreadsheet. Here is the function guide for the most popular database functions in Google Sheets.

DATE and TIME Functions

TIME: A comprehensive guide to time-related functions, including the following TIME functions:

  • TIME
  • NOW
  • HOUR
  • MINUTE
  • SECOND
  • TIME VALUE

DATE: All the following date functions are 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

New!

ENGINEERING Functions

Function guides for selected engineering category functions that come in regular use in Google Sheets.

FILTER Functions

The filter category functions help you focus on the most relevant information and extract insights from large datasets. Here are the function guides for the most popular filter functions in Google Sheets.

FINANCIAL Functions

There is a wide range of functions under the financial category in Google Sheets, specifically designed for financial calculations and analysis. Here are the function guides for the most popular financial functions in Google Sheets.

GOOGLE Functions

Google Sheets has some unique functions that you may not find in its competitors. Here are some of those functions.

INFO Functions

The info category functions help you gather information about different aspects of your spreadsheet, including cell content, cell references, and system settings. They equip you to troubleshoot errors and understand the structure of your sheet.

LOGICAL Functions

Logical functions help you make decisions within your formulas by evaluating various conditions. These functions are essential for dynamic calculations. The logical functions category is enriched with new Lambda and Helper functions.

Here, you can find tutorials for most of the logical category functions.

LOOKUP Functions

Lookup functions in Google Sheets help you find specific data by matching keys, extracting values, finding row or column numbers, and more. Here are guides for using these functions.

MATH Functions

Math functions assist in performing various mathematical calculations, essential for numerical operations and data analysis within Google Sheets.

  • ROUND – This Guide covers the below Round functions.
    • ROUND
    • ROUNDUP
    • ROUNDDOWN

OPERATOR Functions

Most operator functions serve as substitute functions for comparison operators used within formulas to perform comparisons.

Below, you can find function guides for the most popular operator functions.

PARSER Functions

Parser functions are a list of functions that assist in converting values to a specific format or unit.

STATISTICAL Functions

Statistical functions need no introduction. They are designed to perform statistical calculations and analyses on your data. Here, you can find the function guide for all popular statistical functions in Google Sheets.

RANK:

MODE:

MEDIAN:

SMALL/MAX (Also with conditions):

QUANTILE Functions:

AVERAGE Functions:

FORECASTING Functions:

VARIANCE Functions:

PERCENTIF

TEXT Functions in Sheets

The functions that help you work with text data.

WEB Functions

Here are function guides for a collection of functions that interact with web data.

Prashanth KV
Introducing Prashanth KV: Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

13 COMMENTS

    • Follow this.:

      1. Go to the Google Sheet from which you want to remove access.
      2. Click “Share” in the top right corner and remove access.

      Ask its owner if you want to remove it from any website or forum query. We usually don’t publish user-posted links.

  1. Hi Prashanth,

    I needed help with something challenging. It’s regarding creating a master template sheet, kind of like a slide master.

    Instead of posting the whole thing here, I’ll link the query I posted on Google Support.

    — like removed by admin —

    With gratitude,
    Sharat

  2. I was fascinated by the amount of great information and content on this page.
    Thank you very much for sharing your knowledge, you are the best of the best.

  3. Count Rows between Two Rows if rows have the same values?

    Row 1 = “Q1” and row 5 is also “Q1”.

    I can’t figure out which function to use? Can you give me some advice?

    Thanks for a great site! I spend hours here almost every day! I think the hardest part with Google Sheets is not the syntax used in functions, it is to find out which function to use for every different situation.

    Best regards

    Jari
    Stockholm, Sweden

    • Jari R.,

      You may want to use Query. Can you prepare an example file (Sheet) and share it in your reply?

      I am not writing the formula for you right now, because I am not clear whether the rows between the two values are blank or not. If blank, then we can use a combo formula (not the Query function), that I’ll write as a separate tutorial.

      Note:- The link to the file won’t be published (privacy reasons).

  4. Very nice job. I was looking for a site where I will get all the required info on google sheet, this site is what I was looking for. Thank very much.

LEAVE A REPLY

Please enter your comment!
Please enter your name here