BigQuery is known as one of the best data storage solutions on the market. This is perfect for businesses that need to...
Spreadsheets articles
How to create a dashboard in Google Sheets
Get actionable insights with a data dashboard Think of the last time you needed to check a KPI or another important...
How to use the Google Sheets QUERY function
The Google Sheets QUERY function is a very powerful and versatile tool. So much so that you can call it a...
Formula parse error in Google Sheets: what it means and how to fix it
If you use spreadsheet formulas frequently, you are no stranger to formula parse errors. These errors occur when a...
How to use Named Functions in Google Sheets
If you haven't used Named Functions in Google Sheets, you should give it a try. It's a very useful feature for users...
Import JSON to Google Sheets
What is JSON? JSON stands for "JavaScript Object Notation". It is a way to represent data in a simple, easy-to-read...
How to add a drop down list in Google Sheets
A drop down list in Google Sheets lets people pick a value from a set of options instead of typing it. Entries stay...
15 awesome Chat GPT prompts for spreadsheet users
This is a collection of awesome Chat GPT prompts to power-up your spreadsheet game. We will look at general prompts...
How to use the LOG formula in Google Sheets
Needing to calculate the logarithm of your data inside spreadsheets? No need for a calculator; Google Sheets has its...








