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. This method recognizes that it’s easier to edit a table that is almost ready than start from scratch.Excel provides a way to quickly create visualizations and analyze your data in just a few clicks. With the Quick Analysis Tool, you can create a PivotTable with a few simple clicks, then make small edits to get exactly what you need. Un-check any fields you do not want to appear in the table. Click the dropdown filter arrow to see a list of the fields in the column or row you are working with.
0 Comments
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |