How to Randomly Select a Winner for a Prize Giveaway Using Excel

HOW TO RANDOMLY SELECT A WINNER FOR A PRIZE GIVEAWAY // See two different ways on how to make a random selection from a list in Excel. This is a great way to select a prize winner for a giveaway or, or select an employee of the month, or randomly select volunteers from a list. You can do this by using the RANDBETWEEN function in excel as a random number generator. You can also use the INDEX function with RANDBETWEEN to return an actual name from the list. _________ VIDEO TIME STAMPS - JUMP TO 00:00 Introduction 00:10 How to Get a List of Names in Excel 00:38 How to Set Up Random Number Generator in Excel using RANDBETWEEN Function 01:20 RANDBETWEEN is a Volatile Function that Automatically Recalculates 01:40 How to Enter RANDBETWEEN Function 02:56 How to Recalculate RANDBETWEEN Function in Excel 03:20 How to Randomly Select a Name From a List in Excel using INDEX and RANDBETWEEN 04:51 Promo How To Randomly Select Multiple Winners for a Prize Giveaway __________ RESOURCES & GEAR 🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!) ✦ Screen Recording Software: https://techsmith.z6rjha.net/NZG5b ✦ Green Screen: https://amzn.to/2DnHsY2 ✦ Camera: https://amzn.to/39KvpQA ✦ Live Stream Tool: https://amzn.to/2VFJyID ✏️ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog 💻 PresenterMedia: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack= Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel! __________ TEMPLATES Check out my helpful list of templates available for purchase: https://www.etsy.com/listing/875846662/employee-engagement-survey-ms-excel?ref=listing_published_alert Thank you for supporting my channel! (Scroll down for a link to my free resources) __________ NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel! __________ FREE DOWNLOADS: ✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals. __________ CONNECT WITH ME: Visit my website: https://www.sharonsmithhr.com for more information, tools and resources. LinkedIn: https://www.linkedin.com/in/sharonsmithhr Twitter: https://twitter.com/SharonSmithHR __________ KEYWORDS: #MSExcel, random number generator, how to set up random number generator in Excel, how to select a random winner for a prize giveaway, how to select an employee of the month, auto select name from a list in Excel, Excel Tutorial, Excel Functions, How To, advanced excel tricks, Excel tips and tricks, Microsoft 365, learn Excel, prize, giveaway, Sharon Smith HR, @SharonSmithHR __________ PLAYLISTS: ➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv ➤PowerPoint Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM ➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90 ➤ Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW ➤ Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45 ➤ Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR