NorthStar Analytics
Pricing

HiDocs High-Quality Ghost Documentation Theme

Google Sheets Functions

A function is an operation that the Google Sheets spreadsheet can apply to your data to perform automatic calculations.

How to Use REGEXMATCH Function in Google Sheets?

How to Use REGEXMATCH Function in Google Sheets?

Searching within tables is a common task when working with Google Sheets. With the REGEXMATCH function, we can easily find…

Learn more
How to Use VLOOKUP Function in Google Sheets?

How to Use VLOOKUP Function in Google Sheets?

When working with Google Sheets, we can have multiple tables, multiple sheets, or multiple workbooks. Among these, we may need…

Learn more
How to Use the UNIQUE Function in Google Sheets?

How to Use the UNIQUE Function in Google Sheets?

When working with Google Sheets, we may have written the same data in our worksheet more than once. If there…

Learn more
How to Use COUNTIFS Function in Google Sheets?

How to Use COUNTIFS Function in Google Sheets?

Searching worksheets can be done manually with little data. If you have a large table in your worksheet, if you…

Learn more
How to Use SUMIFS Function in Google Sheets?

How to Use SUMIFS Function in Google Sheets?

Mathematics is pretty easy when working with Google Sheets. Addition, subtraction, multiplication. While performing operations on these, the functions work…

Learn more
How to Use ROUND Function in Google Sheets?

How to Use ROUND Function in Google Sheets?

When working with Google Spreadsheets, our tables can have decimals. Working with them is pretty easy in Google Spreadsheets. However,…

Learn more
How to Use SPARKLINE Function in Google Sheets?

How to Use SPARKLINE Function in Google Sheets?

When working with Google Sheets, we sometimes show our table with the help of graphs for ease of reading. Graphs…

Learn more
How to Use IMPORTXML Function in Google Sheets?

How to Use IMPORTXML Function in Google Sheets?

With Google Spreadsheets, we can easily retrieve data from the pages we browse on the internet. We can take data…

Learn more
How to Use IMPORTRANGE Function in Google Sheets?

How to Use IMPORTRANGE Function in Google Sheets?

When working with Google Sheets, we can have multiple tables, multiple sheets. We may need to use the same data…

Learn more
How to Use IMAGE Function in Google Sheets?

How to Use IMAGE Function in Google Sheets?

When working with Google Sheets, we can easily add images to our sheet. We can fit it inside the cell…

Learn more
How to Use GOOGLEFINANCE Function in Google Sheets?

How to Use GOOGLEFINANCE Function in Google Sheets?

With the GOOGLEFINANCE function, we can easily transfer our data from the Google finance web application to our worksheet. We…

Learn more
How to Use IMPORTHTML Function in Google Sheets?

How to Use IMPORTHTML Function in Google Sheets?

When working with Google Sheets, we may want to import tables or lists from the pages we browse the internet…

Learn more
How to Use DATE Function in Google Sheets?

How to Use DATE Function in Google Sheets?

We can combine the dates written separately as the month, year, day in Google Spreadsheets, rotate the instant date, and…

Learn more
How to Use COUNTIF Function in Google Sheets?

How to Use COUNTIF Function in Google Sheets?

When working with Google Sheets, we may sometimes need to search within the table. We may need repetitive data. For…

Learn more
How to Use COUNTA Function in Google Sheets?

How to Use COUNTA Function in Google Sheets?

We may be working with very large worksheets in Google Sheets. There may be missing data in our table. Or…

Learn more
How to Use COUNT Function in Google Sheets?

How to Use COUNT Function in Google Sheets?

When working with Google Sheets, we may wonder how many cells with numerical data we have. Let's get the products…

Learn more
How to Use AVERAGE Function in Google Sheets?

How to Use AVERAGE Function in Google Sheets?

One of the functions that we use frequently in daily life is averaging. Especially if we are dealing with sales…

Learn more
Make your business data transparent!
  • Subscribe to a package

    Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

  • Request unlimited dashboards

    You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

  • Your Data Studio Department

    Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.