Google Sheets Tutorials

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 …

If you want to know the future value of an investment that you make regular payments on that has a fixed interest rate, this kind of calculation can be done …

If you are used to working in Microsoft Excel, you may be familiar with the XLOOKUP function. When working in Google Sheets you may be wondering the best way to …

If you want to calculate the final value of an investment with compound interest after a period of time, Google Sheets makes this a very easy calculation to make. There …

If you want to change Google Sheets to a darker theme with a black background, you can set it to dark mode. Dark mode themes (also called night mode) have …

When working in Google Sheets there may be times when you want to find the median value of cells that meet certain criteria. This can be done by combining the …

If you want to make a Pareto chart in Google Sheets—that is a pretty simple thing to do. With a little know-how, this can be easily done. In order to …

Confidence interval is a useful metric used in statistics that will tell you how well your sample represents the population. If you’re wondering how to calculate confidence the interval in …

Google Sheets has many useful functions for making statistical calculations. One such function is the Z.TEST function, which will return a one-tailed P-value of a Z-test. In this tutorial, I …