585Google Sheet Tutorials

Create a better list of domains.

Enable your apps script functions be auto completed while you're using Google Sheets.

the answer is if you have a column of true or false you can use the count if statement argument formula. That's just count if, and then you say your range, and then comma, true. Or false, whichever one you want and you'll get a count.

Automate your apps script and macros you can record.

Build a list of domains you can buy right now. Easily check if the domain you want is still available.

Add one more feature to the 100 Twitter Templates tool.

I download it from MailChimp and then I try to figure out which companies are subscribed to me most. And I do, I have to figure out the domain and count the domain. And we're gonna do that all in Google Sheets.

revisiting the "what changed" custom function I built in a past video. Showing you more apps script

We go deep into the syntax and usage of the SPLIT() formula.

If you find Vlookup a difficult formula to understand, this formula combination might be better. It's also much more flexible than Vlookup. Index/Match is the best. It's one of my favorite formula combinations.

What happens very often is we want to figure out an average averages, help us tell the story of a large set of data, but averages also can lie.

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

This feature is really handy for designers who want to create notes around designs and mockups to showcase to clients. As a photographer, I can also use this to create a searchable sheet with keywords for my photos. You can even use screenshots instead of Unsplash photos like I'm using here. Basically, all you have to do is insert the images into cells and use V lookup to search for them using the ID numbers. You can use this to mock up a newsletter, test out different thumbnails as a YouTuber, or create a landing page or workflow for your business. It's really easy to change the photos by just changing the ID number.

Go through a fun sheet and make it better.

Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.

Incredible design and inspiration for us in our sheets.