How to import only specific columns into Google Sheets?

Imagine the following scenario. You are having two Google Sheets and you want to import cell data from the one into the other. However, you don’t need data from all the columns of the first sheet inside the second. How … Read More

How to use the SORT formula in Google Sheets

The SORT formula in Google Sheets, helps us sort and return the rows in a range either in ascending or descending order. It also allows us to add multiple criteria across columns, similar to that of ‘Sort Range’ functionality within Google Sheets. … Read More

How to use the SPARKLINE formula in Google Sheets

In Google Sheets, if you need to visually analyze data, but not by building bulky charts every time, SPARKLINE formula is the one to go with. It helps us come up with mini-sized in-cell charts, that quickly helps us visualize the trends. … Read More

How to use the IMPORTDATA formula in Google Sheets

The IMPORTDATA formula in Google Sheets is quite a handy tool. It helps us fetch data, that is stored in .csv (comma separated values) or .tsv (tab separated values) files, from a location on the web. Syntax IMPORTDATA(url) url – this is … Read More

How to use the UNIQUE formula in Google Sheets

In Google Sheets, the UNIQUE formula gives us unique rows from a range, while discarding the duplicates in the process. To understand this better, suppose that we have the following list of names. You’ll notice we have two sets of … Read More

Google Sheets Cashflow Management Template

In this Google Sheets cashflow management template is designed to be the main tool that you will use to manage the day-to-day finances of you business. It includes both an accounts payable and accounts receivable template which are combined to … Read More

How to embed Google Sheets in Google Sites

Google Sites is a tool that allows you to follow the metrics of your business. At Google Site you monitor the data from your Google sources: Google drive, Google Sheets, Google Slides, docs forms, etc. It stands to reason that if your business … Read More

How to solve the #REF! Error on spreadsheets

How to solve the #REF! Error on spreadsheets Can there be anything more annoying than getting #REF! error in the cells of your spreadsheet? The biggest problem Excel users face when trying to share files for reporting purposes is the … Read More

How to mitigate the risks of Spreadsheet Budgeting

  Spreadsheet Budgeting It is probably fair to say that 90% or more budgets are put together via a mish-mash of spreadsheets fired across the entire organisation. This is commonly know as Spreadsheet Budgeting. Spreadsheet budgeting is where people in … Read More

How to use the MATCH formula in Google Sheets

In Google Sheets, the MATCH formula gives us the relative position of an item in a range of cells. To understand this, please see the snapshot below. The position of ‘Evan‘ is 5 within the range of cells A1 through … Read More