A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!

In this tutorial, I’ll show you an easy method to report the first and last times from a timestamp in Excel using a PivotTable. We’ll work with the same data from the earlier article.

Use Excel PivotTables to quickly analyze grades Want to quickly sort the data in your Excel gradebook by category, such as section number or teaching assistant’s name? PivotTables let you view this ...

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

This PowerShell script will automatically extract specified data from an Excel PivotTable and write it to a text document. You will need to open this in a text editor and fill in your own values, ...

Eric S. wins an autographed copy of Pivot Table Data Crunching from CFO and MrExcel for his question: “Is there any way in Excel 2007 to have a pivot table always default to sum the amounts rather ...

This is the sixth and final part of Simon Hurst’s series looking at the changes and new features in Excel 2016.

Microsoft has announced the introduction of PivotTable features for the iPad version of Excel. This robust tool — essential for summarizing and analyzing vast data sets within tables — has ...

Of all the Excel tools, the PivotTable provides the most effective way to analyze your company’s general ledger data because it enables you to slice, dice, drill, group, analyze, compare, chart, and ...