Excel Randomizing Tricks

by excelisfun · 25 videos

Total watch time

3h 16m

at speed · exactly 3 hours, 15 minutes, 35 seconds at 1×

3h 15m 35s
1.25×2h 36m 28s
1.5×2h 10m 23s
1.75×1h 51m 46s
1h 37m 48s
Average video7m 49s
Longest23m 45s
Shortest2m 30s
Compare Open on YouTube JSON

Plan to finish

About 4 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 4 days. Turn on JavaScript to plan around your week.

Videos (25)

3h 16m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Excel Magic Trick #17: Randomly Generate Whole Numbers 4:12 2008-03-05
2 Excel Magic Trick #18: Randomly Generate Letters 4:35 2008-03-05
3 Excel Magic Trick #19: Randomly Generate Words 3:35 2008-03-05
4 Basic Excel Business Analytics #69: Monte Carlo Simulation for Baseball World Series 9:42 2015-12-30
5 Basic Excel Business Analytics #68: Monte Carlo Simulation Histogram for Construction Project Length 15:56 2015-12-28
6 Basic Excel Business Analytics #67: Monte Carlo Simulation for Marketing Analysis Binomial Variable 11:46 2015-12-26
7 Basic Excel Business Analytics #66: Monte Carlo Simulation for New Product, 3 Uncertain Variables 18:33 2015-12-25
8 Basic Excel Business Analytics #64: Introduction To Monte Carlo Simulation In Excel 23:45 2015-12-23
9 Basic Excel Business Analytics #65: Create Random Variables: Custom, Binomial, Uniform, Normal 22:42 2015-12-24
10 Excel Magic Trick #16: Randomly Generate Numbers (0-1) 2:34 2008-03-05
11 Mr Excel & excelisfun Trick 11: Randomly Select A Name 5:12 2009-05-21
12 Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions 6:24 2009-03-06
13 Excel Magic Trick 373: Randomize with No Repeats (Numbers or Words) 5:19 2009-08-27
14 Excel Magic Trick 302: Randomly Select Names No Repeats 3:31 2009-04-13
15 Excel Magic Trick #169: Randomly Select Employee From List 3:42 2008-12-30
16 Excel Magic Trick 385: Generate Random Letters without RANDBETWEEN function 3:04 2009-09-10
17 Excel Magic Trick 392: CHOOSE function Randomly Generate 1, 0 or Blank 3:24 2009-09-17
18 Excel 2010 Statistics 67: Formula To Extract Simple Random Sample 8:29 2012-02-04
19 Excel 2010 Statistics 66: Simple Random Sample Using RAND Function, Sort and Copy Paste 6:47 2012-02-04
20 Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN 4:03 2013-07-13
21 Excel Magic Trick 1145: Create Random Data Set with Formulas: 4 Unusual Formulas 14:02 2014-10-24
22 Excel Magic Trick 1295: TEXTJOIN & INDEX Function to create Random Description Codes 3:46 2016-03-21
23 Data Set Random Sales Numbers: RANDBETWEEN or NORM.INV Function? Excel Short 68 2:30 2025-03-10
24 Create Random Dates with Excel Functions. Excel Magic Trick 1894 3:22 2025-06-17
25 Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897 4:40 2025-06-20

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 3h 16m · 25 videos

Markdown
[![Watch time: 3h 16m · 25 videos](https://playlistduration.com/badge/playlist/PL5AC7ABF2BE0C8C20.svg)](https://playlistduration.com/playlist/PL5AC7ABF2BE0C8C20)
HTML
<a href="https://playlistduration.com/playlist/PL5AC7ABF2BE0C8C20"><img src="https://playlistduration.com/badge/playlist/PL5AC7ABF2BE0C8C20.svg" alt="Watch time: 3h 16m · 25 videos" width="203" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PL5AC7ABF2BE0C8C20 returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.