To do Alt + A P N D on Mac in Excel, download and install Accelerator Keys, then press Option, followed by A, P, N, D.
Command: From Database (Microsoft Query)
This is how to do Alt + A P N D on Mac in Excel with Accelerator Keys, the native ribbon and alt key shortcut solution for Mac users who get more done with Excel.
Alt + A P N d opens Microsoft Query for database connections. This legacy tool provides a graphical interface for connecting to various databases, building queries, Importing data into Excel worksheets.