79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

49Tutorials

See the full list of Tutorials to learn from

Figure out how many days between two days, or how many days until a certain date. Or figure out how many days has it been since an event. Great for automatic email notifications of due dates, deadlines, etc.
Here are 5 advanced ways to manage projects inside of Google Sheets Manage Task Flow with IF() and a Checkbox Manage Data Inputs with IF() and ISBLANK() Create Quick Dashboard headers with: Transpose / Unique Create Pickers with Index / Match Email reports with Apps Script
Create a start time and end time and duration of that, with a little bit of Apps Script.
Google Sheets uses a scripting language called Google Apps Script, which is based on JavaScript. If you know how to code in JavaScript, you'll find Google Apps Script very familiar. To get started, open a new Google Sheet and go to the "Extensions" menu, then click "Apps Script".

4

Discover how to Save Your Sheets Every Week Automatically
Learn to set text wrap, overflow, or clip. Great for designing better text in your sheets.
Created a daily email with a motivational quote in the subject.
She has a cell, this D one, in which it says, for instance, another array or a row or column in this case, a column, a on sheet one where we're on and she's referencing that from another cell.
Create relational databases with index/match
The video tutorial is about tagging and creating comma-separated lists of tags for a list of titles. The tutorial demonstrates how to use data validation to create a drop-down menu of tags for each title and how to keep track of the number of videos or items in each tag category. The tutorial also shows how to create a comma-separated list of tags for each title using the JOIN function.
generate random numbers using Google Sheets. Fun ways to figure out how to get random characters. Great to use for creating IDs or Coupon Codes. Nice easy intro to some simple apps script.
Go from nothing to a working PR agency. Capture sites, and Send email via script
Track your goals with a thermometer.
Count different types of blank cells. Cells with nothing in them.
We're going to create some magic here. Some if magic, sprinkle a little magic on your sheets, you can use these formulas in existing sheets.
Stick around after the 1st portion of the video for bonus content.
We're going to like take some data, twist it and turn it into a different type of like look and feel. And then we're going to do the same thing in reverse.
Hide data with these simple tricks. Just using the IF() formula.

19

Free tutorial for finding Minimum and Maximum data points.

20

Displaying items 1-20 of 49 in total

Tags

Formulas