Tags

Formulas

554Google Sheet Tutorials

Discover the Power of Productivity

An Exclusive Library of Google Sheet Tutorials!

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

Learn the best Google Sheets formulas and spreadsheet automation techniques to supercharge your workflow. Discover how to automate repetitive tasks effortlessly, saving you valuable time and effort.

🎯 Precise:

Master Google Sheets formulas to ensure your data is always accurate and up-to-date.

🔧 Automate Your Sheets

Delve into the world of Google Apps Script. Automate reporting. Automate your data. Automate your business

Create nice colorful sheets (contrasting colors) that look and feel like an extension of your site. Add some padding around text. Decrease text and make your sheets awesome.
Got this question in the Facebook Group: How to count the number of numbers in a row. I saw two possible solutions mentioned in the comments and wanted to go through why those are okay but there is a much more flexible and better solution.
Automatically uncheck a whole range of checkboxes. Or just do it yourself with the spacebar.
I created a weight loss tracker template for myself and thought you, and all members would like it. So get it, copy it, and start your weight loss journey today. Comes with a nice chart already so all you have to do is add your numbers every day.
Let me tell about some cool hacks you can do with checkboxes. Like making a checkbox have alternative values, or making a checkbox look like a button, not a check mark.
Create rounded pill form fields in Google Sheets.
Using Canva and a bit of a transparent PNG hack, you can make these very easily too!

also make sure to check out Coupon Code Maker a software product I sell that generates thousands of coupon codes in a click.

Recently updated dashboard makes it really cool! 
Update to Coupon Code Maker
Available for free for lifetime members. Buy via Gumroad if you're not yet a member.
Watch the video because there are discount codes I show you in the video to get Coupon Code Maker for less than $30.  
Yes I use Coupon Code Maker myself. It's how I put products from Gumroad onto AppSumo Marketplace.
Build a simple function that deletes undone items in our checklist.
What is "&" doing in this formula? MONTH(A1&1)
Do you know why this is so cool? It can replace an entire vlookup chart I've been making for years.
In my video, I talk about how common problems are and how Google Sheets can help solve many of them in business. I discuss the different ways Google Sheets can be used, from simple to complex tasks, and plan to share five specific ways to use it effectively in future videos for better planning, tracking, and managing tasks.
Tactics to build different kinds of trackers you can sell as digital products.
I'm breaking down the landing page of titlecraft master nonfiction book titles. It's by two people I know on Twitter, and they send this to me and it's free, it's zero dollars
Tips, tricks, and techniques to turn templates into tools.
- Custom Menu
- Custom Functions
How to think about the context, psychological state, of your customer, so that you can sell them a solution.
Scope down from an existing problem to a sheet that still solves a juicy problem. If you can solve something in 10x less time, you win. Find out how lack of specificity is the #1 mistake. I’ll share with you a quick way to figure out if you’re really saving people time.

Displaying items 81-100 of 554 in total