TRY ME!
→ Random Tutorial

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

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Your question is, you have these events and dates and statuses. And you want to turn them green actually you wanna turn them any, some color, the whole entire row based on if in this D column the status is closed.
Conditional Formatting Intermediate
How To Change Date Format Automatically

How To Change Date Format Automatically

Create automations to change date format based on the format you want, inside your sheet.
Advanced
Hardest Formula: SumIF | Addition Based on Dates / Values

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition, even if that condition is a date.
SUMIF() UNIQUE()
Find the Start date of the Current and End date of the Current Month

Find the Start date of the Current and End date of the Current Month

We want to know, based on today's date, what is the start of the month and what's the date at the end of the month.
EOMONTH() TODAY()
How Many Days Between Two Dates?

How Many Days Between Two Dates?

Figure out how many days between two days, or how many days until a certain date. Or figure out how many days has it been since an event. Great for automatic email notifications of due dates, deadlines, etc.
Intermediate
DATE() DATEDIF()
User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

Search through and filter data to get what you want, when you want it. Tired of sifting through endless rows and columns? Learn how to filter your Google Sheet database with dates, checkboxes, and dropdowns. Simplify your workflow today!
Beginner
FILTER() IF()
Ian Asks: How to sort dates by year/month (can't do with filter)

Ian Asks: How to sort dates by year/month (can't do with filter)

In Excel you actually have these options of sorting by year, by month, by date. But let's do it in Google Sheets.
How To Filter Dates (They Are Numbers Too!)

How To Filter Dates (They Are Numbers Too!)

Dates are numbers so you can filter them with greater than and less than.
Beginner
FILTER() IFERROR()
Anders Asks: Find first and last of filter by date

Anders Asks: Find first and last of filter by date

Useful for calculation or filters by dates.
Beginner
COUNT() IF() INDEX()
Add a Checkbox to Turn on Dark Mode

Add a Checkbox to Turn on Dark Mode

Get ready to shake things up, formula fanatics! Learn how to add a dark mode button to your Google Sheets with this dead simple trick. Using conditional formatting and a custom formula, you can turn on dark mode with just one click. Don't miss out on this cool feature! Made this really quick dark mode click button. And I wanted to show you how I did it because it's dead simple, super simple. It's literally just using conditional formatting
Conditional Formatting Beginner
Richard Asks: Copy Template Tab and Rename to Date Every Week

Richard Asks: Copy Template Tab and Rename to Date Every Week

Member Richard asks this question. Answer: use Google Script and a Trigger.
Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

A member, Alejandro, asks about taking their custom calendar inputs and figuring out study totals for a week. They created a beautiful input and just need to the calculations. I show how to use the data to do the calculations. If you've never used the FLATTEN() formula, this is a good example! And we use double UNIQUE().
FILTER() FLATTEN() SORT() SUM() UNIQUE()
Life to Date

Life to Date

This is a review and improvement of Emmett Shear's Life to Date Sheet. Originally he tweeted about it and shared a sheet. I thought I could make it a bit better looking.
 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()
How to Format Timestamp to Day and Month

How to Format Timestamp to Day and Month

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Analyze sales with COUNTUNIQUEIFS Formula. 
Intermediate
COUNTA() COUNTUNIQUEIFS() FILTER() TEXT() UNIQUE()
How To Format Sheets for Notes

How To Format Sheets for Notes

Create sortable notes in Three ways. 
1. By adding the original word over and over again
2. Adding notes all in one cell with CMD + ENTER for new lines
3. Use Apps Script to sort the A column even with groups of rows.
 Benoit Asks: How to Convert Case

Benoit Asks: How to Convert Case

How can I use this function, lower, upper, or proper as a conditional formatting? And then the other question is, how can I use this to apply on a bunch of cells without having to double the cells?
ARRAYFORMULA() LOWER() PROPER() UPPER()
Add Character Count and Character Limit

Add Character Count and Character Limit

I'm gonna show you how to make a character counter and then account characters. And then I'm also gonna show you how to make a limit. It's really simple. It's one formula and some conditional formatting
Beginner
LEN()
Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

Yes, using conditional formatting we can do this.
Conditional Formatting Beginner

Displaying items 1-20 of 28 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