3 Advanced Tutorials for the IF() Formula in Google Sheets
3 advanced Google Sheets IF() formula tutorials. Improve your spreadsheet skills with password protection data, email notification.
Andrew Kamphey
Everything Aggravating about Apps Script
Been coding Apps Script for almost 10 years. Here's what I still find aggravating in Apps Script. The autocomplete is frustrating. Files don't save with errors. I lose my way in files. And the documentation is atrocious.
3 Advanced Ways to Use the INDEX Formula
Three video tutorials for advanced users. In these tutorials, I show you the different ways you can make use of the INDEX function to create fun and useful things with Google Sheets.
One Percent Better Every Day
Get better at making better Google Sheets every single day. I give you a few ways that you can improve every single day.
Basic concept is to Explore, Experiment, Apply, and Explain
Great Sheets! Seedtable Created an amazing Community Board
The normal intuition here is to create different tabs, but he knows like as a web designer that any amount of clicks you have the user do is going to lessen the amount of people. So he puts it all into one spreadsheet, one key, and you just have to scroll down.
Sheet Talking Episode 7: Oz Excel on Fire
Follow Oz on YouTube at @OzduSoleilDATA
and on LinkedIn: https://www.linkedin.com/in/ozdata/
Equal, Equal, Not Equal, Not Equal - How to Tell if Two Cells are the Same or Not The Same
I'm sharing with you two ways to use equal and two ways to use not equal or to get not equal or to get equals.