Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

Before Excel 2016, this grouping had to be carried out manually by right-clicking on an item in the field and choosing the Group option. In Excel 2016, date fields are grouped by Months, Quarters and ...

Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the Excel Data Model and Power BI d… ...

Yesterday, the Excel team announced a bunch of performance improvements in Excel 2016 for PivotTables connected to Analysis Services (Multidimensional or Tabular), Power Pivot and Power BI. If you … ...

Smart rename: Excel 2016 enables you to rename tables and columns in your workbook’s data model. With each edit or change, Excel 2016 now automatically updates any related tables and calculations ...

For those who do accounting, you probably know the PivotTable is a specialized Excel tool for statistics and data processing in reports.

3. Convert to formulas. Finally, position your cursor in the PivotTable you want to convert, and from the PivotTable Tools menu, select Analyze, OLAP Tools, Convert to Formulas, as pictured below.

Liam Bastick looks at the new PivotTable enhancements and updates in Office 2019. PivotTables were enhanced beyond recognition with the advent of Excel 2010 and Excel 2013, and the introduction of ...