Here’s looking forward to future updates from Microsoft Office. Click on Insert and select the “ Recommended Pivot Charts” option In summary, we use the following steps to create a Pivot table using Excel-2013:ģ. Once the Pivot table is created you can customize the fields according to your requirements. When you select one of the recommended Pivot tables, it automatically adjusts the fields without the user having to drag and drop in the Pivot table field list. All you have to do is make sure that your cursor is in one of the data entries on the main sheet before you click on “ Recommended Pivot Tables”. Instead of inserting a Pivot table from the Insert tab, just click on the “Recommended Pivot Tables” option on the Insert tab.Īs you can see in the above image, Excel automatically suggests three or four options for your data range. As seen to the right, you can pull the exact information you need from a complex spreadsheet without having to go through the above mentioned steps for Excel-2010. The best part is you do not have to drag and drop anything into the field list. With the new Microsoft Excel-2013, you are just one click away from creating a basic pivot table. Manually drag and drop the required fields according to our requirements to calculate-Sum, average, percentage, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |