Excel Data Analysis - From Beginner to Pro with Descriptive Statistics

[@z.719]

I ❤ the way you explain the contents, straight forward and hit the point with good examples.

[@MyOnlineTrainingHub]

Thanks so much 🥰

[@aureliensimon8685]

Thank you so much Mynda for sharing this new video with us.

[@MyOnlineTrainingHub]

It's my pleasure 😊

[@awesh1986]

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.

[@MyOnlineTrainingHub]

Wow, thank you! 🥰

[@joloblog9834]

(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)

[@MyOnlineTrainingHub]

Glad to hear it was helpful 😊

[@ziggle314]

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.

[@MyOnlineTrainingHub]

Great to hear! Thanks for watching 🙏😊

[@ivanbork4175]

As always, full of very good ideas and examples Thanks

[@MyOnlineTrainingHub]

Cheers, Ivan! Appreciate it 🙏😊

[@chrism9037]

This was awesome, thanks Mynda!

[@MyOnlineTrainingHub]

Great to hear, Chris! 🙏😊

[@Flylikea]

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.

[@MyOnlineTrainingHub]

Awesome to hear 🙏😊 great point, Excel is essential for data analysts starting out.

[@patapo470]

Thank you so much, my favorite teacher.

[@MyOnlineTrainingHub]

Thank you! 😃

[@giulianopierucci2903]

A truly interesting and useful video! Thank you

[@MyOnlineTrainingHub]

Glad you enjoyed it! 🙏😊

[@JennTheWriter]

OMG! That is just so much fun to watch. Thank you very much! :)

[@MyOnlineTrainingHub]

Awesome to hear 🙏

[@ahmedshalaby9343]

Greetings from Egypt as always

[@MyOnlineTrainingHub]

Thanks for watching 😊🙏

[@kebincui]

Great video.Thanks Mynda

[@MyOnlineTrainingHub]

Glad you liked it 🙏😊

[@joshuamanampiu6489]

Very Informative. Thank you.

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@IamTheReaper911]

Beautifully done

[@MyOnlineTrainingHub]

Thank you so much 😀

[@arokiarajan1230]

your content is great and interesting .... Keep rocking.

[@MyOnlineTrainingHub]

So nice of you 🙏😊

[@barttitulaerexcelbart9400]

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.

[@MyOnlineTrainingHub]

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 😉

[@barttitulaerexcelbart9400]

@@MyOnlineTrainingHub It was a long time ago, and I checked the co-pilot....You can have different bin sizes....

[@theRealDavidn]

You can do FREQUENCY, SKEW KURT LINEST while nesting in an if. Works awesomely

[@spilledgraphics]

Mynda is back with Python in Excel = 🔥🤘! (minute 8:05) nice!

[@MyOnlineTrainingHub]

Just like that 😁

[@mohammadsadeghenayatyrad6731]

Thank you

[@MyOnlineTrainingHub]

Thank you for watching!

[@jerrydellasala7643]

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!

[@MyOnlineTrainingHub]

Great to see you're trying it out. 😊

[@mangal2cool]

Thank you 🙏

[@MyOnlineTrainingHub]

You’re welcome 😊 Thanks for watching!

[@tayachaney9304]

Sorry Mynda could you refer to the tutoring link about that "upper limit + " that you already have in 2.34 in the video?

[@MyOnlineTrainingHub]

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

[@williamtorres9717]

Simply the best

[@MyOnlineTrainingHub]

Thanks so much, William! 🥰

[@JJ_TheGreat]

9:58 The only thing left to work with Excel is implementing R!!!

[@MyOnlineTrainingHub]

Yep, that would certainly round it off 😁

[@nicaciojimenezdiaz474]

How can I add the frecuency table function?

[@MyOnlineTrainingHub]

It's part of the Data Analysis ToolPak. You can install it as explained here: www.myonlinetraininghub.com/descriptive-statistics-in-excel#pak

[@mohammadsadeghenayatyrad6731]

❤

[@keylanoslokj1806]

Does your team hire excel workers?

[@MyOnlineTrainingHub]

Not sure what you mean. Please reach out via email. Contact details are on our website: MyOnlineTrainingHub.com

[@tihomirhristov77]

💚

[@MyOnlineTrainingHub]

🙏😊

[@steven.h0629]

👍😎✊

[@MyOnlineTrainingHub]

🙏😁👊

[@teo_ke]

Hi there, I have an array and want to return me an array without duplicate values. what formula we should try ?

[@MyOnlineTrainingHub]

You can use the UNIQUE function: www.myonlinetraininghub.com/excel-functions/excel-unique-function