How to Use the Google Sheets JOIN Function (with Video)
Learn everything you need to know about using the Google Sheets JOIN Function and other similar functions with this straightforward video guide.| Spreadsheet Point
Learn everything you need to know about using the Google Sheets JOIN Function and other similar functions with this straightforward video guide.| Spreadsheet Point
To calculate age in Google Sheets, use the DATEDIF or YEARFRAC formulas. Follow along for screenshots and full formula explanations.| Spreadsheet Point
Follow this Google Sheets sort by multiple columns guide to learn the two simplest ways to sort your data over several columns.| Spreadsheet Point
Learn how to unmerge cells in Google Sheets in under 5 minutes with this simple guide. We cover shortcuts and menu options.| Spreadsheet Point
Can Google Sheets add a new line in a cell? You can easily do it with a keyboard shortcut or the CHAR function. Find out how they work here.| Spreadsheet Point
Learn to use the concatenate Google Sheets function. My guide also covers why concatenate is preferred to CONCAT in Google Sheets.| Spreadsheet Point
Merging cells is a neccessary skill for any spreadsheet user. Follow this guide for a few methods of how to merge cells in Google Sheets| 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
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
This guide will show you step-by-step with screenshots of how the consolidate feature works in Microsoft Excel.| 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
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
