TRY ME!
→ Random Tutorial

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

How to Get Time from a Timestamp

How to Get Time from a Timestamp

Extract the time from a Google Sheets timestamp.
Beginner
Roast: Sales Tax Calculator

Roast: Sales Tax Calculator

I would not think that I would enjoy sales tax calculators, no one enjoys sales tax calculators, but when it's in a Google sheet, it's really exciting.
Intermediate
How to Find Duplicates and create a Duplicate Detector

How to Find Duplicates and create a Duplicate Detector

Create a duplicate detector with a few google sheet formulas.
Beginner
CONCATENATE() COUNTA() IF() MATCH() ROW() +1 more
Basics - 5 Ways to Change Row Height

Basics - 5 Ways to Change Row Height

You can change the row height in 5 different ways in a google sheet. Consider adding padding around your text with more row height. and column width.
Beginner
How to Refer to Other Cells - A1 and R1C1 Explained

How to Refer to Other Cells - A1 and R1C1 Explained

Get down to basics of spreadsheets.
Beginner
Basic Keyboard Shortcuts To Speed Up Your Productivity

Basic Keyboard Shortcuts To Speed Up Your Productivity

We're gonna talk about some of the most basic keyboard shortcuts that incredibly time saving and are gonna make you so much faster when using Google Sheets.
Beginner
Write Your First Script

Write Your First Script

I walk you through everything you may encounter along the way of coding in Google Apps Script. Discover the challenges and pitfalls before you fail. If you’ve never coded before, I’m right there with you all the way.
Most Popular Beginner
Biggest Flaw In Dashboards with Dark Colors

Biggest Flaw In Dashboards with Dark Colors

An optical illusion in Google Sheets and how to fix it.
Pabbly Connect Countdown - "Sheet Improvement!"

Pabbly Connect Countdown - "Sheet Improvement!"

Create a countdown timer inside of a google sheet. Unlock the secret to a lifetime deal... TIMEI! Discover their amazing live Google sheet and join the countdown to their exclusive offer. Watch as we recreate and enhance their sheet with stunning colors. Don't miss out on this epic journey. Click now!
 Combine 2 Columns into 1: First Names and Last Names Together

Combine 2 Columns into 1: First Names and Last Names Together

Add together two columns data.
Beginner
ARRAYFORMULA() CONCATENATE()
Create Square Cells for Dashboards or Beautiful Information

Create Square Cells for Dashboards or Beautiful Information

I offer an alternative design for your dashboards. Any time you want to present information, stats, numbers, it's a good idea to see what else is possible. Design something that makes your sheets stand out from the drudgery we've been dealing with for decades of spreadsheets and dashboards.
Beginner
Bjarne Asks: Can I show the total number of rows minus the header row?

Bjarne Asks: Can I show the total number of rows minus the header row?

find out how to show the total number of data rows available in a sheet.
Beginner
COUNTA() COUNTBLANK() SUM()
How to Edit a Macro

How to Edit a Macro

Editing macros in Google Sheets helps you do more in less time.
Advanced
Aesthetics Teaser: How To Use Alternating Colors

Aesthetics Teaser: How To Use Alternating Colors

How to use alternating colors in your spreadsheets.
Beginner
RANK()
Use Min and Max for More Average Averages

Use Min and Max for More Average Averages

What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.
Beginner
AVERAGE() MAX() MEDIAN() MIN()
Count How Many Subscribers In a Company by BetterSheets.co

Count How Many Subscribers In a Company by BetterSheets.co

I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.
Intermediate
ARRAYFORMULA() COUNTIF() LOWER() SORT() SPLIT() +1 more
Make your Custom Functions Like Native Functions | Custom Function Autocomplete

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

Enable your apps script functions be auto completed while you're using Google Sheets.
Advanced
Take a list and make it Vertical, Using Split Join or RegexReplace

Take a list and make it Vertical, Using Split Join or RegexReplace

Create vertical lists in Google Sheets.
Beginner
JOIN() REGEXREPLACE() SPLIT() TRUE()
Adding Number and dot to rank or order lists

Adding Number and dot to rank or order lists

This is like one of those things that is incredibly frustrating about Google Sheets. I will tell you right now. It is the simplest, stupidest solution
Beginner
CONCAT() ROW()
Make a Quick Pipeline (For Sales and More)

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.
Beginner
TRANSPOSE() UNIQUE()

Displaying items 281-300 of 327 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