TRY ME!
→ Random Tutorial

348 Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀
Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯
Precise: Ensure your data is always accurate and your analysis is clear.
🌈
Creative: Discover new ways to use Google Sheets.
❌
Can't Find a Video?: Members can reach out and ask me anything!

Search Every Function in Google Sheets

Search Every Function in Google Sheets

Built a useful tool to filter Google Sheet formulas based on keywords.
Find Keywords in Any Column. Create quick search dropdown to find keywords

Find Keywords in Any Column. Create quick search dropdown to find keywords

Create a quick search dropdown to find keywords in any column.
Intermediate
3 Ways to Count in Google Sheets

3 Ways to Count in Google Sheets

The video explains three ways to count cells or information in Google Sheets: using the Explorer, using the COUNT function, and using the COUNTALL function. The Explorer is a tool located at the bottom right of the screen that allows you to quickly understand your data and find the count of items in a column. The COUNT function allows you to count the number of cells that contain numbers in a range of cells, while the COUNTALL function counts all the cells in a range, including those that contain formulas or are blank. The video also mentions other functions such as SUM and UNIQUE
Beginner
COUNTA() COUNTIF()
4 Ways to Make a New Spreadsheet

4 Ways to Make a New Spreadsheet

Here's four ways to make a new sheet. There's lots of reasons why you wanna know all of them. Makes you a more flexible, faster spreadsheeter.
Beginner
CONCAT()
Wordle in a Google Sheet | Work in Progress

Wordle in a Google Sheet | Work in Progress

Building a clone of Wordle inside Google Sheets.
Intermediate
COLUMN() IF() INDEX() MID() TEXT()
Redirect a Domain to a Google Sheet

Redirect a Domain to a Google Sheet

Learn how to redirect a domain to a google sheet. Set up subdomains and MVPs of sites easily.
Beginner
Most Common Errors and How To Handle Them in Google Sheets

Most Common Errors and How To Handle Them in Google Sheets

Today we're gonna talk about errors in Google Sheets and how you can fix them. #N/A, #ERROR, #REF!, #NAME?, #DIV/0
Beginner
CONCATENATE() VLOOKUP()
Add Pics to Marketplace in a Google Sheet

Add Pics to Marketplace in a Google Sheet

Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.
Beginner
FILTER() IMAGE() INDEX() MATCH()
How do I Insert Emojis into Google Sheets?

How do I Insert Emojis into Google Sheets?

Using Control+Command+Space in inserting emojis into Google Sheets.
Beginner
Create a Headline Generator

Create a Headline Generator

Learn to create lead magnet or sellable worksheets for your business. Included are more topic ideas so you can take this template and run with it.
Most Popular Advanced
CONCATENATE() PROPER()
5 Ways to use IF() Formula to Create Magic in Your Sheets

5 Ways to use IF() Formula to Create Magic in Your Sheets

We're going to create some magic here. Some if magic, sprinkle a little magic on your sheets, you can use these formulas in existing sheets.
Intermediate
AND() IF() IFS() ISBLANK() OR() +1 more
Twitter App Clone in a Google Sheet

Twitter App Clone in a Google Sheet

I built a twitter clone in Google Sheets
Beginner
Create a Timer with Apps Script

Create a Timer with Apps Script

Create a start time and end time and duration of that, with a little bit of Apps Script.
Intermediate
IF() ISBLANK()
Naughty or Nice? - Google Sheets' New Dropdown Chips

Naughty or Nice? - Google Sheets' New Dropdown Chips

Google Sheets has a new way to do dropdowns. Is it naughty or nice?
Spreadsheet Automation 101: Introduction to Pre-course Videos

Spreadsheet Automation 101: Introduction to Pre-course Videos

Learn how to automate spreadsheets with Apps Script. The pre-course videos equip you with the fundamentals of coding before you start.
 Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu

Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu

This lesson will get you started on your first trigger. It’s the first real spreadsheet automation you can do. Fun stuff!
Spreadsheet Automation 101 Lesson 2: onEdit() Trigger

Spreadsheet Automation 101 Lesson 2: onEdit() Trigger

One of the things to learn: We can only have one onEdit() in our entire spreadsheet file. I’ll also walk you through on how you can use Event and Logger to get cool information.
Learn Google Sheet Formulas The Hard Way

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bettersheets.co/formulas
 Announcing Button Styles | A Free Google Sheet Add-On

Announcing Button Styles | A Free Google Sheet Add-On

A new free Google Sheets Add-On to make drop shadow buttons inside your sheets. Free for everyone. Announced to members first.
Capture Emails from Website Form to a Google Sheet (Without Zapier)

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Embed a little HTML into your site to capture Emails straight to a Google Sheet. I've written the apps script and the html and the javascript for you. As easy as copy and pasting. Use my referral link if you choose to use Carrd for this: https://try.carrd.co/kamphey
SUBSTITUTE()

Displaying items 81-100 of 348 in total

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons