TRY ME!
→ Random Tutorial

600 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!

Study Better With Google Sheets

Study Better With Google Sheets

Made Ali Abdaal's study google sheet better.
Beginner
COUNTA() GOOGLETRANSLATE() INDEX() RANDBETWEEN() VLOOKUP()
Access Free API's with Google Sheets

Access Free API's with Google Sheets

Get Kanye Quotes, Hogwarts Houses, Public Holidays, and more fun with API's in this 1 hour dive into Free APis available online and accessible in Google Sheets. 
API's here: freepublicapis.com
Intermediate
COUNTIF() IF() IMAGE() ISBLANK()
Introducing Bigger Brain

Introducing Bigger Brain

10x your expertise driven content. Create new sections and fun additions to your own content. Make your writing more engaging and more educational.
Advanced Intermediate Beginner
Allow Multiple Selections is in Google Sheets Yay!

Allow Multiple Selections is in Google Sheets Yay!

Now you can select multiple options in a dropdown. Hip Hip Hooray!
Beginner
FILTER() IFNA() JOIN() SEARCH() SPLIT() +1 more
How To Get Someone to look at a Cell in Your Sheet

How To Get Someone to look at a Cell in Your Sheet

Some helpful tips on how to get someone to look at a particular cell in your sheet.
Beginner
Tips to Navigating Thousands of Lines of Code In Apps Script

Tips to Navigating Thousands of Lines of Code In Apps Script

Find out how I use Apps Script built in features to code very quickly and efficiently. 
Beginner
Create an Automated Task List

Create an Automated Task List

I've created simple automations to make an awesome automatic task list. Add a checkbox when adding a task. Add a timestamp when done. Also emailing every day the top task.
Intermediate
How to Format Timestamp to Day and Month

How to Format Timestamp to Day and Month

Don't Delete My Formulas

Don't Delete My Formulas

How to prevent someone from deleting your formulas. Beyond protecting your range or sheet.
 Can I Automatically Rename a Sheet based on a Date?

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.
Intermediate
DAY() MONTH() TODAY() YEAR()
Create New Worksheet When Google Form Submitted

Create New Worksheet When Google Form Submitted

Automate copying a template for new form submissions with user data inserted into the new sheet.
Advanced
Why can't people fill in my Google Form?

Why can't people fill in my Google Form?

The reason is because a new form has a setting to only allow those in your domain to fill in the form. I show you in the settings page where to fix this.
 Go to Specific Cell When Spreadsheet is Opened

Go to Specific Cell When Spreadsheet is Opened

Create an automation that goes directly to a cell you pick every time you open the spreadsheet file.
Beginner
Better Email Form on Google Sites

Better Email Form on Google Sites

Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.
Advanced Intermediate
How to Copy To New Tab When Checked

How to Copy To New Tab When Checked

Copy text from one tab to another based on a checkbox being checked.
Beginner
Add NPS to Your Google Site

Add NPS to Your Google Site

Create buttons on your Google Site to get an NPS, or Net Promoter Score directly to a Google Sheet.
Intermediate
AVERAGE()
Create a Vote Button from Google Sites to Google Sheets

Create a Vote Button from Google Sites to Google Sheets

Connect your published Google Site to Google Sheets with Apps Script and a Button.  Great to use for Voting, upvoting, NPS, or anything you want feedback on, at the click of a button from your Google site to a Google Sheet.
Intermediate
Find Column with Header to Bullet Proof your Vlookup

Find Column with Header to Bullet Proof your Vlookup

Make your VLOOKUP formulas flexible and your data move-able with this trick.
Intermediate
HLOOKUP() MATCH() VLOOKUP()
Reformat Pasted Cells Automatically

Reformat Pasted Cells Automatically

Create uniform formatting even if you're copy and pasting data that is differently formatted.
Intermediate
Americano Tournament Template With Four Automations

Americano Tournament Template With Four Automations

Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.
Intermediate
SORT() SUM() SUMIF() UNIQUE()

Displaying items 61-80 of 600 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