Google Sheet Side Quests

0:00 Some Google Sheet side quests you can go on while you're learning Google Sheets. Self references . You might already use this already. Relative and absolute . One changes, one doesn't. I'll let you figure out which one. Data validation . You probably already use something like drop downs and checkboxes, but you can also put dates into cells and have a little date picker. Basic formulas. You probably already use these, but make sure you try sum if and count if. And the if formula sounds easy. It can do really cool stuff. Advanced formulas like query are an entirely other language. Also, regular expressions is really, really awesome inside of Google Sheets. And one advanced formula that actually is super useful is array formula. Make sure you use that. Once you start actually figuring out a lot of the basic formulas, you can combine them in really magical ways. Like if blank is literal magic, index match replaces

0:47 VLOOKUP . You might already be using conditional formatting , but make sure you're doing custom formulas here. Let's get into real magic appcript automations. Don't be scared of it. It's just JavaScript. Make some custom functions . Make functions that just work the way you want them to work and then you can name them and it's just in your spreadsheet and you can use it. Simple triggers like onedit and on open things that you just want to happen every time you open a sheet. It just does. Then you can also install triggers. It can be time triggers when forms are submitted. Really, really powerful stuff. Some of the most powerful things are just a couple clicks away like advanced Google services, Gmail, calendar, advanced drive. You can connect your Google sheet to other things without add-ons, without extensions, just clicking services, adding Gmail, calendar, drive, and just

1:35 accessing these things from your spreadsheet .