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 ...
How to show details in a grouped PivotTable in Microsoft Excel Your email has been sent Microsoft Excel PivotTables turn data into useful information the same as other reporting tools. Most reports ...
How to calculate a conditional running total using a PivotTable in Excel Your email has been sent An expression to return a simple running total in Excel is easy — a few references and you’re done. A ...
Q: My Excel 2013 PivotTables sometimes default to using the COUNT function instead of the SUM function. Is there a setting adjustment that will always make SUM the default PivotTable result? A: When ...
This article will explain how to use the conditional functions IF, AND, OR and NOT on Microsoft Excel. Each of these functions can be used as part of a formula in a cell to compare data samples in any ...
Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you copy ...
How-To Geek on MSN
4 New Microsoft Excel Features to Try in October 2025
All details in this article are correct as of October 7, 2025. Accessibility to some of the latest Excel features depends on ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback