In Power BI we can easily create quick measures: https://powerbi.microsoft.com/en-us/blog/quick-measures-preview/
This makes it so much easier for newbies or occasional users to adopt the new technologies, so please add in Excel as well.

I find it very annoying that as users of what is a create tool, that we cannot add/replace the current global style template.

Instead we need to either use the copy and paste from an existing workbook that you create your custom style or some Macro magic.

This is not user friendly - on the face of it, it would seem like an easy win for Microsoft.

If you feel as I do please so vote

Presently, when using a date field in PIVOT, Excel automatically group data in years, quarters and months. It would be extremely useful to also have a grouping in weeks, provided that somewhere you've the possibility to set the default week type, like the weeknum formula.
The week grouping is useful, for instance, when you want to monitor sales by week, weekly production schedule, users call per week, etc.

Thanks you.

When you wish to create a difference table, I as I'm sure most do, use the show values as calculations (which are great time savers).

However it's a massive pain, that these values cannot be sorted or filtered by.

When I create such a table, I want to be able to show the biggest 10 or 20 movers (not the top 10 or 20 by the underlying number before using the built in calculation) sorted by highest to lowest or lowest to highest

This is a basic requirement for proper analysis

Until recently, there was an indicator preceding the table name of a PowerPivot table that had an Excel table as its source. Please bring back this important indicator! It is now a mystery when looking at tables as to the relationship between the PowerPivot table and its source in Excel.

It would be really great if there could be a larger selection summarise options for the value field. Maybe even the ability to add in custom formulae? Things that I am interested in are standard error or maybe even confidence intervals (with variable % input options). I've found working with large data sets is great with pivot tables but becomes cumbersome in statistical packages and so this addition would be a great help.

Hi, I am an Excel 2016 Mac user. It would very useful to have in the Mac version the following commands: Power Pivot, Get and Transform. Even more, I think that it would be perfect if the Excel Mac version had the same features that Excel for Windows has.

Thanks for adding this in the recent update but it doesn't seem to be available in VBA. We need a Query.Source read/write property to duplicate user functionality in VBA

Please add a user controlled feature(radio buttons) to automatically refresh the pivot table with change in Source data.

While connected to a big Tabular Model, please make disabling auto-refresh possible. After each slicer and/or filter selection you have to wait a specific amount of time depending on the tabular model. This is not convenient for end users.

More information for Err: "A PivotTable Report cannot overlap another PivotTable Report".

I had multi PivotTable share the same data source in a single worksheet.
This error had little meaning for me to find out which PivotTable having problem.

Please improve the error message and advice which PivotTable cause this problem.

There should be a step chart format for pivot table data/pivot charts. And/or maybe have a step chart option as one of the type of charts you can make in Excel. It would be most helpful in our engineering work to have something that accurately represents data without having to super manipulate it. Just have a button that can make a step chart happen!

Maintain a policy of 100% feature parity for DAX expressions (availability, compatibility, etc.) between Excel and Power BI, so that Excel professionals can be confident their knowledge and skills apply equally to both products with respect to DAX.

Maintain a policy of 100% feature parity for Data Model feature between Excel and Power BI, so that Excel professionals can be confident their knowledge and skills apply equally to both products with respect to the Data Model features.