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 ...

By mastering these seven advanced PivotTable techniques— custom grouping, data bars, filters and slicers, report filter pages, distinct count, DAX measures, and default number formatting —you ...

Creating Running Totals in Excel Is Easier Than You Think A regular Excel range with Month in column A, Profit in column B, and Running Total (currently unpopulated) in column C.

Several readers have submitted questions about Excel 2010 and 2007 PivotTables, as follows: Q1: Why does Excel insert the GETPIVOTDATA function into a formula when you use the mouse pointer to refer ...

3. Convert to formulas. Finally, position your cursor in the PivotTable you want to convert, and from the PivotTable Tools menu, select Analyze, OLAP Tools, Convert to Formulas, as pictured below.

This is the demonstration file to accompany the article, How to display multiple grand total rows in a Microsoft Excel PivotTable by Susan Harkins.

Slicers are a good way to filter data in a Microsoft Excel PivotTable or PivotChart, but they take up a bit of room. By moving the buttons to the chart, you free room for more visuals.