Google Sheets | Cooltables

Dynamic Table of Contents for Google Sheets: Easy Search, Color Filter, & Real-Time Updates

Google Sheets In-Cell Donut Charts: Easy Auto-Updating Chart Formula Tutorial

Live Animated Summer Olympics Gold Medal Stats in Google Sheets

Google Sheets Formula to Automate Hundreds of Outlined & Filled Bar Charts

How to transfer Google Sheet to BigQuery (in 4 clicks)

How to load JSON array to BigQuery

CHART with rounded corners in Googe Sheets

Ultimate Beginner's Guide to Google Sheets

🎓Teachers Book. Accounting system for tutors in Google Spreadsheet

Google Sheets Project. Convert Selection to PNG Image

Google Sheets vs GitHub

Use Google Form as custom HTML-interface for Sheets

Get 90 AI-generated fake Faces into your Google Sheets

SheetJobs. Copy files from one folder to another. Script

How to SPLIT text by text as text in Google Sheets

#13. Working with Text. Extract Numbers

🐞 Work with delimited text in Google Sheets. ArrayFormulas.

#3. Working with Text. Number of times certain text occurs

How to convert digits to emojies with SEQUENCE+ in Google Sheets

How to create sequence of repeated values in Google Sheets. 111-222-333...

Basics#3. Cells and Ranges #3. Your first script: Find the cell

Basics#28. Filter #6. Contains in list

SheetSpam#18. Get Sheet by name with function in Google Script

Filter Out All Blank Rows with a formula in Google Sheets

Create folders in Drive automatically with Google Sheets Script

How to Enable/Disable Filter criterias with a CheckBox in Google Sheets

How to install named functions to your Google Sheets → 🪅function for blank rows below each group

CoolTables.Online Collection of Named Functions for Google Sheets

How to combine (merge/union) ranges with FILTER function in Google Sheets

How to split text by chars in Google Sheets. Bonus: most emojis are splitted correctly 😉

SheetSpam#16. Autocomplete the code in Google Sheets Script

MOST CREATIVE Percent Charts in Google Sheets 📊 Step-by-Step Tutorial | Free template included

How to mockup your dataset with distributed random pick function in Google Sheets

Create an array filled with text. How to make your named function in Google Sheets

How to generate array of columns by column indexes in Google Sheets. ArrayFormula

🐇 How to make Gantt Chart from SPARKLINE ArrayFormula in Google Sheets

#11. Working with Text. Convert to date

🤯 Benchmark — named function to test the speed of named functions in Google Sheets

Basics#18. If #2. ArrayFormula for AND & OR

No-Script Multi-line Dependent Drop-Downs in Google Sheets

ImportRange ArrayFormula in Google Sheets. Lambda+ByRow

How to get country flags images into your Google Sheets. ArrayFormula

How to count items by groups in a sorted data in Google Sheets.

SheetSpam#29. Create Reference with Unique formula in Google Sheets

Bar chart. EASY in

SheetSpam#26. Filter with a script in Google Sheets Script

Basics#1. Cells and Ranges #1. How to find exact rows and columns

How to generate random colors in Google Sheets and how the HEX color code works 🟥🟩🟦

Basics#13. Vlookup #1. Return multiple columns

How to REDUCE multiple SUBSTITUTE functions in Google Sheets

SheetSpam#12. Open Script Editor in Google Sheets

Filter by Text with a Function in Google Sheets

How to Create Month 🗓️Calendar by Date in Google Sheets

Basics#27. Filter #3. Last non-empty row

How to combine data with {Arrays} in Google Sheets

02. Arrays. All Possible Combinations

SheetJobs. Create backups in a regular basis. Script

SheetSpam#4. Filter to select each odd row

#14. Working with Text. Replace multiple text

How to generate array by row indexes in Google Sheets. ArrayFormula