I took my first class in statistics in1962. Not so much fun then. Funny though how the professor (Frank German) never suggested Pivot Tables! LOL. Would have made life SO much easier!!
@@excelisfun tbh, this happens with me too from time to time lol, and it blew my mind each time, glad to know it wasn't only me 😄 but I know for sure that you are not my boss 😂
My teacher at college made me hate statistics but man, you made me fall in love with it instantly. Great way to the explanation as always. Thank you, Mike.
You are welcome, Fellow Teacher!!! I am the opposite, I had a teacher make me fall in love with statistics. Dr. Paine was his name, at College of Alameda in California : )
The group by feature is so essential anytime you have lists where one users may have multiple row of records but only variation in one column and you'd rather concatenate them into a single cell delimited by commas for example.
I have like 500 videos about stats. Have you not seen them? Here are 2 playlists: Stats: th-cam.com/play/PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj.html Analytics: th-cam.com/play/PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ.html But, Ivan, I can't belive you do not already know of them. Have you seen my 2 minute intro video about the all the free classes I have at TH-cam: th-cam.com/video/l1-1aVgFth4/w-d-xo.html
@@usmaniqbal1836 I am not sure what you mean. THE best web site to get help and back and forth dialog for an Excel solution is: mrexcel.com/forum. This is where I learned many of my tricks.
Hi Mike. As usual, AWESOME lesson full of both useful EXCEL and useful math/statistics tricks and information. Thanks for sharing and always making it fun :)) Thumbs up!! PS - Your new intro is GREAT! So modern and inviting. Nice work!!
Very cool, Mike, thanks so much for everything. All your videos are explained so good. Sure you get a 👍 for this from me, like always. All the best, stay healthy. Greetings from the amazing Rhineland/Germany! Dirk Sorry Mike, I forgot something to ask: is it possible that you show in any video the following (maybe you did already, but I didn't find anything): you have a row of numbers (no matter what) and you want build the average out of this with leaving out e.g. the 5 or 10 highest AND lowest values with a simple formula. 1000 thanks! 🙏🙏🙏
@@excelisfun Thanx, Mike, but that doesn't help at all because in this example you need your datas in a sorted range. Maybe you know it from ski jumping. There are always 5 referees giving notes for the execution of the jump, the highest and the lowest note are not taken into accout, only the three middle average. Or in golf game: you have played 20 rounds and only the 10 middle results will fix your handicap. You know what I mean?
In Excel, range B1:B100 there is many website links of zip files, so download the zip file of all those links together and keep them in the same folder, make a video for that
Sir.. Good day. I hope you can help me. I have a problem about getting Time & Motion of works in 8 hour.. Sample. I have 10 task in 8 hours. How can get the exact time/minutes of every task in 8 hours ? The example given: encode 12 Answer phone call 10 Errant 5 Email 9 Etc. How can i get the time of each task specifically with in 8 hour ? Thank you so much for kind of response.
Michael, my raw data is not a proper data set. there will be major headers under which some minor headers will be there and in middle some junk data will be there. Say for example my customer is trading in stocks. I want data in totallistic manner but he gives me data in scrip wise. major heading = buy under that there will be three sub headings like buy qty , buy rate per unit, total buy amount. My problem is its taking too much of time in transforming raw data into proper data set. Pls find a solution for me.
Heyo, stumbled upon this video from a while ago th-cam.com/video/enxF7oTH_eQ/w-d-xo.html with the face camera. I don't know if I missed the reason for no longer having it? Screen real estate is useful, some people enjoy seeing a teacher's face.
Pivot is Amazing
And Excel is Fun !
I agree PivotTables Rule!!!
@@yosra782 I agree with that too lol
You must be a teacher and if it is not, I must tell you that you have a vocation for that. Congratulations
Thank you : )
I took my first class in statistics in1962. Not so much fun then. Funny though how the professor (Frank German) never suggested Pivot Tables! LOL. Would have made life SO much easier!!
Wow!! 1962 : ) Stats was fun back then, but it was not until the PivotTable that stats became really fun : )
Dude you're a mind reader. Every time I get tasked to do something new at work you always drop a video on how to do that exact thing lol.
You got asked to do a joint probability table today?
Be careful, he might be your actual boss on a voice changer lol.
@@arkbeetlegaming That is not true lol
I am curious, what was the project you were working on that required a joint prob. table?
@@excelisfun tbh, this happens with me too from time to time lol, and it blew my mind each time, glad to know it wasn't only me 😄 but I know for sure that you are not my boss 😂
Liked and Thumbs Up Sirji...
And Also super liked your new Theme in the starting of the Vedio...
Glad you like the video!!! That cool Theme came from our Teammate, Geert : )
Well done!
Glad it helps!
Pivot is Fun, Thanks Mike.
I agree : ) : )
My teacher at college made me hate statistics but man, you made me fall in love with it instantly. Great way to the explanation as always. Thank you, Mike.
You are welcome, Fellow Teacher!!! I am the opposite, I had a teacher make me fall in love with statistics. Dr. Paine was his name, at College of Alameda in California : )
@@excelisfun Like teacher, like student. You had a great teacher, you became one great teacher. Thumbs up to both of you.
@@SyedMuzammilMahasanShahi Thanks : ) : )
@@excelisfun Welcome
Boom!Just Learned What Joint Probability Tables Are (I Had Never Heard Of Them) How To Use Them And Create Them!!!Happy Days...Thank You Mike :)
Niiiiiiice, in a booming way : ) : )
Again great! Just an other entertaining short lesson.
Glad you like the entertainExcel : )
Thank you for another great trick.
You are welcome for another trick, Le Dang Kha : ) : )
Thanks Mike. I wish I had access to all of this great information years ago. Thanks for sharing these tips and magic tricks.
You are welcome, Matt!!!
4:48 The "group by feature" in pivot table is really cool
Glad you like it : )
The group by feature is so essential anytime you have lists where one users may have multiple row of records but only variation in one column and you'd rather concatenate them into a single cell delimited by commas for example.
@@stewartgregerson4159 Good example!
Great video. It’s been so long since I last did stats and probability.
Pivots are the best, but so are your intros : ) : ) : ) : )
Mike, this is awesome!
Glad it was fun, Chris!!!!
Great tutorial Mike. Chapeau!!!
Long live the statistics. More videos on statistics please !!!
I have like 500 videos about stats. Have you not seen them? Here are 2 playlists:
Stats: th-cam.com/play/PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj.html
Analytics: th-cam.com/play/PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ.html
But, Ivan, I can't belive you do not already know of them. Have you seen my 2 minute intro video about the all the free classes I have at TH-cam: th-cam.com/video/l1-1aVgFth4/w-d-xo.html
@@excelisfun Thank you Mike for the link. Too much information. Sorry. I'll see the statistical videos.
Thank you Mike. Good Tips
You are welcome!
Thanks Mike :) :)
Thanks, O Formula Guy : )
Super sir👍
Glad it is super for you, Kamlesh!!!
I love new intro :) Thumbs up!!!
Thanks, Teammate : )
5:34 "you got to be kidding me" 😂😂😂
: ) : ) : ) : ) LOL
Sick intro! Thank you for the video!
You are welcome for the videos : ) : ) And sick intro from Geert : )
Amazing
Glad it is amazing : ) : )
Great Mike
Thanks, usman : ) : )
@@excelisfun Mike, one question for you
@@usmaniqbal1836 What is your one question?
@@excelisfun Sr, plz make Salary Sheet for School format
@@usmaniqbal1836 I am not sure what you mean. THE best web site to get help and back and forth dialog for an Excel solution is: mrexcel.com/forum. This is where I learned many of my tricks.
What's the probability that this was enjoyable given that it was useful? 100%, don't cha know!
Thanks for this cool phrase, Teammate DRSteele: "don't cha know!" : ) : ) : ) : )
Super useful! Thanks :-)
You are welcome!
Hi Mike. As usual, AWESOME lesson full of both useful EXCEL and useful math/statistics tricks and information. Thanks for sharing and always making it fun :)) Thumbs up!!
PS - Your new intro is GREAT! So modern and inviting. Nice work!!
You are welcome, Wayne!!!
Very cool, Mike, thanks so much for everything. All your videos are explained so good. Sure you get a 👍 for this from me, like always. All the best, stay healthy. Greetings from the amazing Rhineland/Germany! Dirk
Sorry Mike, I forgot something to ask: is it possible that you show in any video the following (maybe you did already, but I didn't find anything): you have a row of numbers (no matter what) and you want build the average out of this with leaving out e.g. the 5 or 10 highest AND lowest values with a simple formula. 1000 thanks! 🙏🙏🙏
Maybe this stats video I posted back in 2009: th-cam.com/video/K6mil72rNo8/w-d-xo.html
@@excelisfun Thanx, Mike, but that doesn't help at all because in this example you need your datas in a sorted range. Maybe you know it from ski jumping. There are always 5 referees giving notes for the execution of the jump, the highest and the lowest note are not taken into accout, only the three middle average. Or in golf game: you have played 20 rounds and only the 10 middle results will fix your handicap. You know what I mean?
@@DirkOutdoor Maybe:
Formula that ignores ties: =AVERAGEIFS(E12:Y12,E12:Y12,">"&SMALL(E12:Y12,5),E12:Y12,"
@@excelisfun 😎 Thanks so much 🙏
Hi, if you have LET you can try also this one
=LET(a,B2:B101,x,10,u,UNIQUE(a),sx,SMALL(u,x),lx,LARGE(u,x),rs,AVERAGEIFS(a,a,">"&sx,a,"
Amazing😘😍
Glad it is amazing for you : )
In Excel, range B1:B100 there is many website links of zip files, so download the zip file of all those links together and keep them in the same folder, make a video for that
Sir.. Good day. I hope you can help me. I have a problem about getting Time & Motion of works in 8 hour..
Sample. I have 10 task in 8 hours. How can get the exact time/minutes of every task in 8 hours ?
The example given:
encode 12
Answer phone call 10
Errant 5
Email 9
Etc.
How can i get the time of each task specifically with in 8 hour ? Thank you so much for kind of response.
Michael, my raw data is not a proper data set. there will be major headers under which some minor headers will be there and in middle some junk data will be there. Say for example my customer is trading in stocks. I want data in totallistic manner but he gives me data in scrip wise. major heading = buy under that there will be three sub headings like buy qty , buy rate per unit, total buy amount. My problem is its taking too much of time in transforming raw data into proper data set. Pls find a solution for me.
Try this great Excel question site for back and forth dialog to get Excel solutions: mrexcel.com/forum
Heyo, stumbled upon this video from a while ago th-cam.com/video/enxF7oTH_eQ/w-d-xo.html with the face camera. I don't know if I missed the reason for no longer having it? Screen real estate is useful, some people enjoy seeing a teacher's face.
Sorry, my english is not very good
Your English is just fine.
Thanks Mike :-)
You are welcome, Mohamed!!!!