Feel free to play around with these other functions, but for our ice cream task we want to use the charts. Now you can see that when the button is clicked it brings up a menu of different options. This is the quick analysis button and we are going to click on it to open the menu. Notice that to the bottom right of our highlighted area there is a button that looks like a chart with a lightning bolt. In this case, we want to highlight the “Favorite Flavor” column to get what we’re looking for.
We are going to find our counts using a bar graph from the quick analysis tools in Excel.įirst, highlight the data set you want to analyze. That is a lot of counting (and a lot of ice cream). In this sample set it would be easy enough to hand count, but imagine if you were doing things for hundreds or even thousands of records. Let’s say you have been tasked with identifying how much of each flavor ice cream needed for an office party so you need to find out which flavor is most popular. Here there is a sample set of data to use: You don’t have to be an Excel wizard to have tailor-made insights at your fingertips.
0 kommentar(er)
