CUBE functions Where the data source is an OLAP cube – which would be the case if we added our data to the Excel Data Model in Excel 2013 or used PowerPivot in Excel 2010 or 2013 - we can create ...

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

When analyzing grouped data, bypass complex functions and use a Microsoft Excel PivotTable.

This is the sixth and final part of Simon Hurst’s series looking at the changes and new features in Excel 2016.

Further, be aware that as a default, Excel’s PivotTable sort function sorts by custom lists, which explains why a PivotTable will sort months (January, February, March, etc.) in month order instead of ...

How to create a grouped PivotTable in Excel Grouping is what Excel’s PivotTable objects do, and it’s easy to summarize groups of data using any number of functions.

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?