Author

Luciano Marzoni

Latest posts

What is data consolidation?

What is data consolidation? Data consolidation is the process of combining data from multiple sources into a unified dataset. Now more...

All Google Sheets IF functions

Google Sheet IF functions allow you to include condition-based formulas in your spreadsheets.  Think of them like flow charts. These...

3 great templates for HR processes

Managing human resources efficiently is vital for any organization's success. With the right tools, HR departments can streamline...

How to SUMIF in Google Sheets

The SUMIF function in Google Sheets allows you to sum values in a range based on specific criteria. Whether you're dealing with financial...

How to use IFNA in Google Sheets to handle errors

IFNA in Google Sheets is a super simple function. It checks if a formula results in an error and returns a specific value if it does. This...

How to use COUNTIFS in Google Sheets

COUNTIFS is one of the many Google Sheets count functions. This formula works as its name suggests: it counts values within a range that...
simple finance add on featured image

Build a stock portfolio spreadsheet, track your investments

Staying on top of your investments can be a real challenge, particularly if you manage them through many brokers. In this post we will...

Setting an absolute cell reference in Google Sheets

An absolute cell reference points to a specific cell and doesn’t change if you replicate that original cell. In this article we will cover...
filter Excel

How to use VLOOKUP and IMPORTRANGE in Google Sheets

Combining the power of VLOOKUP and IMPORTRANGE is a great way to transfer specific data between two spreadsheets. Expand the horizons of...