Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Fortunately, you can add a filtering control to the interface. To illustrate, let’s add a filter for the region as follows: First, completely expand the pivot table, if necessary.

For deeper dives, check out my earlier articles on creating relational tables and creating relational databases. How to create an Excel table 1. First, enter the field names in the columns across ...

Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.

How to Make a Regression Table in Excel. Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a ...

You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel.