Sheetgo Blog
Your go-to resource for all things spreadsheet related
How to use the INDIRECT function in Google Sheets
The INDIRECT function in Google Sheets takes in the cell address in the form of text and returns a cell reference. It...
How to use the Google Sheets SORT function
The Google Sheets SORT function allows you to sort data and return the rows in a range either in ascending or...
How to use Google Sheets ARRAYFORMULA
Google Sheets ARRAYFORMULA is one of the key advanced functions you should have up your sleeve if you spend a lot of...
How to use the Google Sheets LOOKUP function
The Google Sheets LOOKUP function searches through a row or column for a key and returns the value of the cell in a...
Sales lead tracker template in Google Sheets
If you’re a busy sales manager running a team of sales development reps and account managers, you need to be able to...
Sales report template in Google Sheets
Sales is a dynamic, high pressure, and fast-paced line of work. This means that when you're busy chasing leads all...
Marketing KPI template in Google Sheets
Marketing is a creative field but it’s steadily becoming more data-driven. This means that savvy marketing departments...
Income statement template in Google Sheets
For small to medium-sized enterprises (SMEs), creating an income statement can be a time-consuming and costly process....
Budget vs Actual spreadsheet template in Google Sheets
Budget vs Actual analysis is a bit like a financial reality check for your business. Essentially, it involves...
Business unit plan template in Google Sheets
All companies encompass several business units (or departments) such as accounting, sales, marketing, R&D, and...
Expense tracker template in Google Sheets
Keeping on top of your team's spending is a key part of budgeting and business management. Rather than waiting to...
How to use the GOOGLEFINANCE function in Google Sheets
The GOOGLEFINANCE function allows you to import real-time financial and currency market data straight into Google...