Members-only tutorial
Watch the video and get the practice sheet with membership.
About this Tutorial
Sheet Resources
Video Transcript
<div>0:00 Welcome everyone. This is SheetFools. So, I have created 24 automations that you can use to prank your fellow spreadsheet Learn about spreadsheets and how they can enhance your data management. Opens in new tab users, your colleagues, your your boss, your friends, family, whoever's using spreadsheets.<br>0:18 I have them all here, listed here. Ah, they go from on edit like if you're just typing in the word Microsoft.<br>0:24 Excel Discover the XLSX format and its features for spreadsheet files. Opens in new tab , you can change it to Google Sheets as they enter it. Ah, you can say thank you on every time someone edits a cell.<br>0:34 You can add a Christmas mode, you can add rainbow columns automatically.
All of these automations have different types of triggers.<br>0:42 Some are on open, like making the bigger font size, or bolding a random row, or floating in the header Understand the importance of headers in organizing your spreadsheet data. Opens in new tab upside down.<br>0:50 You can see there's a little bit of tilt up here, uhm, and there every day the, ah, tilt gets a little bit more.<br>0:57 See, this, ah, row 21 text tilts one degree every day if you set this.
Well, how do you get these?<br>1:05 Uhm, just go to bettersheets.co at bettersheets.co slash sheetfools you can get this exact sheet and it's a totally free download.<br>1:25 I know what you're watching here is for members only, uhm, it is for members and everyone else, but you're getting it early.<br>1:33 Right now as I'm recording this, it's March 26th, ah, I've already set it sent an email out to all members saying, Hey, go get this right now.<br>1:40 Um, and this is actually launching on April 1st, 2025 on April 21st, 2025, each one of these YouTube videos are going to be, uh, released.
They're already here. Once you get the actual, um, sheet, how do you actually use this?<br>2:06 Go up to extensions, Apps Script Explore Google Apps Script for automating tasks in Google Sheets. Opens in new tab . And once it's loaded here, I have a little bit of, uh, explanation. There's like a rickroll here, never going to give you up.<br>2:17 Nope, it's not a rickroll. Uh, but every single one of the automations that are in those YouTube videos are here. So here's a function Get to know functions and how they can simplify calculations in spreadsheets. Opens in new tab on open already built in and added a menu for Christmas mode.<br>2:33 But you can also just add any of the automations.
If you add the name of the automation and parentheses here, like this tilt.<br>2:41 So what's tilt go to function Get to know functions and how they can simplify calculations in spreadsheets. Opens in new tab tilt. That's right here. That will rotate every single day or whenever this is required.<br>2:48 The header Understand the importance of headers in organizing your spreadsheet data. Opens in new tab will rotate one degree. Here's increase decimal places. Here's flip header Understand the importance of headers in organizing your spreadsheet data. Opens in new tab upside down. It sets the rotation to 180 degrees.<br>2:58 Increase row height Find out how to adjust row height for better visibility in your sheets. Opens in new tab . Change the active tab. Change the font of the header Understand the importance of headers in organizing your spreadsheet data. Opens in new tab to Comic Sans. Scramble the name, which is actually pretty crazy.<br>3:09 It makes it look like you're having a stroke almost. A bold, a random row.
Every single one of these automations is here.<br>3:16 All 24 of them. So you can go find out what the name is here. If you're interested in, like, coffee time, just go to extensions and go to coffee time.<br>3:26 There it is, coffee time. Uh, and it just literally will say at some specific time that you set, uh, hey, it's coffee time.<br>3:34 That's it. That's the whole thing. if you type in the word urgent, it'll set it red. Uh, this one needs the on edit function Get to know functions and how they can simplify calculations in spreadsheets. Opens in new tab or on edit trigger Learn about triggers and how they can automate actions in your spreadsheets. Opens in new tab .<br>3:45 Some of these need a trigger Learn about triggers and how they can automate actions in your spreadsheets. Opens in new tab . Some of these you just put inside of on open or on edit.
Uh, some of them you do want to, uh, actually we don't want to put that tilt.<br>3:56 But you can always, uh, comment Discover how to use comments to collaborate effectively in Google Sheets. Opens in new tab things out with those slashes. If you haven't already, if you any questions, go to your email and reply to the email, uh, that I sent out to all members and everyone.<br>4:11 And let me know if you have any questions about these, uh, pranks. That's about it. I'm launching this April 1st publicly.<br>4:20 It's called Cheat Fools. I hope you enjoy getting all of these functions Dive into various functions available in spreadsheets for data manipulation. Opens in new tab early.
And you can get it, again, at bettercheats.co slash cheatfools and all of the YouTube videos, they're all about 2 to 5 minutes long. All of them will be dropping, uh, literally on April 1st, one every hour.<br>4:35 Enjoy!</div>
Topics