02:52 Video Topic for chapter 2 list is not correct. The video shows 5 to 9 videos, in this chapter 2 there are only 5 - 8 videos. Video 9 is in chapter 3.
I searched for multiply days for some advanced tutorials but at last, found some videos in my desired way (statistics and excel both). Thanks, I will recommend your channel to others.
Hi Mike. Another super awesome Excel Stats video!! Thanks for the great review and many reminders of best practices. One tip I can add.. in the Pareto chart, you can also remove the display of each axis by first selecting the axis and then CTRL+1 for Format Axis >> Labels >> Label Position >> None. The axis disappears from view.. it becomes a thin vertical line object on the side of the chart. It is the same effect as formatting with ;;;. Just another way to get there. As always, thanks for the great lesson, tips, tricks and an all around fun time with Excel Pivot Tables and Charts :)) Thumbs up!!
That is epic. That is consequential. I had no idea. for 20 years I have been using ;;;. From a teaching perspective, it is no fun to have to teach ;;;. Now I have been liberated by you Wayne!!!! ******* Selecting the axis and then CTRL+1 for Format Axis >> Labels >> Label Position >> None I can't wait to show the "Wayne" method in the next video!!!!! Go Team : )
The Pareto chart was new to me and will be a great tool to add to the work I do. Love continuing to learn with your videos and looking forward to the rest of the series.
That sort by functionality in a pivot table is very handy! I didn’t know/remember it was there. Manual sorting can be fun for categorical frequency distributions: you can also do that by drag and drop in the pivot table. Great video and lesson, as always! :-)
Thank you Mike for the great stats and visualization video. So when I see catagorical data I should be targeting the Frequency, % Frequency, Relative Frequency with some visualization. I also enjoy when you get into the options dialog box, so many options in there, and it helps that you show that.
@@excelisfun yes! I had to come back and watch the video completely. Good call on the research about pie charts. They're a great to start the conversation but that's it. Bars and columns are more effective due to their pre-attentive atributes. Minute 6:48 was pure gooold ! wow thanks Mike for teaching this 👌👌👌 Later on minute 6:48 awesome point on legible labels for the bars, thanks!! Minute 7:30 the cheat-sheet was brilliant, I am going to print it ! On minute 13:50 un-checking the "autofit columns" is sacrosanct 😁 Mike I am minute 18:00 and your points on chart-junk are on point ! 👌👌👌 On minute 20:31 click on the chart and then do CTRL + D to make a chart copy instantly 😁 Minute 26: CTRL + SHIFT + F = really ?? 😮😵🤯👌👌👌 Minute 30... that trick can turn evil... if used in the wrong hands... 😵😬🤣 Overall, amazing EPIC video ... ship 🚀 return to base... 😎
@@spilledgraphics What!?!?!?!?!? Ctrl + D copies and pastes chart!?!?!?! I had no idea. I can't wait to use that in the next video. "Recalc Method" : ) : )
Very well explained. Looking forward to next lesson. Nice tip to deselect "update column with" in the default settings as well..... As for sorting: I always select the cell I want to sort and press a->z or z->a. I think that works always. I also encounter the problem that after a right click I can't remove the field buttons. Any idea why that sometimes is not posible. I am glad you mentioned this issue..so this happens also to MVP's...😉
Thank you, Bart! Coming from an awesome teacher like you, that means a lot : )What!?! What!?!? That is an awesome trick - I did not know it worked in a PivotTable... : ) Sort Buttons work in Values area of PT. I will have to use that "Bart" method soon : ) Yes, I have no idea why sometimes the right-click to remove field buttons does not always work. And sometimes, it does not work, but then in a few minutes it works again. Go Team!!!
Hi Mike! Boom!!! Another great video. I have a question, when you distribute a survey with yes/no answers, how would you visualize that? It is quantitative, there are only two answers, so would you create a column chart with no spaces between the columns? Or, should you separate the columns? Or, do you stack the columns? Many thanks for your help and your service. You are doing great work with your teaching videos. My daughter and I enjoy watching them together...
Hi Mike, this is now the most awesome Excel statistical analysis videos, The BDPs are really mind-blowing. I have a question on grouping negative an positive data together - the data reads -10,-8,-7,-3,0,3,6,8,9,10,12, is it possible to group this category into - 0-3 months left, 3-6 months left and so on if negative and 0-3 months due, 3-6 months due and so on if positive. If yes, how can this be done. Thank you so much for your guidance.
Formula solution coming up in a few videos. I also have many other COUNTIFS count between a lower and upper limit videos. Here is one: ruclips.net/video/yRpUSXg7LtY/видео.html
Hey Mike, I have a simple question, I would personally know what a cumulative frequency % normally tell in data analysis. Like if this data or the graph was supposed to show any trends of a certain frequency?
@@excelisfun in my country we say this for some one who is very professional and know all the details on what he do , like you with excel (idioms Mike)🙂👍
I'm taking business analytics now and I have comparable data 3 columns. I used a bar chart but was marked down because my instructor wanted me to use a histogram or box/whisker, which I have no clue how to use and compare the data that way.
That is the hard way, Wayne commented below as easier way: selecting the axis and then CTRL+1 for Format Axis >> Labels >> Label Position >> None. P.S. When I showed ;;; I should have shown the ghost ; )
02:52 Video Topic for chapter 2 list is not correct. The video shows 5 to 9 videos, in this chapter 2 there are only 5 - 8 videos. Video 9 is in chapter 3.
I searched for multiply days for some advanced tutorials but at last, found some videos in my desired way (statistics and excel both). Thanks, I will recommend your channel to others.
Glad to help!!!!
Hi Mike. Another super awesome Excel Stats video!! Thanks for the great review and many reminders of best practices. One tip I can add.. in the Pareto chart, you can also remove the display of each axis by first selecting the axis and then CTRL+1 for Format Axis >> Labels >> Label Position >> None. The axis disappears from view.. it becomes a thin vertical line object on the side of the chart. It is the same effect as formatting with ;;;. Just another way to get there. As always, thanks for the great lesson, tips, tricks and an all around fun time with Excel Pivot Tables and Charts :)) Thumbs up!!
That is epic. That is consequential. I had no idea. for 20 years I have been using ;;;. From a teaching perspective, it is no fun to have to teach ;;;. Now I have been liberated by you Wayne!!!!
******* Selecting the axis and then CTRL+1 for Format Axis >> Labels >> Label Position >> None
I can't wait to show the "Wayne" method in the next video!!!!! Go Team : )
@@excelisfun Awesome Mike!! Go Team!!!
Thanks Mike. rather late to watch this one, but I'm still here following all. That was very helpful and interesting. :) :)
Thanks for watching, Formula Guy John : ) : ) : )
Thank you Mike for this amazing video 📹. Excelisfun is indeed my favorite channel on RUclips!
You are welcome for the amazing fun with Excel, Nader!!!!
The Pareto chart was new to me and will be a great tool to add to the work I do. Love continuing to learn with your videos and looking forward to the rest of the series.
This class will go on for about next 4-6 months. A few videos each week : )
Love watching Mike's videos. There is always something new to learn
I am so glad that they help! Thanks for having fun with these, BIPower!!!
thanks for the EXCELlent video Mike.
You are welcome, Fellow Teacher, Syed Muzammal Muhasin : ) : )
That sort by functionality in a pivot table is very handy! I didn’t know/remember it was there.
Manual sorting can be fun for categorical frequency distributions: you can also do that by drag and drop in the pivot table.
Great video and lesson, as always! :-)
Thanks Geert! Yes, that Manual Drag and Drop in PivotTable is a hidden treasure : ) Go Team!!!
Boom!Excellent Class With Some Great Tricks...Thank You Mike :)
You are welcome, Mountain Biking Brother darryl: Boom : )
Thank you Mike, It is a important piece of information. Acually Love to learn with your videos
Glad to help!!!!
You always makes complex things simple and interesting ❤️🤗
That exactly what I try to do: make complicated things less complicated with good story telling : )
Greate! I still can learn a lot from the Excel Entertrainer. 🎉👍
Glad you liked it, Roger!!!
Mike, just wanted you to know both me and Sioux are enjoying the content! G
Glad that is so : )
Thank you Mike for the great stats and visualization video. So when I see catagorical data I should be targeting the Frequency, % Frequency, Relative Frequency with some visualization.
I also enjoy when you get into the options dialog box, so many options in there, and it helps that you show that.
Like n°48, comment n°4.... visualizations ???? 😵🤯😵 buckling up Captain ! 🚀🚀
Buckling up for detailed fun with Columns and Bars : ) : ) : )
@@excelisfun yes! I had to come back and watch the video completely. Good call on the research about pie charts. They're a great to start the conversation but that's it. Bars and columns are more effective due to their pre-attentive atributes.
Minute 6:48 was pure gooold ! wow thanks Mike for teaching this 👌👌👌
Later on minute 6:48 awesome point on legible labels for the bars, thanks!!
Minute 7:30 the cheat-sheet was brilliant, I am going to print it !
On minute 13:50 un-checking the "autofit columns" is sacrosanct 😁
Mike I am minute 18:00 and your points on chart-junk are on point ! 👌👌👌
On minute 20:31 click on the chart and then do CTRL + D to make a chart copy instantly 😁
Minute 26: CTRL + SHIFT + F = really ?? 😮😵🤯👌👌👌
Minute 30... that trick can turn evil... if used in the wrong hands... 😵😬🤣
Overall, amazing EPIC video ... ship 🚀 return to base... 😎
@@spilledgraphics What!?!?!?!?!? Ctrl + D copies and pastes chart!?!?!?! I had no idea. I can't wait to use that in the next video. "Recalc Method" : ) : )
@@spilledgraphics Yes, indeed: ;;; can turn evil in wrong hands lol^100
@@spilledgraphics Your Comment is Epic!!!!!! I LOVE it! It is rad ; )
Very well explained. Looking forward to next lesson. Nice tip to deselect "update column with" in the default settings as well..... As for sorting: I always select the cell I want to sort and press a->z or z->a. I think that works always. I also encounter the problem that after a right click I can't remove the field buttons. Any idea why that sometimes is not posible. I am glad you mentioned this issue..so this happens also to MVP's...😉
Thank you, Bart! Coming from an awesome teacher like you, that means a lot : )What!?! What!?!? That is an awesome trick - I did not know it worked in a PivotTable... : ) Sort Buttons work in Values area of PT. I will have to use that "Bart" method soon : ) Yes, I have no idea why sometimes the right-click to remove field buttons does not always work. And sometimes, it does not work, but then in a few minutes it works again. Go Team!!!
Excellent video Mike!
Thanks, Chris M!!!! : ) : )
Thank you so much
You are welcome so much!!!!
Hi Mike! Boom!!! Another great video. I have a question, when you distribute a survey with yes/no answers, how would you visualize that? It is quantitative, there are only two answers, so would you create a column chart with no spaces between the columns? Or, should you separate the columns? Or, do you stack the columns? Many thanks for your help and your service. You are doing great work with your teaching videos. My daughter and I enjoy watching them together...
Hi Mike, this is now the most awesome Excel statistical analysis videos, The BDPs are really mind-blowing. I have a question on grouping negative an positive data together - the data reads -10,-8,-7,-3,0,3,6,8,9,10,12, is it possible to group this category into - 0-3 months left, 3-6 months left and so on if negative and 0-3 months due, 3-6 months due and so on if positive. If yes, how can this be done. Thank you so much for your guidance.
You can definitely group with negative and positive numbers, but in a PivotTable, I am not sure how to put negaitive numbers into a category like 0-3.
I would just use COUNTIFS and build a formula solution. Worksheet formulas can do MUCH more than a PivotTable.
Formula solution coming up in a few videos. I also have many other COUNTIFS count between a lower and upper limit videos. Here is one: ruclips.net/video/yRpUSXg7LtY/видео.html
Hey Mike, I have a simple question, I would personally know what a cumulative frequency % normally tell in data analysis. Like if this data or the graph was supposed to show any trends of a certain frequency?
It always tells what % of values are less that the value on the x axis. so if max is 1000, but 80% are less than 450, that is helpful info.
@@excelisfun Thanks Mike! that's really helpful!
What is the title of the textbook?
You know where the ant pees from ! 🙂👍
I do not know what that means... lol
@@excelisfun in my country we say this for some one who is very professional and know all the details on what he do , like you with excel (idioms Mike)🙂👍
@@DIGITAL_COOKING Thank you for the cool kind words : ) : ) : ) : )
I'm taking business analytics now and I have comparable data 3 columns. I used a bar chart but was marked down because my instructor wanted me to use a histogram or box/whisker, which I have no clue how to use and compare the data that way.
Sorry to hear about that. Did you talk with your professor?
;;; make things disappear 😮
That is the hard way, Wayne commented below as easier way: selecting the axis and then CTRL+1 for Format Axis >> Labels >> Label Position >> None.
P.S. When I showed ;;; I should have shown the ghost ; )
@@excelisfun thank you for another way. 👻
@@kiwikiow Go Team : )