To do Alt + A W T on Mac in Excel, download and install Accelerator Keys, then press Option, followed by A, W, T.
Command: Data Table
This is how to do Alt + A W T 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 T opens the Data Table dialog for What-If Analysis. Data Tables let you calculate multiple results simultaneously by substituting different values into a formula, showing how changes in one or two variables affect your outcomes.