❗Important: Excel Versions, Expectations & Course Pathways
Microsoft continues to develop Power Query in Excel for Microsoft 365.
It is now available in Microsoft 365 for Mac. The Mac version supports fewer sources but uses a more modern interface. More information: Import and shape data in Excel for Mac (Power Query) - Microsoft Support.
To check which sources and functionalities are supported in your Excel version, follow this link: Power Query data sources in Excel versions - Microsoft Support. Please note that there are also differences between Home, Business and Enterprise versions.