Recent Posts
This guide will walk you through step by step how to hide columns in Google Sheets and you can apply what you learn to hide rows too....
Google Sheets add days to date is very easy to use, read this tutorial to also learn a trick to add days to the current date. This also work in excel....
REGEXEXTRACT is part of the suite of Google Sheets REGEX functions. Learn how to use regexextract Google Sheets function effectively today.
...
Learn how to use Google Sheets Goal Seek to conduct a what-if analysis. My guide includes practical examples and screenshots....
The REGEXREPLACE Google Sheets functions lets you change parts of strings in spreadsheets. So, it's a breeze to make sweeping edits and fix broken formulas....
A running total is a useful aggregation tool that helps you see the cumulative sum of a sequence of numbers at any point in the sequence. It is widely used in a number of applications in both academic...
In this tutorial, we will show you how to create a candlestick chart in Google Sheets, as well as how to customize and interpret the displayed results....
The Google Sheets index function can be a lifesaver when you have to search massive spreadsheets. Learn everything you need to know in the easy to follow guide....
Wildcards are a very versatile set of symbols that help you select a group of similar strings at a time. In this tutorial, I will cover what are wildcards in Google Sheets and how to apply them. We wi...
Combining text with formula in spreadsheets is known as concatenation. Read this Google Sheets Add Text to Formula Guide to learn how it works....
Learn how to convert PDF to Google Sheets using other GSuite programs or third party apps with this easy to follow guide....
My tutorial shows how to convert text to date in Google Sheets. I include step-by-step instructions with screenshots and function explanations....
