283 Tutorials

Learn to Code in Google Sheets, For Programmers

FREE

Zakir Asks: Find First Car in a Row

Automatic Weekly Backup of Google Sheets

Find the first value in a row.

Use Row() For Math You Need to Iterate

Discover how to Save Your Sheets Every Week Automatically

Facebook Ads Mockup Generator

FREE

Password Protecting Data In a Google Sheet

Create a simple facebook ad mockup with image and primary text in a google sheet. Get character count too!

Password Protecting Data In a Google Sheet Part 2 The Basics

A funky way to password protect some data in a sheet, 3 ways to do it: with IF(), Apps Script, and Encoding

Sync Two Tabs Without ImportRange()

Covering some of the basics I skipped over in the part 1 video.

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Get this epic script that automatically edits two tabs and keeps them in sync.

Anika Asks: How To Set Text Overflow All The Time

Learn about triggers, hourly, daily, weekly, etc.

Organize Anything! - Build a Kanban Board / Trello Board

Learn to set text wrap, overflow, or clip.

Better Than Happy | Redesign of The Feelings Wheel

Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.

FREE

Escape Spreadsheet Hell A Mini Game

Turning an infographic into a useful Copy Writing cheat sheet

FREE

Send a Daily Email with Inspiring Quote - A Little Pick Me Up

Free min game to learn 3 keyboard shortcuts, get it at https://kampheyapproved.gumroad.com/l/escapespreadsheethell

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

Created a daily email with a motivational quote in the subject.

Discover Duplicates Misspelt

Create a CPM Custom Function (Create Better Calculators!)

Search and find duplicates that are spelled differently.

David Asks: About Primary Keys

Tagging Titles, Create a Comma Separated List of Tags

Create relational databases with index/match