Ever wondered how some managers seem to have a sixth sense for spotting trends and making data-driven decisions? What if you could unlock that same ability with just a few clicks in Excel? Excel Pivot ...

The steps for quick sorting are as follows: First, select an appropriate value (pivot) from the data. In the following example, the value with the diagonal line is the pivot. Each data point is ...

On the advanced end of the spectrum, pivot tables can also be used to perform simple projections; for instance, you can see how the revenue of your company has changed over time by viewing a line ...