Sheetgo Blog

Your go-to resource for all things spreadsheet related

How to use the COLUMNS formula in Google Sheets

Let us say we have a range of cells in a spreadsheet, and we want to know how many columns it has spread across. If there are only a few of them, we could probably do a quick observation and manually count the number. But there can be instances where columns in a...

read more

How to use the FLOOR formula in Google Sheets

While there are infinite rational numbers in mathematics, we don't usually deal with all of them. That's because, in real life, it isn't even feasible. Consider currency for instance. We may make many money transaction calculations - interest, exchange rates, etc. For...

read more

How to use the LOG formula in Google Sheets

In this post, we learned the behavior of natural logarithm and the usage of LN formula. While we can agree that the logarithm evaluated upon base e is quite useful in many fields, it isn't as flexible. For instance, we can not evaluate the logarithm for a base that is...

read more

Best Tools to Help You Manage Your School Administration

Today there are tons of tools on the market to support school administration. It can be challenging to sift through all of the different types of software available. There is a lot to consider when figuring out what you need and what you can trust to help manage all...

read more

G Suite for Education: A Quick Review

What is G Suite for Education? Stories are popping up from all over the globe about how schools are using G Suite for Education to transform education through technology. Google has reported that more than 70 million people are actively using G Suite for Education, a...

read more

How to use the ROUND formula in Google Sheets

While working with spreadsheets, we tend to come across many numbers that are rational. Some of them have more decimal values after the decimal point than desired. And our requirement may be such that we need to confine the rational values to the desired number of...

read more

G Suite for Education: Should I Adopt it for My School?

  G Suite for Education is changing the game for school administration. In an increasingly digitized world, G Suite is providing streamlined, paperless options for schools around the world. It is a great option for small schools or large institutions. It is being...

read more

How to use the COUNTUNIQUE formula in Google Sheets

While working with spreadsheets, we are bound to do many sorts of calculations. And we will, at times need to calculate unique occurrences of a dataset. The number of unique customers that shopped at a store, for example. How do we achieve this easily? We can, with...

read more

Exploring all Features of G Suite for Education

G Suite for Education, formerly called Google Apps For Education, is a set of intelligent apps tied together to create an education powerhouse. It changes the way that educators communicate, collaborate, and teach. It is preparing students to learn in the same way...

read more

How to use the LARGE formula in Google Sheets

Number crunching is one of the primary activities that the spreadsheets applications are built for. We all know how to find out the maximum value from a dataset, using the MAX formula. What if we need to find out the second largest value from the set of numeric...

read more

How to use the COVAR formula in Google Sheets

Analyzing the data leads us to multiple interpretations as to what the underlying nature is. And we have many important statistical tools and metrics that help us with this exercise. One such important metric that mathematicians have at their disposal is the...

read more

How to use the CORREL formula in Google Sheets

Analyzing data entails going through various statistical measures to understand the underlying nature and trends. Probably, one of the most commonly used statistical methods is Correlation. We use it to gauge the extent of relationship, dependence or closeness of two...

read more