If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.

How to create an interactive dashboard in Microsoft Excel Now that you have a basic idea about interactive dashboards in Microsoft Excel, let’s check them out in action.

Quick Guide to Excel Interactive Dashboards Start by gathering and preparing your data, ensuring it is clean and organized. Create a pivot table to summarize your data. This will serve as the ...

Learn how to use Excel pivot tables to QA bulk sheets, plus some tips and shortcuts to enhance your pivot table skills.

7 Advanced techniques for using Excel PivotTables to enhance data analysis efficiency and effectiveness. Covering practical examples and ...

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

When you create a PivotTable, Excel recommends several ways to summarize your data, and shows you a quick preview of the field layouts so you can pick the one that gives you the insights you’re ...

Q: How do I add a percentage-of-total column in a PivotTable in Excel 2010? A: The October 2011 JofA Technology Q&A column (page 76) included an item titled “ Make a Difference With PivotTables,” ...