Sheetgo Blog
Your go-to resource for all things spreadsheet related
6 Google Sheets templates your business needs in 2021
Making sure your company grows to its biggest possible potential is a challenging task. Luckily, there are many useful...
How to merge and combine CSV files automatically
Looking for a quick way to combine data from multiple CSV files into one data set? Tired of manually merging CSV files...
How to use the XIRR function in Excel
The XIRR function in Excel calculates the internal rate of return, or IRR, of a series of cash flows. The function is...
How to append Excel data and log historical values
Many of us collect and analyze dynamic data that changes on a regular basis. If you work in spreadsheets, there are...
How to use the INDEX Excel function
The INDEX function in Excel returns the value of a specified cell within an array. You essentially tell the function...
Top 10 Google Sheets add-ons for improving workflows
Want to learn how to level-up your Google Sheets workflow? Maybe your team is transitioning from Microsoft Office to G...
How to use the Excel OFFSET function
The Excel OFFSET function returns a reference range of cells that are offset (hence the name) from a reference cell....
Top 10 Excel functions you need to know in 2021
These are the top 10 excel functions that you need to learn in 2021. With these 10 functions you can unlock the power...
How to use the IFERROR function in Excel
No matter how great you are with spreadsheets, sooner or later (most likely sooner) you’re going to run into an error....
How to use the MATCH Excel function
The MATCH Excel function tells you the position of a value within a range of cells. The function on its own can be...
How to use the IF AND function combination in Excel
The IF function in Excel is extremely useful: it generates different outcomes depending on whether the input meets a...
How to use the LOOKUP function in Excel
A common task in Excel is searching your spreadsheet for certain values, and using a function to do this and return a...