Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)

is it possible to open an existing Windows Power Pivot Excel on Mac?

I have already created a Power Pivot Excel report on Excel 2013.
Now i want to use that report on mac.Is there any way to do so?

In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.

(March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)

Please add the evaluate formula dialogue box to the mac app. With it you can evaluate a formula step by step and see which part of the formula works and where the problem is.

Excel 2011 had the possibility to sum individual cells by typing "=", and then just clicking on individual cells across the workbook that you want to sum, and "return" when done. This functionality is no longer available in Excel 2016 (you have to type "=sum(", then clicking on the individual cells while holding down the command key, "return". I would be happy if the old functionality is brought to Excel 2016.

Allow users to aggregate data in a pivot table from multiple worksheets.

In Excel 2016 for Mac there is no way to (easily) insert personalised labels to an XY scatter plot (like in the 2013 version for Windows, for instance...). In the Windows version (which I know best) there was the possibility to choose values for the labels that were not part of the XY plot itself but that option does not exist for the (2016) Mac version I can modify a few labels manually but with hundreds of point it is very complicated...
I believe this feature is of utmost relevance!!

Quick Analysis is available on Windows Excel 2016, but not Mac 2016 - please add.

IN the windows version you can click on the button find all when you are in a search box. This then shows you all cells which contain your search criteria in a list. Please add this feature to the Mac app, too!

The ability to utilize the ALT keys to access any button or command on the ribbon greatly improves productivity on the PC versions of excel. Implementing this feature on the Mac version of excel would be greatly appreciated.

I'd like to be able to add embed a .pdf document in a spreadsheet, and view it as either an icon or a link to the embedded document.

Thanks.

It would be great if you could export a Sharepoint list to Excel for Mac. At present you have to use Excel on a PC - as I believe this requires some kind of ActiveX component.

Fuzzy lookup for Mac

It would be great to have fuzzy lookup add-in for Mac.

Please add a median function for Pivot Tables. It is mind boggling how Google Sheets has this capabilities but the much more powerful MS Excel does not

The forecast tool is fully available in the Windows version. Its absence actually limits various processes that are so important from financial and statistical point of view. Please look into this and try including it in the future.

Dear all,
What I love, please read this a need, is a better Name manager.
The size of the list is way to small. If you work a lot with names, then you get longer names which are not easy to select.
Also would like to see an easier way to replace, rename and exchange Names and references. When I make a Template sheet with names/reverences and want to make multiply copies bij code or manualy, its a crime to change or update the Name.

Bring VBA on Excel for Mac to parity with Excel for Windows.

Currently, there are too many missing VBA elements missing. It is a major problem for those of us with mixed environments. Many things that worked under Excel 2011 no longer work in 2016.

Why is the not being addressed?

Function that references a chart and gives trendline parameters.