![]() In the dialogue box, you will see Excel's recommended PivotTables.Īs you can see, in our recommended pivot tables, Excel summarizes the data by the price of each item, the total price, and the number of items. ![]() You will then see the Recommended PivotTables dialogue box. Go to the Insert tab, then click Recommended Pivot Tables in the Tables group. To see the recommended pivot tables, click anywhere in the worksheet. This worksheet is simply a list of items, the price for each item, the quantity sold, the total price, and then the date sold. Recommended Pivot Tables is a feature that is new to Excel 2013. With Recommended Pivot Tables, Excel analyzes the data that you have in your spreadsheet, then suggests possible pivot tables for you to use.
0 Comments
Leave a Reply. |