How to Format Values in the Pivot Table in Excel 2013
Create a Histogram with a Pivot Table for Excel Dashboards
How to Move Pivot Charts to Separate Sheets in Excel 2013

How to Use the Excel 2013 Quick Analysis Tool

Step 1 of 5
Next Slideshow
Next Slideshow

Select all the data (including the column headings) in your data list as a cell range in the worksheet.

If you’ve assigned a range name to the data list, you can select the column headings and all the data records in one operation simply by choosing the data list’s name from the Name box drop-down menu.

  • Add a Comment
  • Print
  • Share


Promoted Stories From Around The Web

blog comments powered by Disqus
How to Move Pivot Charts in Excel 2013
How to Add Calculated Fields to Pivot Tables in Excel 2013
Use Excel Pivot Tables to Get Top and Bottom Views
How to Create a Pivot Table with the Excel 2013’s Quick Analysis Tool
How to Modify the Pivot Table’s Summary Function in Excel 2013