Better Sheets

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

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()

YouTube Title Rewriter with GPT-3

Rewrite YouTube Titles with GPT-3 API. Writes shorter, more persuasive titles I can use to increase views on YouTube. Code is included in Apps Script of sheet.

Advanced

Visicalc 2023 Quick Walkthrough

This is a fun template I created for April 1st. Take a quick walk through the features here. And get yourself a copy of the sheet below.

Beginner

SUM()

That Viral Growing Plant Progress Chart

Create a growing flower pot from checkboxes with this bountiful formula combination. Members get free access to the sheet in the video.

Data validation Beginner

COUNTIF() IMAGE() SWITCH()

Data Validation with Formulas

The issues you might run into validating data and 4 formulas you can use to create workflows or processes in sheets. Covering: ISBLANK, ISFORMULA, ISURL, ISTEXT formulas.

Intermediate

IF() ISBLANK() ISFORMULA() ISTEXT() ISURL()

Displaying items 361-365 of 365 in total

TAGS

FORMULAS

TOPICS