Google Sheets Tutorials

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 …

If you are trying to calculate the present value of an investment that has a constant payment schedule and a constant interest rate, the PV function will come in handy. …

If you are trying to calculate the internal rate of return on an investment that has irregularly spaced cash flows, the XIRR function is exactly what you need. This kind …

The GOOGLEFINANCE function is a powerful function that can be used to get real-time financial and market-related data. With this function, you can quickly import the current prices of various …