Importing data from other workbooks, using power query and then analyzing data using power pivot are the critical features needed by professionals for any data analysis. I got very disappointed after shifting to Macbook and paying of office 365 and not getting access to. these functionalities in excel. This is taking macbook users for a ride, though we are paying full for the MS office and not using it for free. I RECOMMEND EVERY MAC USER TO VOICE DISSENT FOR NOT GETTING ACCESS TO ALL FEATURES OF MS OFFICE DESPITE PAYING FULL PRICE.

Please provide the same power query functionality for Excel for Mac that is currently released for windows systems

In Excel Windows you can choose between point or comma as decimal separator. In Excel Mac you cannot. About half of the world uses comma like Sweden and imported documents from the U.S. and some other countries always cause a lot of problems. So please let me set point or comma as decimal separator for each document.

The ideal solution would of course be a new separator that would be standard all over the world and Microsoft together with international bodies.
https://en.wikipedia.org/wiki/Decimal_separator

For you stock add on under the data tab, you should really implement a way to include the last / current dividend amount / yield as a parameter to follow. I'm sure many many people would find this to be very useful and helpful for stocks / supplemental income tracking. I would appreciate any help I can get to make this happen... please! ; ]

We have to jump through hoops to import a xml file in Excel for Mac. What I can find is basically not understandable. I am paying a yearly subscription and expect more than this. Once I learn how to use Numbers and Pages I will be cancelling my subscription. I will learn how to use those before I continue struggling with this.

I can not include my account in the TSP account to the budget program

Add www.equitable.com

Data Types for MacOS are only Stocks and Geography. For Windows there are more data types available. Why is that? Is there a fix anyone knows? I am running the latest MacOS and Excel Office 365. Any help is appreciated!

Get Data from Folder when using power query for mac.

Excel para Mac no puede importar datos de páginas web. Debería ser posible. ¡Gracias!

When I want to do a Power Query in Excel for Mac, the URL needs to be saved as an "iqy" file. But this file is "greyed out" when I select "Get Data" and try to click on the file

Overall, this is pretty fabulous. I used it several times a day, but their are some stocks that are not listed, and others where the ticker overlaps. this function is very important as I trade stocks every day.

thanks

The stock data function is useful. Please include Singapore listed stocks.

It's great that you guys have made Power Query available for mac users for office 365, but is it possible to also include office 2019 and 2016 in this update? As a costumer with no IT background I find it strange that Power Query is included in office 2016 and 2019 on windows but not on mac.

Please add power query function in mac like in windows.

I cannot seem to add the Apple Card to Money in Excel (probably Apple's fault), but they have recently made it possible to access my account without being forced to use my phone, so maybe its possible now.