Create a Dynamic Password Generator in Google Sheets
Автор: Yagisanatode -Scott-
Загружено: 2022-11-13
Просмотров: 3026
In this tutorial, we create a password generator (random string generator) in Google Sheets using the LAMBDA function and two helper functions MAP and MAKEARRAY.
To the written tutorial and starter sheet!: https://yagisanatode.com/create-a-dyn...
00:00 What we will build.
01:14 The character string.
01:41 Find the length of the string.
01:59 Get a random character from the string.
03:43 Create a sequence matrix.
04:36 Maps random characters to the sequence.
06:47 Join the random array into a string.
07:59 Create an array of passwords.
10:11 Add the string to the formula.
11:06 Change values from other cells.
13:47 Convert dynamic formula to static text.
If you like the video, check out my website:
https://yagisanatode.com/
Here is the link to just Google Sheets tutorials:
https://yagisanatode.com/google-sheets/
Sign up for my course:
Google Sheets: Learn the Essentials with Three Detailed Projects
https://yagisanatode.teachable.com/p/...
Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts.
https://www.zazzle.com.au/collections...
#GoogleSheets #spreadsheets #lambda #password
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: