To do Alt + A Q on Mac in Excel, download and install Accelerator Keys, then press Option, followed by A, Q.
Command: Advanced Filter
This is how to do Alt + A Q 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 Q advanced Filter opens the advanced filtering dialog where you can filter data using complex criteria. Unlike AutoFilter, it supports AND/OR conditions and can extract filtered data to another location.