79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

85Tutorials

See the full list of Tutorials to learn from

Combining GoogleTranslate() and DetectLanguage() to figure out what a language is without having to know the two letter codes. And adding a dropdown range to make it easier to find the language you want to translate to. What a great way to solve the frustrating world of International language!
Learn about "Oswald" the best font for headers. You might fall in love with this font as much as I've fallen in love with Karla (the font). It helps your headers stand out without having to do much coloring or more. A little change to your header font and your sheets will look better.
A short 10 minute video to get you started with Apps Script. Showing you menu: Extensions > Apps Script. And shows off how to write a function, do some math, manipulate some text. Members can get Spreadsheet Automation 101 in https://BetterSheets.co/courses

3

Less than 2 minute tip to help you link directly to a tab in a sheet. Each spreadsheet file has it's own unique id, a url. But also every tab has a unique "gid" that you can use to link directly to a tab in a sheet. Saving people a click.
I figured out that 20% of my videos are getting 80% of the watch time on my YouTube channel, and I actually used a Google sheet to figure this out.
Learn how to use Formulas in Google Sheets. Use the Equal sign "=" to unlock a magical portal of over 500 functions and formulas. Learn one cool trick that even experts might not know about formulas.

6

Create a sequence of numbers that magically appears as you type in each row. Put this in A1 and start typing in column B: =SEQUENCE(COUNTA(B:B),1,1,1)

7

Unknown Range Name means we've typed in a formula the wrong format of a sheet name. I show you how to fix that and some other errors that might pop up.

8

Learn to automate an email, with data, from a sheet.

9

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.
Checking data? This script changes bg color of entire row as you move your cell selection.
A calendar template designed like early Craigslist. A brutalism minimalist style calendar.

12

Quick intro to a better experience of using Google Sheets

13

I built a twitter clone in Google Sheets

14

In this video, I'm going to share with you how to go basically from sheet to script and then back to the sheet again.
Continuing to show you how to write a function in Apps Script.
welcome to part one of Learn to Code in Google Sheets. In this video, we're gonna get started to code.

17

Find the first value in a row.
Create easy to use math iterators with the ROW() formula. It tells you the row your cell is on, but why do you need that? you can iterate math equations! It's neat!
Create a simple facebook ad mockup with image and primary text in a google sheet. Get character count too!

20

Displaying items 1-20 of 85 in total

Tags

Formulas