Sheetgo Blog

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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....