Category: Google Sheets Tips & Tutorials

REGEXEXTRACT is part of the suite of REGEX functions that Google Sheets provides. The function is extremely handy when you

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