Google Sheets Tips
How to Randomize a List in Google Sheets (Shuffle Data)
In this tutorial you will see how to randomize a list in Google Sheets using the new Randomize range feature, along with other traditional methods.
Google Sheets Tips Articles
Charting
How to Create a Loan Amortization Schedule in Google Sheets
An amortization sheet can help pay off loans with minimal loss. This tutorial demonstrates how to create your own loan amortization schedule in Google Sheets.
Formulas
How to Extract Numbers from a String in Google Sheets
This tutorial shows some useful tricks and different use-cases to demonstrate how to use Google Sheets to extract numbers from strings.
Google Sheets Tips
13 Best Google Sheets Courses, Classes, and Tutorials [2021]
We scoured the internet for the very best Google Sheets course in existence. Turns out, there’s an overwhelming amount of Google Sheets classes, tutorials, and training videos out there! To save you the time of
Charting
How to Find Slope on Google Sheets [Easy Guide]
Google Sheets is frequently used to archive, access, and organize information. But it can also be used for some impressive calculations. Understanding more about Google Sheets algorithms and calculations can give you insights into how
Formulas
How to Use the OFFSET Google Sheets Function
The OFFSET Google Sheets function is quite an under-used function. This is mainly because a lot of people don’t understand the purpose behind the function, or how it can be effectively made use of. In
Formulas
How to Compare Two Sheets in Google Sheets
Ever tried comparing the contents of two different Google Sheets to find discrepancies? If they’re small worksheets with a few rows and columns of data, it might not be that tough. With larger amounts of
Google Sheets Tips
Remove Extra Spaces in Google Sheets (Leading, Trailing, Double)
Any work with text data or numbers in Google Sheets, sooner or later you will have to deal with those pesky extra spaces that find their way in the cells. These could be leading spaces
Google Sheets Tips
How To Delete Multiple Sheets In Google Sheets (3 Ways)
Google Sheets has come a long way since it released in 2006. There are some things that still frustrate a lot of its users. one of those things is the lack of ability to delete
