I ❤ the way you explain the contents, straight forward and hit the point with good examples.
@MyOnlineTrainingHub10 ай бұрын
Thanks so much 🥰
@awesh198610 ай бұрын
Hi Mynda, your videos are awesome and very concise very precise they great to learn from. Yo one of my favourite youtubers when it comes to Excel along with Leila Gharani. Both of you have amazing styles of teaching and a great with what you teach. Always look forward to all your videos that keep coming.
@MyOnlineTrainingHub10 ай бұрын
Wow, thank you! 🥰
@aureliensimon868510 ай бұрын
Thank you so much Mynda for sharing this new video with us.
@MyOnlineTrainingHub10 ай бұрын
It's my pleasure 😊
@ziggle31410 ай бұрын
Nice work Mynda. I had not thought about using pivot tables for descriptive stats. I am excited for Python to come to my Excel version.
@MyOnlineTrainingHub10 ай бұрын
Great to hear! Thanks for watching 🙏😊
@joloblog98349 ай бұрын
(Again) Thank you for this training Mynda, it opens new possibilities for me. Like, I have a dataset of 40,000 deficiencies (not financial data) per year divided in about 550 descriptions. When I want to make a dashboard about it over several Years, I soon will run into limitations of Excel, too large files. With this training, I can make a selection first about fewer deficiencies per description. (I use Office 2021 offline, do not trust 365 with my data and privacy)
@MyOnlineTrainingHub9 ай бұрын
Glad to hear it was helpful 😊
@patapo47010 ай бұрын
Thank you so much, my favorite teacher.
@MyOnlineTrainingHub10 ай бұрын
Thank you! 😃
@barttitulaerexcelbart940010 ай бұрын
Thanks Mynda. Very complete. However I also would have enjoyed the FREQUENCY fuction. And other old school formula's like MIN, MAX, SKEW. All of theme are there except the simple RANGE....😉One drawback of the Pivot table grouping is that all the bins have to be the same size. I have seen video's why the build in Historgram (new 365) is not appreciated.
@MyOnlineTrainingHub10 ай бұрын
Great suggestions, Bart! A 4th way 😁 My understanding of bins is that they should all be the same size otherwise they are not comparable at a glance, but I'm not a statistician 😉
@barttitulaerexcelbart940010 ай бұрын
@@MyOnlineTrainingHub It was a long time ago, and I checked the co-pilot....You can have different bin sizes....
@theRealDavidn10 ай бұрын
You can do FREQUENCY, SKEW KURT LINEST while nesting in an if. Works awesomely
@mangal2cool10 ай бұрын
Thank you 🙏
@MyOnlineTrainingHub10 ай бұрын
You’re welcome 😊 Thanks for watching!
@Flylikea10 ай бұрын
This is a very useful and compact video. I have worked my way through all three ways of generating descriptive statistics in excel and this video is truly a brilliant gem for anyone starting work on DS (this is also why starting in excel is imho better). Clarification: I used Python for DS but not from within excel. Nevertheless, imo seeing DS first in excel is better than rushing towards SPSS, SAS, or code.
@MyOnlineTrainingHub10 ай бұрын
Awesome to hear 🙏😊 great point, Excel is essential for data analysts starting out.
@ivanbork417510 ай бұрын
As always, full of very good ideas and examples Thanks
@MyOnlineTrainingHub10 ай бұрын
Cheers, Ivan! Appreciate it 🙏😊
@giulianopierucci290310 ай бұрын
A truly interesting and useful video! Thank you
@MyOnlineTrainingHub10 ай бұрын
Glad you enjoyed it! 🙏😊
@ahmedshalaby934310 ай бұрын
Greetings from Egypt as always
@MyOnlineTrainingHub10 ай бұрын
Thanks for watching 😊🙏
@mohammadsadeghenayatyrad67317 ай бұрын
Thank you
@MyOnlineTrainingHub7 ай бұрын
Thank you for watching!
@JennTheWriter10 ай бұрын
OMG! That is just so much fun to watch. Thank you very much! :)
@MyOnlineTrainingHub10 ай бұрын
Awesome to hear 🙏
@chrism903710 ай бұрын
This was awesome, thanks Mynda!
@MyOnlineTrainingHub10 ай бұрын
Great to hear, Chris! 🙏😊
@joshuamanampiu648910 ай бұрын
Very Informative. Thank you.
@MyOnlineTrainingHub10 ай бұрын
Glad you enjoyed it!
@IamTheReaper91110 ай бұрын
Beautifully done
@MyOnlineTrainingHub10 ай бұрын
Thank you so much 😀
@jerrydellasala764310 ай бұрын
I'm on the Beta Insider edition (Version 2312 Build 16.0.17031.20000), and with your sample when I selected $C$3:$C$63 as my input range, I got the error message "Input range contains non-numeric data". Changing the range to $C$4:$C$63 worked giving the same results as your example. You said to "including the heading", but that may not work any longer! NEVER MIND! i DIDN'T CHECK "LABELS IN FIRST ROW". DUH!
@MyOnlineTrainingHub10 ай бұрын
Great to see you're trying it out. 😊
@tayachaney930410 ай бұрын
Sorry Mynda could you refer to the tutoring link about that "upper limit + " that you already have in 2.34 in the video?
@MyOnlineTrainingHub10 ай бұрын
The upper limit is hard keyed in the table, so I'm not sure what you're asking. You can download the file from the link in the video description. If that doesn't help, please reach out via our forum or email via our website so I can help you further as I won't see follow up replies here due to the volume of comments: www.myonlinetraininghub.com/excel-forum
@spilledgraphics10 ай бұрын
Mynda is back with Python in Excel = 🔥🤘! (minute 8:05) nice!
@MyOnlineTrainingHub10 ай бұрын
Just like that 😁
@arokiarajan123010 ай бұрын
your content is great and interesting .... Keep rocking.
@MyOnlineTrainingHub10 ай бұрын
So nice of you 🙏😊
@williamtorres971710 ай бұрын
Simply the best
@MyOnlineTrainingHub10 ай бұрын
Thanks so much, William! 🥰
@kebincui10 ай бұрын
Great video.Thanks Mynda
@MyOnlineTrainingHub10 ай бұрын
Glad you liked it 🙏😊
@nicaciojimenezdiaz4743 ай бұрын
How can I add the frecuency table function?
@MyOnlineTrainingHub3 ай бұрын
It's part of the Data Analysis ToolPak. You can install it as explained here: www.myonlinetraininghub.com/descriptive-statistics-in-excel#pak
@mohammadsadeghenayatyrad67317 ай бұрын
❤
@tihomirhristov7710 ай бұрын
💚
@MyOnlineTrainingHub10 ай бұрын
🙏😊
@JJ_TheGreat10 ай бұрын
9:58 The only thing left to work with Excel is implementing R!!!
@MyOnlineTrainingHub10 ай бұрын
Yep, that would certainly round it off 😁
@keylanoslokj180610 ай бұрын
Does your team hire excel workers?
@MyOnlineTrainingHub10 ай бұрын
Not sure what you mean. Please reach out via email. Contact details are on our website: MyOnlineTrainingHub.com
@steven.h062910 ай бұрын
👍😎✊
@MyOnlineTrainingHub10 ай бұрын
🙏😁👊
@teo_ke10 ай бұрын
Hi there, I have an array and want to return me an array without duplicate values. what formula we should try ?
@MyOnlineTrainingHub10 ай бұрын
You can use the UNIQUE function: www.myonlinetraininghub.com/excel-functions/excel-unique-function