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

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.

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

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

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

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Enter the “ Column Column Chart ” in Microsoft Excel, a clever visualization technique that combines category-level data with overall totals to tell a more complete story.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.