Скачать или смотреть 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_...
💻 PresenterMedia: https://shareasale.com/r.cfm?b=417324...

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/87584666...
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.... 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/sharo... 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:   / sharonsmithhr  
Twitter:   / 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:    • How To Create A Fillable Form In Microsoft...  

➤PowerPoint Tutorials for HR:    • PowerPoint Tutorials  

➤ Excel Tutorials for HR:    • Microsoft Excel Tutorials  

➤ Excel Quickies (Around 2 Minutes):    • Excel Tips & Tricks  

➤ Word Tutorials for HR:    • Microsoft Word Tutorials  

➤ Welcome | About Me:    • Плейлист