Learn how to use one of the most powerful tools Microsoft Excel has to offer.

Excel analyzes quantitative variables by arranging them into pivot tables. These tables sort data into groups, totaling the figures that fall under each qualitative division.

How to use Analyze Data in Excel Now that you know a bit about the feature, let’s put it to work. Select the entire Table and then click Analyze Data.

It's easy to divide in Excel to make calculations and analyze data in a spreadsheet. Here's what you need to know to do it.