What's the Percentile Function in Google Sheets?
Let's talk about how to use the PERCENTILE function. My guide covers how to use it in Google Sheets. I also discuss PERCENTILE.INC for Excel.| Spreadsheet Point
Let's talk about how to use the PERCENTILE function. My guide covers how to use it in Google Sheets. I also discuss PERCENTILE.INC for Excel.| Spreadsheet Point
Let’s take a look at the Google Sheets FREQUENCY function, how it works, when you’d use it, and when you might want to use something else.| Spreadsheet Point
Here's a simple guide on how to find quartiles in Google Sheets. You can use the quartile function, so Google Sheets does all the work for you.| Spreadsheet Point
Learn how to use Google Sheets find and replace to make bulk changes in your spreadsheets easily. We'll also cover some handy alternatives.| Spreadsheet Point
In most cases, data is arranged vertically (i.e., you read it from top to bottom) and there is an in-built functionality in Google Sheets to sort data that is| Spreadsheet Point
Here's how to, in Google Sheets, reverse order. That flips your data so you can see the bottom results on top. My method only takes a second.| Spreadsheet Point
In this article, we have shown you Google Sheet uppercase, how to turn Google Sheets all caps into lowercase, and how to convert to mixed cases. These are the| Spreadsheet Point
Learn how to separate names in Google Sheets with this simple video guide and the step-by-step written article.| Spreadsheet Point
Hide values in Google Sheets with this quick guide. The whole process takes less than a minute, and there are two ways to do remove zero values.| Spreadsheet Point
The Google Sheets repeat formula doesn’t see a lot of use. But it can be incredibly useful once you learn how to use it with this guide.| Spreadsheet Point
Learn to use the Google Sheets QUERY function. This guide walks you through simple and complex QUERY examples with screenshots and a free template.| Spreadsheet Point
This Google Sheets Delete Empty Rows guide will show you 4 ways to delete rows using CTRL clicking, a Filter, sorting your data, and using an add-on.| Spreadsheet Point
Learn an easy formula to get the word count in Google Sheets. The guide also covers how to count specific words in a text (with screenshots).| Spreadsheet Point
Sometimes, you may want to remove the first character from the string and get the rest of the string in Google Sheets.| Spreadsheet Point
There are some times I wish Google Sheets had some more functionalities like MS Excel.| Spreadsheet Point
A box plot is a visual tool used to summarize data. In this tutorial you will see how to make a Box and Whisker plot in Google Sheets.| Spreadsheet Point
This array formula Google Sheets guide includes easy-to-follow instructions and screenshots. It also shows the ARRAYFORMULA function's syntax.| Spreadsheet Point
This article explains all the possible methods to do running total in Google Sheets, with step-by-step instructions and lots of examples.| Spreadsheet Point
