Same thing for Sum of Quarter by Department Quarters 1 through 4 add up to 10, so that doesn't really give you any good information. For example, Counting Sales by Department, well, there are four quarters, so of course count of sales will always be 4. You can see right off that some of those suggestions don't make a lot of sense. I can scroll down the list of recommendations, and the one that's selected is previewed here in the right-hand pane. Doing so displays the Recommended PivotTables dialog box. To create a recommended PivotTable from the data, I click any cell in the list, and then on the Insert tab, click Recommended PivotTables. This workbook contains a single sheet, and I have an Excel table with quarterly sales data for a bunch of different departments of a company. I will use the Recommended sample file, which you can find in the Chapter01 folder of your Exercise Files archive.
#HOW TO USE PIVOT TABLES IN EXCEL 2013 HOW TO#
You click inside of a data list or Excel table, click Recommended PivotTables, and Excel suggests some layouts for your data, and in this movie, I'll show you how to take advantage of that new feature. It's all well and good to create the PivotTable, but where do you want to put your headers, and how do you want the data laid out? Well, in Excel 2013, the Excel programming team has added what are called Recommended PivotTables.
If you don't have a lot of experience working with PivotTables, you might be uncertain as to what arrangement to start with.
0 kommentar(er)
