213Videos

See the full list of Videos to learn from

Track Every Edit (Almost)
Create a Log sheet in Google Sheets
Create a PR Agency From Scratch
Go from nothing to a working PR agency. Capture sites, and Send email via script
Find the Start date of the Current and End date of the Current Month

4

Figure Out Frequency
of ProductIds, or Names, or Emails
Basic CRM - Add a Powerful Script To Move Row Based on Status
Build a Thermometer for Savings Goals
Track your goals with a thermometer.
Restrict Access to a Cell if Another Cell is Blank
Data validation
Having trouble with ppl filling in cells before other cells?
Convert Your Bullet Journal To Google Sheets
How to Iterate Counting Blank Cells in Google Sheets
5 Ways to use IF() Formula to Create Magic in Your Sheets
Countdown Blank Row
Great for counting writing sessions, or tweets you're writing.
Create a Public Sheet and Private Sheet: Using ImportRange()
Stick around after the 1st portion of the video for bonus content.
Quadrant to List and List to Quadrant
Wrangle Scattered Data with Flatten()
Check out how to use flatten()
Get Twitter Handles Easily by changing URLS to @
Change Urls to @ using Substitute()
Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

17

6 Ways to Make Your Checkboxes Better
Data validation

18

2 Ways to Hide Data
How to Record Macros
Record a macro, to Insert a column every day.
How to Name Sheet Tabs
Organize tabs appropriately to decrease the friction that other users will have when reading or using your spreadsheets.

Displaying items 21-40 of 213 in total

Tags

Formulas