Google Sheets: Definitive Guide

Tutorials

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.

How to use the NORMSINV function in Google Sheets

How To Use The Normsinv Function In Google Sheets

Reading Time: 4 minutes Use the NORMSINV function in Google Sheets to find the inverse normal distribution of a given probability value right in your sheet. In this straightforward guide, you will see how the function makes this happen.

How to use the QURY function in Google Sheets

How to use the QUERY function in Google Sheets.

Reading Time: 6 minutes Learn how to use the powerful QUERY function in Google Sheets to perform SQL-like operations. This tutorial will take you from the basics to advanced levels through carefully explained step-by-step examples.

How to create an organizational chart in Google Sheets

How To Create An Organizational Chart In Google Sheets

Reading Time: 4 minutes Create beautiful organizational charts in Google Sheets. Learn how to create organizational charts in Google Sheets and find out interesting ways to customize them through this simple-to-follow tutorial.

Loading…

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