To do Alt + A W on Mac in Excel, download and install Accelerator Keys, then press Option, followed by A, W.
Command: What-If Analysis Menu
This is how to do Alt + A W 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 W opens the What-If Analysis dropdown menu. This menu provides access to powerful analysis tools including Scenario Manager, Goal Seek, and Data Tables for exploring different outcomes and finding optimal values in your spreadsheets.