Rock your resolutions. Take the Dummies challenge and you could WIN $1,000! Get Started.
Create Charts in Excel 2013 via the Quick Analysis Tool
How to Add Comments to Excel 2013 Worksheet Cells
Top 10 New Features in Excel 2013

How to Use the Excel 2013 Quick Analysis Tool

Step 5 of 5
Next Slideshow
Next Slideshow

When a preview of the pivot table you want to create appears, click its button in the Quick Analysis options palette to create it.

Excel 2013 then creates the previewed pivot table on a new worksheet that is inserted at the beginning of the current workbook. This new worksheet containing the pivot table is active so that you can immediately rename and relocate the sheet as well as edit the new pivot table, if you wish.

blog comments powered by Disqus
How to Describe a Custom Excel 2013 Function
How to Move Pivot Charts in Excel 2013
How to Customize the Excel 2013 Quick Access Toolbar
How to Copy Custom Styles in Excel 2013
How to Share Excel 2013 Files
Advertisement

Inside Dummies.com