And many of the query options in Excel 2016's data tab come from the Power Query add-in for Excel 20. (Note: Keyboard shortcuts will work for the 2016 versions of Excel, including Mac those were the versions tested. Want to get more out of Excel? At Microsoft's inaugural Data Insights Summit last month, several experts offered a slew of suggestions for getting the most out of Excel 2016.