To do Alt + A P N S on Mac in Excel, download and install Accelerator Keys, then press Option, followed by A, P, N, S.
Command: Data Source Settings
This is how to do Alt + A P N S 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 S opens the Data Source Settings dialog. This allows you to manage your data source connections, edit credentials, change permissions, and delete stored connection information for Power Query data sources.