Clean your dataīefore you start building anything in Excel, it’s smart to take a quick look at your data to ensure that everything looks correct. Let’s walk through the steps along with Jason. So, to make this easier, Jason has decided he’s going to build a pivot table to see which beer he sold the most of during each quarter. In order to better manage his inventory and brewing schedule, he wants to see if there are any trends in terms of the type of beer that sells most each quarter.įor example, do people drink more dark beer in the wintertime? Getting a better grasp on any seasonality would help him a lot, but to start he only has a spreadsheet that breaks down his sales of each type of beer (stout, pilsner, IPA, and an amber) per quarter in 20. Jason brews and sells craft beer in a quaint brewery in his hometown. And, since there’s nothing like an example to add some clarity, let’s look at a specific scenario when a pivot table could be helpful. Well, have no fear! We’ll walk you through it step by step. However, that doesn’t change the fact that you have no clue how to build one. And don't worry, this pivot table tutorial will guide you! How to build a pivot table: A case study In the PivotChart, click any interactive control, and then pick the sort or filtering options you want.But basically, all you need to know is that something that would typically take a long time can be done quickly and painlessly when you build a pivot table.
If you don’t find a PivotChart you like, click PivotChart on the INSERT tab, instead of Recommended Charts. Once you find the PivotChart you like, click OK. A preview of your PivotChart appears in the preview pane. On the Recommended Charts tab, pick any chart with the PivotChart icon in the top corner. On the INSERT tab, in the Charts group, pick Recommended Charts.
While a PivotChart shows data series, categories, and chart axes the same way a standard chart does, it also gives you interactive filtering controls right on the chart, so you can quickly analyze a subset of your data. In the Recommended PivotTables dialog box, click any PivotTable layout to get a preview, and then pick the one that shows the data the way you want, and click OK.Ī PivotChart can help you make sense of PivotTable data. Make sure your data has column headings or table headers, and that there are no blank rows.Ĭlick any cell in the range of cells or table. But sometimes it is hard to know where to start, especially when you have a lot of data.Įxcel can help you by recommending, and then, automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data. Learn what a PivotTable and PivotCharts are, and how you can use them to summarize and analyze data in Excel 2013.Ĭreate a PivotTable to analyze worksheet dataīeing able to analyze all the data in your worksheet can help you make better business decisions.
0 kommentar(er)
