Sheetgo Blog

Your go-to resource for all things spreadsheet related

How to use the STDEV formula in Google Sheets

We carry out most of our data analysis tasks on spreadsheets applications. And we will need to arrive at some key statistical metrics to understand the nature of the dataset. Standard deviation is one such metric that helps us quantify the amount of variation or...

read more

How to use the VAR formula in Google Sheets

Data is what the spreadsheets are built for - and helping us analyze it is its primary goal. There are some key metrics one needs to use while statistically analyzing the datasets. And variance is an important one of them. It measures how far a set of numbers are...

read more

How to use the PERCENTILE formula in Google Sheets

Spreadsheets are where most of us do our data analysis on. For that reason, we have many formulas and tools to aid us in that direction. And the PERCENTILE formula in Google Sheets is one such formula. It gives us the value below which the specified percentage...

read more

How to use the MAX formula in Google Sheets

Various spreadsheets programs that we have been using have one main goal. To help us understand the underlying data. More specifically with numbers. We often find ourselves in situations where we need to identify the maximum value from a set of numeric values. Is...

read more

How to use the MIN formula in Google Sheets

We can all agree on one thing about spreadsheets - they help us find meaning with underlying data. More specifically with numbers. There can be multiple business scenarios where we need to identify the minimum value from a set of numeric values. Is there any quickfire...

read more

How to use the TIMEVALUE formula in Google Sheets

While dealing with data in spreadsheets, getting to see the dates and times in string format is commonplace. While they convey the time, we can't use them directly for any kind of calculations or data processing. Unless we have a way to convert them into the time...

read more

How to use the YEAR formula in Google Sheets

More often than not we usually come across the complete dates like "6/13/2018 16:07:34". And having the dates in discrete stand-alone values of years or months or dates is less likely. But there can be business scenarios where we need to extract the years, probably to...

read more

How to use the TIME formula in Google Sheets

The TIME formula in Google Sheets accepts a given time through the hour, minute, and second component values, and returns a time type value. Syntax TIME(hour, minute, second) The hour, minute and second are self-explanatory parameters that accept corresponding...

read more

How to use the NOW formula in Google Sheets

In our day to day lives, we will be needing to do certain activities that may be time-sensitive. There can be business scenarios where we need to check the current time and date before proceeding further. Thankfully, we have the NOW formula in Google Sheets that can...

read more

How to use the HOUR formula in Google Sheets

At times we may need to pick the hour from a time value. Possibly to use it with another formula that calculates an overtime paycheck. Manually, we can quickly identify the hour of the day by looking at the time. However, the machine cannot directly deduce it without...

read more

How to use the DAY formula in Google Sheets

There can be situations where we'd like to extract the day of the month from a given date. Probably to use it with another formula that decides if it falls in the first half or second half of the month. On a quick look, we can quickly identify the day of the month....

read more

How to create an Invoice Generator

Services used Google Sheets Google Docs Google Apps Script Department  Financial Time to setup 10 minutes Introduction At Sheetgo we have a database of paid clients in Google Sheets and we need to send them invoicing. Pretty soon after launching we realized this would...

read more