630Google 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!

Generate Hundreds of Business Names

Create business names quickly with this Google Sheets trick.

Roast: 363 Questions VCs Ask Founders

we got a pretty darn simple and sweet sheet here with funding. A lead magnet that is 363 questions that PCs investors ask startup founders.

Better Font Colors

While this advice and all well and good, try out Sheet Styles, a free Google Sheets Add-on that enables you to do this less contrast style in one click. https://sheet-styles.bettersheets.co/

Sheet Improvement: Better Business Idea Selection Framework

Got this template directly from AppSumo and improved upon it.
IFERROR() ARRAYFORMULA()

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.

Search Every Function in Google Sheets

Built a useful tool to filter Google Sheet formulas based on keywords.

Make Your Headers Useful

Today we're gonna talk about headers. I'm gonna give you three really cool ways to use your headers.

Hide Completed Bars - Make Progress Bars with Sparkline: Part 2

Use the IF() formula to hide completed bars and display messages instead of bars depending on the situation.

Intro Video - Make Better Sheets

Transform your Google Sheets game with Better Sheets tutorials! Learn how to create dynamic databases, design-friendly sheets, and more. Discover hidden formulas and tools, and even build your own. Don't miss out on leveling up your productivity. Create dynamic tools, revamp your skillset, and ultimately master Google Sheets like never before. Better Sheets platform offers more than just tutorials. There is a deep directory of every Google Sheets formula with links to step-by-step tutorials as well as blog posts and youtube videos. It's the ultimate resources to learn how to use formulas in Google Sheets. Every tutorial has listed categories and courses it's a part of. In addition to that any formula featured is listed. And you can click on any formula to see that formula in action in other tutorials on the Better Sheets platform. Watch this walkthrough of the Better Sheets platform.

Roasting Google Sheets Intro

Reviewing sheets. We're going to get through this whole coffee and we're going to get through a bunch of Google sheets.

Capitalize Each Word

Every word can be capitalized with this formula.
UPPER() LOWER() PROPER()

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!
INDEX() GOOGLEFINANCE() SPARKLINE() TODAY()

Find "Entry Number" for Bookmarklet

Followup to the Bookmarklet video. To help you find the entry number for each form field.

How Do I Make a CSV File? And give a link to someone instead of the csv.

Create a link to your sheet that immediately download the sheet as a CSV file. Great for sending exports as a link.

Create a Sheet of Sheets for Project Management and/or Data Management

Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!
TRANSPOSE() SPLIT() REPT() COUNT() INDIRECT()

Creating Blank Cells For Good Reasons with IfError Formula and if(isBlank) Formula

There are surprisingly few times you want to have blank cells, or even create blank cells. In this video I'll show you the good reasons you want blank cells.

How to Find Duplicates

Learn how to find duplicates with a simple formula in Google Sheets.
IF() MATCH() ROW() CONCATENATE() FILTER()

Displaying items 581-600 of 630 in total