Jonatan Silva

Build a Google Sheets amortization schedule with the PMT, PPMT, and IPMT functions, then add extra payments to see how fast you can pay off the loan.

If you have various Excel files but would like to access the data in one centralized worksheet, this guide is for you. Here’s how to consolidate data in Excel.

Linear regression allows us to find a trend in our data, which is useful for forecasts and more. Here’s how to perform a linear regression in Google Sheets.

Hiding tabs makes a shared Google Sheets file easier to navigate. Here’s how to hide tabs, and how to unhide sheet in Google Sheets from two different menus.

Discover what revenue forecasting is, why it matters for every business, and the top forecasting methods to use, with an example of each one.

Google Sheets is a fantastic tool for working in teams. Here’s everything you need to know about sharing permissions and how to share Google Sheets.

Use the compound interest formula in Google Sheets to see how savings grow with annual, monthly, or daily compounding, then add monthly contributions.

Learn how to do what if analysis in Google Sheets with the free Goal Seek add-on, and how what-if analysis differs from sensitivity analysis.

Learn how to find the slope in Google Sheets two ways: from the trendline equation of a scatter chart, or with the SLOPE function and no chart at all.

Learn how to install the Goal Seek add-on and use Google Sheets goal seek for break-even and what-if analysis, and how to fix common errors.