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

@MyOnlineTrainingHub

8 ай бұрын

Thanks so much 🥰

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

@MyOnlineTrainingHub

8 ай бұрын

It's my pleasure 😊

As always, full of very good ideas and examples Thanks

@MyOnlineTrainingHub

8 ай бұрын

Cheers, Ivan! Appreciate it 🙏😊

A truly interesting and useful video! Thank you

@MyOnlineTrainingHub

8 ай бұрын

Glad you enjoyed it! 🙏😊

This was awesome, thanks Mynda!

@MyOnlineTrainingHub

8 ай бұрын

Great to hear, Chris! 🙏😊

Thank you so much, my favorite teacher.

@MyOnlineTrainingHub

8 ай бұрын

Thank you! 😃

Very Informative. Thank you.

@MyOnlineTrainingHub

8 ай бұрын

Glad you enjoyed it!

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

8 ай бұрын

Wow, thank you! 🥰

Great video.Thanks Mynda

@MyOnlineTrainingHub

8 ай бұрын

Glad you liked it 🙏😊

Beautifully done

@MyOnlineTrainingHub

8 ай бұрын

Thank you so much 😀

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

@MyOnlineTrainingHub

8 ай бұрын

Awesome to hear 🙏

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

8 ай бұрын

Great to hear! Thanks for watching 🙏😊

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

@MyOnlineTrainingHub

8 ай бұрын

So nice of you 🙏😊

Simply the best

@MyOnlineTrainingHub

8 ай бұрын

Thanks so much, William! 🥰

Thank you 🙏

@MyOnlineTrainingHub

8 ай бұрын

You’re welcome 😊 Thanks for watching!

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

8 ай бұрын

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

Thank you

@MyOnlineTrainingHub

5 ай бұрын

Thank you for watching!

(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

7 ай бұрын

Glad to hear it was helpful 😊

Greetings from Egypt as always

@MyOnlineTrainingHub

8 ай бұрын

Thanks for watching 😊🙏

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

8 ай бұрын

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

8 ай бұрын

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

@theRealDavidn

8 ай бұрын

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

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

@MyOnlineTrainingHub

8 ай бұрын

Just like that 😁

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

@MyOnlineTrainingHub

8 ай бұрын

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

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

8 ай бұрын

Great to see you're trying it out. 😊

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

❤

💚

@MyOnlineTrainingHub

8 ай бұрын

🙏😊

Does your team hire excel workers?

@MyOnlineTrainingHub

8 ай бұрын

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

👍😎✊

@MyOnlineTrainingHub

8 ай бұрын

🙏😁👊

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

@MyOnlineTrainingHub

8 ай бұрын

Yep, that would certainly round it off 😁

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

@MyOnlineTrainingHub

8 ай бұрын

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