Advanced Google Sheets Formulas I use In Real Life!
There are a TON of formulas in Google Sheets but there are definitely specific formulas you gravitate to as you increase your skill level.
In this video I show several advanced formulas that I use in my day to day life as a Director of Revenue Operations. They're so good that I'm confident they'll benefit you in whichever position you work in as well. Best of all, they build off of each other!
Deep Dive Videos:
XLOOKUP
• Beginners Guide to XLOOKUP in Google Sheet...
IMPORTRANGE
• Become a MASTER of IMPORTRANGE including H...
QUERY
• Master the QUERY Function in Google Sheets...
ARRAYFORMULA
• Automate Anything in Google Sheets with th...
00:00 - Intro
00:27 - XLOOKUP
02:29 - IMPORTRANGE
03:29 - QUERY
04:12 - XLOOKUP from a different spreadsheet
05:43 - ARRAYFORMULA
07:09 - Embed formula into the header
08:04 - Chip/ Cell Reference Hack
09:26 - Recap
10:23 Outro