Excel Magic Trick #19: Randomly Generate Words
Loading...
Loading...
11,140
Loading...
Link to this comment:
Share to:
Uploader Comments (ExcelIsFun)
Video Responses
This video is a response to Making a Gantt Chart with Excel
see all
All Comments (10)
-
@ExcelIsFun Cheers!
-
This was a very big help to me for my Management 600 class!
-
Thank you very very much, it really works. Although I still don't understand how the last part functions, I'm sure I'll find it as I go through your videos. Thanks
-
Dear xxsweetGxx,
Cool!!! That would be great! We could make cartoons about how to use Excel. I would love to do the voice for that! We could also have Excel Superheroes that come in and save the day!!
--ExcelIsFun
-
Well that's not very nice of them because I like your voice its so much more exciting than other people who have tutorials like this and have half dead/boring voices atleast your enthusiastic the whole time :) Plus I think your voice would be great in a cartoon !
Loading...
- 1:43
Excel Magic Trick #20: Lightening Fast Copy Trick!by ExcelIsFun22,048 views
- 4:34
Excel Magic Trick #18: Randomly Generate Lettersby ExcelIsFun10,549 views
- 8:00
Excel Magic Trick #21: BINOMDIST function for Probabilityby ExcelIsFun18,230 views
- 1:59
Excel Magic Trick #8: Text To Columnby ExcelIsFun30,432 views
- 4:13
How to transfer data from internet into Excelby jksynergyworks16,618 views
- 7:34
Using AND, OR, IF Funtions in Excelby excelteacher22,028 views
- 1:54
Excel Magic Trick #7: Clear Formatting Only!by ExcelIsFun21,387 views
- 4:44
Excel Magic Trick #15: SUM or COUNT Above Some Limit!by ExcelIsFun15,967 views
- 3:51
Excel Array Formula Series #6: Statistics Bayes' Theoremby ExcelIsFun11,738 views
- 6:03
Excel Magic Trick #151: DATEDIF function (between two dates)by ExcelIsFun21,280 views
- 4:48
Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functionsby ExcelIsFun48,097 views
- 4:25
Excel Magic Trick #106: Gantt Chart for Daily Scheduleby ExcelIsFun41,767 views
- 3:42
Excel Magic Trick #169: Randomly Select Employee From Listby ExcelIsFun3,233 views
- 3:31
Excel Magic Trick 302: Randomly Select Names No Repeatsby ExcelIsFun5,083 views
- 4:54
Excel Magic Trick #128: VLOOKUP Categoriesby ExcelIsFun8,913 views
- 2:26
Excel Magic Trick 375: Keyboard Shortcut For Copying Columnsby ExcelIsFun3,517 views
- 5:18
Excel Magic Trick #94: VLOOKUP Into Web Queryby ExcelIsFun12,770 views
- 2:54
Excel Magic Trick #92: Two Chart Types In One Chart!by ExcelIsFun21,472 views
- 7:36
Excel Magic Trick #22: NORMDIST function for Probabilityby ExcelIsFun28,209 views
- 4:39
Excel Magic Trick #145 p2 MODE IFby ExcelIsFun4,330 views
@ExcelIsFun Hi, thanks a lot for you videos. They have been of great use to me. Amazing stuff.
Could you tell me the shortcut key for zooming , i saw you doing so at 1:05
Many Thanks
LadyDboz 6 months ago
@LadyDboz , Ctrl and then roll wheel on Mouse.
ExcelIsFun 6 months ago
Hey I really like your videos. Must say it's a nice and noble thing your doing :D
I have one question about his video. I've got a similar problem - Let's say I have about 800 names in column A (from A1 to A800, naturally). Now I need one of these names to be randomly selected. How do I do that quickly?
there is one way: =CHOOSE(RANDBETWEEN(1;800);A1;A2;A3;A4;etc.,;a800), but it would take me a whole day to do it that way.
nemanjanv7 1 year ago
Try:
=INDEX($A$1:$A$800,INT(RAND()*800+1))
ExcelIsFun 1 year ago