The XLOOKUP Google Sheets function is the best search function for many purposes. Learn how to use it here.| Spreadsheet Point
This step-by-step tutorial quickly shows you how to easily use the HLOOKUP Google Sheets function, using several examples for you to follow along.| Spreadsheet Point
This tutorial covers how to lock cells in Google Sheets with several step-by-step examples including options for mobile devices.| Spreadsheet Point
Learn how to use the VLOOKUP Google Sheets function with examples and details on everything you need to know, including syntax and usage.| Spreadsheet Point
The Googlre Sheets LOOKUP function can be used to find specific information within a set of data. Learn how to use it here.| Spreadsheet Point
In this article, we go over all the common formula parse errors in Google Sheets — and how to fix them, with easy step-by-step screenshot tutorials.| Spreadsheet Point
If you work with monetary data in Google Sheets, such as sales or income/expense or stock prices, having a currency symbol ($/€ or USD/EUR) may make sense.| Spreadsheet Point
Let's talk about how to use VLOOKUP with multiple criteria. After all, I often use this formula to find data based on more than one thing. Fortunately,| Spreadsheet Point
Use the IMPORTRANGE Google Sheets function to access data between spreadsheets. Follow along for video guidance and advice on the formula.| 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
Follow along with this IFS Google Sheets tutorial to master the basics in a few minutes, and take a longer look at some of the more advanced use cases.| Spreadsheet Point
Using the VLOOKUP Excel function can save you a ton of time when searching your spreadsheets. Learn how to use it here.| Spreadsheet Point
Learning which Google Sheets Wildcard to use and when can seem daunting, but this guide makes it simple.| Spreadsheet Point
In this tutorial, we explain the syntax of the IFERROR Google Sheets function, what it does, and how it can be applied in different use-cases.| Spreadsheet Point
Learn how to apply a formula to an entire column in Google Sheets to build large spreadsheets quicker than ever. Our simple examples to make it a breeze.| Spreadsheet Point
Excel has been around since the '80s and is a powerful. But, is it still better than the new kid on the block? Find out as we compare Gogle Sheets vs Excel.| Spreadsheet Point