You can create a PivotTable in Excel from an external data source, a table in your worksheet, or a pre-built data model. To ...

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

Have you ever spent hours wrestling with Excel formulas, only to end up with a tangled web of cells that’s nearly impossible to decipher? For many, this is the reality of data analysis: a painstaking ...

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work. Image: ...

This is the demonstration file to accompany the article, How to display multiple grand total rows in a Microsoft Excel PivotTable by Susan Harkins. Be your company's Microsoft insider by reading these ...