Excel 365 for Mac does not have Power Query and Power BMI
I am a yearly subscriber to Office 365 for Mac since December 2018 and I am still operating Office 2010 on my Windows 7 Pro ASUS Notebook.
As a MAC Office 365 user, I am one of 1 million people who have moved from the Windows PC to Apple MAC.
When i subscribed to Office 365 for MAC, I expected Office 365 for MAC to contain the same intermediate to advanced features as Office 365 for Windows.
I was very disappointed that Microsoft Excel 365 for Mac does not have the POWER QUERY FUNCTION; POWER BMI FUNCTION and the Visual Basic functions on Excel 365 for MAC are very limited.
I feel that as an Office 365 for MAC subscriber, I have been shortchanged or cheated. Under consumer law, Office 365 for MAC is not fit for a particular purpose. Excel 365 MAC users cannot use the POWER QUERY to merge 5 Excel worksheets into the one worksheet after they have exported a wide range of data from an accounting software package in Excel form.
When will Excel 365 for MAC include the Power Query functions??