Learning to use pivot tables is a game changer for data analysis. This pivot table Google Sheets guide will show you step-by-step how to make them.| Spreadsheet Point
To search in Google Sheets, use the Find and Replace feature, the search shortcut, or conditional functions. Read this guide for instructions.| Spreadsheet Point
If you work with numbers in Google Sheets, there is one thing that can often frustrate many users.| Spreadsheet Point
Learn the main Google Sheets count unique values methods with a step-by-step guide where I will use each method to extract different values from a sample table.| Spreadsheet Point
There are plenty of reasons to sort your data in a spreadsheet. The SORTN Google Sheets function allows you to easily do this. Learn how to use it here.| Spreadsheet Point
This guide will show you how to remove duplicates in Excel using a few different methods, none of which are difficult or time consuming.| Spreadsheet Point
Automate tasks with macros in Google Sheets. That's a major timesaver. This guide shows how to make macros in Google Sheets.| 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
To split text in Google Sheets, use the Data > Split Text into Columns menu. Otherwise, use the SPLIT formula. This guide discusses both methods.| Spreadsheet Point
The Google Sheets FILTER function, as the name suggests, will allow you to filter a dataset based on a condition (or multiple conditions). Learn how here!| Spreadsheet Point
To highlight duplicates in Google Sheets, use conditional formatting and the UNIQUE function. This guide includes step-by-step instructions.| 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
Learn the different ways in which the Google Sheets UNIQUE values function can be used to extract unique values or entries from a given range of cells.| Spreadsheet Point
A big part of data analytics involves data cleaning. Well cleaned data is one that is free from incomplete, irrelevant, and redundant records.| 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
To compare two columns in Google Sheets, use a function like COUNTIF or VLOOKUP. Here's how to use spreadsheet functions for comparison.| 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
This video guide will show you how to remove hyperlinks in Google Sheets. We also provide a text guide for those that don't want to watch a video.| Spreadsheet Point
Learn these handy Google Sheets shortcuts to make working in Sheets way faster and easier. You'll be the fastest Sheets user ever with these.| Spreadsheet Point
To count cells with text in Google Sheets, use one of these three functions. My guide includes a video guide (including searching for partial text).| Spreadsheet Point