This month’s column introduces Excel’s GROUPBY function as a PivotTable alternative.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

In this article, we’ll combine a VLOOKUP () function, a data validation list, and a PivotTable to create a simple application that tracks stipend awards for employees when working at off-site ...

By mastering these advanced Excel PivotTable techniques, you can optimize your data analysis and visualization processes, making your reports more efficient, flexible, and visually appealing.

A basic Excel feature from which many other visualizations derive is the PivotTable. Doing proper data visualization in Excel starts with knowing how to use PivotTables and understanding how they ...

Excel’s PivotTable feature probably offers the best choice. You don’t have to sort the data set first, you can filter by dates, and by basing the PivotTable on a Table object you refresh the ...

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.