Google Sheets Tutorials

When working in Google Sheets, there may be times when you want to keep leading zeros in a number. It can be frustrating to find that Google Sheets will automatically …

Using VLOOKUP in Google Sheets is a great way to speed up your productivity when you need to pull data from another range or sheet. Many VLOOKUP users often wonder …

Everyone has different reasons for wanting to learn spreadsheet programs like Google Sheets.  Some people use it for work reasons, other people may find it useful for keeping track of …

Learning to use the various date functions available in Google Sheets certainly takes time, but they can absolutely speed up your productivity when you need to accomplish certain things. One …

If you need to multiply matrices, the MMULT function is an easy way to do matrix multiplication. In this tutorial, I will show you how to use the MMULT function …

When working with time values in Google Sheets, there may be times when you want to convert time to decimals. Working with decimals is often required when you need to …

The IMPORTXML function is a powerful function that allows you to import data from structured data types like XML, HTML, CSV, TSV, RSS, and ATOM XML. If you want to …

Sometimes when working with data in a spreadsheet, you may want to keep a running total that will show how the data changes every time a new number is added …

Treemap charts are useful for providing a hierarchical view of data that allows you to easily identify patterns. When working in Google Sheets, treemap charts are definitely a less often …

The SWITCH function in Google Sheets is an easy way to create a switch statement in your spreadsheet. This function works similar to nesting multiple IF statements together, however, with …