Google Sheets: Definitive Guide

Tutorials

How to import Wikipedia data to Google Sheets

Import Wikipedia Data To Google Sheets

Reading Time: 4 minutes Did you know that you can import wikipedia pages and page metrics to Google Sheets? Learn how to use Wikipedia API to import Wikipedia data to Google Sheets in this easy-to-follow guide.

How to use the QUERY function with IMPORTRANGE in Google Sheets

How To Use The QUERY Function With IMPORTRANGE In Google Sheets

Reading Time: 7 minutes You can quickly retrieve and sort data in an external spreadsheet in a few easy steps by combining two essential Google Sheets functions. Learn how to use the QUERY function with IMPORTRANGE in Google Sheets like a pro and other helpful tips that can make your work much easier.

How To Add A Checkbox In Google Sheets

Reading Time: 4 minutes Want to maintain a checklist in Google Sheets? Learn how to add a checkbox in Google Sheets through this easy to follow tutorial in step-by-step manner.

How to merge duplicates in Google Sheets

How To Merge Duplicates In Google Sheets

Reading Time: 5 minutes Duplicates occur everywhere especially in spreadsheets with large amounts of data. Fortunately, there are a couple of easy methods to merge duplicates in Google Sheets. Find out how.

How to import CoinGecko data to Google Sheets

Import CoinGecko Data To Google Sheets

Reading Time: 5 minutes Track, monitor and analyse crypto prices with this cool way by importing CoinGecko data to Google Sheets. It’s an easy 3-step process. Find out here.

How to import Notion data to Google Sheets

Import Notion Data To Google Sheets

Reading Time: 4 minutes If you use Notion and want to make the most of it, integrating it with Google Sheets is the way to do it. Learn how you can import Notion data to Google Sheets.

How to use the FV function in Google Sheets

How To Use FV Function In Google Sheets

Reading Time: 5 minutes Learn how to use the FV function in Google Sheets with a few easy steps. This post will walk you through how to use the FV function for various future investment calculations.

How to import BscScan data to Google Sheets

Import BscScan Data To Google Sheets

Reading Time: 6 minutes Are you someone into blockchain looking for ways to import BscScan data to Google Sheets? Get all the information here from this step-by-step guide, and import all kinds of data to Google Sheets.

Import US patent data to Google Sheets

Import US Patent Data To Google Sheets

Reading Time: 7 minutes Import US patent data to Google Sheets–all kinds of data such as patent name, abstract, date; inventor name, country, state; and patent citations. Click to find our how it’s done–easily and simply.

How To Create a Radar Chart in Google Sheets

Reading Time: 5 minutes You don’t need to be a data analyst to know how to create a Radar chart in Google Sheets. Learn the art of data visualisation and express yourself with ease.

How To Generate Barcodes In Google Sheets

Reading Time: 4 minutes Want to switch to smarter ways of data entry? Learn how to generate barcodes in Google Sheets with this easy to follow tutorial in step-by-step manner.

How To Sort By Date In Google Sheets

Reading Time: 6 minutes Want to learn how to sort by date in Google Sheets? This tutorial is meant for you. A quick and easy-to-implement step-by-step guide that teaches you everything

How to Colour Alternate Rows in Google Sheets

How to Colour Alternate Rows in Google Sheets

Reading Time: 5 minutes A simple step such as coloring alternate rows of your data differently can go a long way. Read the article and improve upon your existing data visualization skills.

How To Use Wildcards In Google Sheets

Reading Time: 6 minutes Wildcards in Google Sheets can boost your code logic and readability. This quick and easy-to-follow tutorial teaches you everything in a step-by-step manner.

XMATCH function in Google Sheets

XMATCH Function In Google Sheets: The Ultimate Guide

Reading Time: 7 minutes Learn all about the new function in Google Sheets: the XMATCH function. How to use the XMATCH function in Google Sheets, when to use it; XMATCH for partial match, reverse lookup. You’ll find it all.

Loading…

Something went wrong. Please refresh the page and/or try again.