Category: Google Sheets Tips & Tutorials

REGEXEXTRACT Google Sheets function is part of the suite of REGEX functions available to many users. The function is extremely

When doing data analysis, there may be times when we know what we want as the result, but don’t really

REGEXREPLACE is a handy function offered by Google Sheets that lets you quickly replace parts of strings in your sheets.

A running total is a useful aggregation tool that helps you see the cumulative sum of a sequence of numbers

Charts and Graphs are great visualization tools that give you a birds-eye view of your data and help you make

The INDEX function is perhaps one of the most under-used functions in Google Sheets. However, if you know the right

Wildcards are a very versatile set of symbols that help you select a group of similar strings at a time.

Combining text and numbers is common in spreadsheets, for example when you want to add some context There are a

We often need to work with data received in the form of a PDF file. You might have a scanned

Working with dates in Google Sheets can sometimes be quite frustrating. This is because there are so many ways in

Formulas always help make data processing easier and faster. As helpful as they are, formulas can sometimes come in the

The slicer is a really handy feature of Google Sheets. It enhances the power of Pivot Tables and Pivot Charts