Better Sheets

Login

Get Instant Access

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!

Google Sheet Basics - The Absolute Basics

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

Build The Dashboard - Design a Better Dashboard Part 3

We're actually gonna go build the dashboard today.

CHAR() SUM() ROUNDUP() COUNTA() IF() +2 more

3 Ways to Count in Google Sheets

The video explains three ways to count cells or information in Google Sheets: using the Explorer, using the COUNT function, and using the COUNTALL function. The Explorer is a tool located at the bottom right of the screen that allows you to quickly understand your data and find the count of items in a column. The COUNT function allows you to count the number of cells that contain numbers in a range of cells, while the COUNTALL function counts all the cells in a range, including those that contain formulas or are blank. The video also mentions other functions such as SUM and UNIQUE

COUNTA() COUNTIF()

Create A Video Course in a Google Sheet | LMS in a Google Sheet

Set up a list of video links, and a checklist for others to use.

Conditional Formatting Data validation Intermediate

IF() COUNTA() COUNTIF() SPARKLINE()

Dashboard Principles - Design a Better Dashboard Part 1

One of the best examples of a dashboard I got from a great talk on just totally like SASS dashboards, and they talked about the speedometer and why the speedometer is such a great dashboard is that it is it encapsulates all of the principles of what goes into a great dashboard.

Switch Months Menu - Design a Better Dashboard Part 4

Create a dropdown that changes the months displayed in a dashboard.

INDEX() MATCH()

Create a Podcast Advertising Calculator

Build from scratch a calculator to figure out podcast advertising rates.

How to Make Hangman Game In Google Sheets

Learn to create a fun game called Hangman in Google Sheets with Better Sheets. Watch the video to challenge yourself and see how it works. What other games can you make inside of Google Sheets? Create a game of hangman inside Google Sheets. Showcases a few Google Sheet formulas like SEARCH()

IF() IFERROR() SEARCH() COUNTA() LEN() +1 more

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

Add together two columns data.

ARRAYFORMULA() CONCATENATE()

Great Sheets! Corona Hiring Sheet

Reviewing a Corona hiring sheet. A great example of using Google Sheets. I have high praise for the design and the use of forms for data validation. The sheet makes great use of white space, circular image, and icons instead of text. While I suggest other ways to monetize the job board, I acknowledge the creator's decision to avoid exploiting the situation.

Switch Data

We're going through the switch formula because in the past if I've ever had to change, say a day of the week or a month on the calendar to a number, or I have to change that number to the month or text, it's really hard.

VLOOKUP() SWITCH()

How to Create a CRM in google sheets w/ Dashboard

Build a Customer Relationship Manager right inside a Google Sheet. Track your customers, your sales progress, and your revenue in an easy to create dashboard.

Most Popular Intermediate

Zunaid Asks: How to get Get Meta from URLS? Answer: Use ImportXML()

how would I do the following? In Google Sheets, it's in column A I have a list of URLs. For each of those URLs, I want to pull that URL's featured image and meta description, and put those in columns B and C. Here's how you do it. I just grabbed Wikipedia articles for this example.

IMPORTXML()

Make Unsplash in Google Sheets - Part 2

Fix the case sensitive search with lower(). Add quick links to prefilled results. Create another sheet with ImportRange().Protect the sheet from unnecessary edits.

Most Popular Intermediate

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.

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!

Roast: Sidekick Recipes

Unlock the Secrets of Recipe Organization with this Google Sheet review. A deep dive into a Google Sheet and how to improve it. Not just a Google Sheet Tutorial. Dive deep into a sheet that hold recipes. Great video for those looking to organize and share Recipes in a Google Sheet. Whether you're a home cook or a budding professional chef. You're probably already curating your recipes in a Google Sheet. Here's how to make your sheet better.

Biggest Flaw In Dashboards with Dark Colors

An optical illusion in Google Sheets and how to fix it.

Basics - Structure of a Sheet: Index() Row() and Column()

Let's figure out how a sheet is structured.

COLUMN() INDEX() ROW()

Basics - 4 Ways to Change Column Width

you might actually find something new and interesting about it. We're just changing the column width.

Displaying items 521-540 of 630 in total

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons