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

3 Free Tools to Make Your Google Sheets Better

3 add-ons you can install right now and your Google Sheets life is better!
Tiny Sheets makes it simple to delete excess blank rows and columns.
Sheet Styles makes for less headaches and better text colors.
Button Styles makes awesome buttons for your users to click.

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Make your Google Sheets visually appealing and easier to understand with our expert tips on using gridlines, border styles, and colors. Learn how to create a professional-looking spreadsheet that effectively communicates your data to your audience. Boost your productivity today! We're gonna be talking about how to communicate better with grid lines, border styles, and border colors. Really interesting thing happens when you hide grid lines. You lose the grid, and I'll show you how to add that in. And some really interesting things you can do with different styles of border.

Beginner

Convert Your Bullet Journal To Google Sheets

Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.

Beginner

VLOOKUP()

Ali Abdaal's Google Sheet | Year at a Glance

Ali gave away a free Google Sheet Template. In this tutorial I step through making it better, with better fonts, and colors. As well as making it more branded to share Ali's brand message better as the sheet gets copied and used, and shared. Great tutorial for those wondering how to brand your own sheets. Make your own lead magnets, and share your brand's message via Google Sheets.

Beginner

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.

Create an Auto-Update Sales Chart: Trailing 12 Months

how to create an auto-updating sales chart that displays the trailing 12 months of data in Google Sheets. The tutorial uses a sample dataset to demonstrate how to build a dynamic chart that updates automatically as new data is added.

Intermediate

COUNTA() IF() INDEX() ISBLANK() SUM()

Roast: Mortgage Calculator for Google Sheets

Reviewing an existing sheet called "mortgage calculator for Google sheets" I point out the really nice "back to dashboard" button. This seems like a minor point but ends up improving the user interface, and user experience. Users tend to get lost in sheets with tabs, and providing another path to a sheet you know your users will want to go to, is great. At the end of the video I point out that you probably want to provide more outputs than inputs. Meaning that if someone puts in a few numbers, they get out of it a few years of statistics, or calculations in this case. Calculators are cool, but generators are even better. Calculators have a tendency to have more inputs than outputs. You're trying to get to one magical result. But a spreadsheet can be so much more powerful and show many more outputs if you do those calculations,. Especially here for a mortgage, you can show a range of calculations in addition to a single calculation.

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Let's make a progress bar in Google Sheets.

SPARKLINE()

Create Drop Shadows! This makes your dashboards pretty.

Add extra pizzazz. a little more snazz to your sheets. Make dashboards with very flexible drop shadows. A great google Sheet trick for any occasion.

Let's Make a Bookmarklet!

Curate a newsletter. Collect YouTube videos. Research competitors. All with this one line of javascript. Build your own web clipper. Use the Bookmarklet to clip web content to your Google Sheet. Clip text and links directly from the web to your Google Sheet with just a few clicks.

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making application inside your Google Sheet! Learn how to display tasks and to-do’s in vertical categories.

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreadsheet expert starts!

Beginner

Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

We’re getting data on movies and getting it into Google Sheets. Let’s create some magic inside Google Sheets!

Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script

Use getData and UrlFetchApp functions, as well as Logger to get OMDb API data in our Google Sheet. Learn how to access an API outside of Google Sheets.

Announcing Button Styles | A Free Google Sheet Add-On

A new free Google Sheets Add-On to make drop shadow buttons inside your sheets. Free for everyone. Announced to members first.

Magical Things You Can do with Checkboxes in Google Sheets

Turn your sheets into web apps with interactive checkboxes. Make your sheets' UI better with more interaction.

Data validation Beginner

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

Create vertical lists in Google Sheets.

Beginner

JOIN() REGEXREPLACE() SPLIT() TRUE()

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.

Beginner

TRANSPOSE() UNIQUE()

6 Ways to Make Your Checkboxes Better

Learn How to Take Your Google Sheets Checkbox to the Next Level and Get More Organized! Click Now to Discover Creative Ways to Use Checkboxes and Boost Your Productivity!

We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.

Data validation Beginner

Displaying items 21-40 of 324 in total

TAGS

FORMULAS

TOPICS

324 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

3 Free Tools to Make Your Google Sheets Better

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

Convert Your Bullet Journal To Google Sheets

Ali Abdaal's Google Sheet | Year at a Glance

Intro Video - Make Better Sheets

Create an Auto-Update Sales Chart: Trailing 12 Months

Roast: Mortgage Calculator for Google Sheets

Create a Progress Bar - Make Progress Bars with Sparkline: Part 1

Create Drop Shadows! This makes your dashboards pretty.

Let's Make a Bookmarklet!

Create a Trello Board with Transpose Formula in Google Sheets

Google Sheet Basics - The Absolute Basics

Spreadsheet Automation 101 Lesson 4: Access APIs Introduction

Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script

Announcing Button Styles | A Free Google Sheet Add-On

Magical Things You Can do with Checkboxes in Google Sheets

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

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

Make a Quick Pipeline (For Sales and More)

6 Ways to Make Your Checkboxes Better