Named Functions, LAMBDA, MAP, REDUCE and More - New Google Sheets Functions
@yagisanatode comes on the channel today to show us how to use a new batch of advanced functions in Google Sheets.
Scott's Related Videos:
Calculate the duration between two times in a day in Google Sheets as a number:
• Calculate the duration between two ti...
Create a Dynamic Password Generator in Google Sheets
• Create a Dynamic Password Generator i...
Scott's website: https://yagisanatode.com/
Timestamps:
0:00 Intro
2:34 Named Function (Adam's version)
8:04 LAMBDA Function
8:54 LAMBDA Helper Functions
14:37 MAP Function
19:16 Named Functions (Scott's version)
23:48 REDUCE Function
30:11 SCAN Function
33:16 Random String Generator
33:39 Named Functions Pack
#googlesheets #spreadsheet #workspace