You can find out how to use that Query app by launching Query, and opening the help info file from the Help menu.
You will then see that, first, you need to install a compatible ODBC driver, which is not included with Excel for Mac 2011.
The Query help gives you several links to companies that offer an ODBC driver. When you have that installed, the help information will then walk you through how to setup and use a query.
Microsoft says Query is included with Excel 2016 for Mac - https://www.microsoft.com/en-us/microsoft-365/blog/2015/08/20/working-with-external-data-in-excel-2016-for-mac/I do not think Excel 2016 includes Query.
That's a bit of misinformation. Power Query (and Power Pivot) are only on Windows Office, and not supported on Office for Mac, in any version.Hi, multiple sheets can be easily merge into one by using Power Query. Check if it is properly activated because it is a separate tool that needs to be downloaded from Excel. Also, there is also a tool called as Power Pivot, which helps to apply Pivot on multiple sheets together. You can also try using this one.