Create a Dynamic Password Generator in Google Sheets

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-dynamic-password-generator-in-google-sheets/

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/google-sheets

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts. https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450

#GoogleSheets #spreadsheets #lambda #password ... https://www.youtube.com/watch?v=SRuOVBr7JCw