When the Choose Data Source dialog appears, click OK.Ī gallery of recommended PivotTable styles will appear that provides suggestions for how you might want to analyze the selected data. To create one, highlight the data source (the range of cells in the workbook that contains the data you want to analyze.) Then select the Insert tab and then Recommended PivotTables.
You might not get the information you need depending on your data set, but it can be handy for quick analysis. Introduced in Excel 2013, a Recommended Pivot Table is a predesigned summary of your data that Excel recommends for you. You can use Excel to create a Recommended Pivot Table or create one manually. It’s ideal for calculating and summarizing information that you can use to break down large tables into just the right amount of information you need.
A pivot table is a fancy name for sorting information.
0 kommentar(er)
