In previous versions of Mac Excel you could create a Form/Dialog using VBA (called a VBA UserForm). In Mac Excel 2016, you can no longer do this. Please bring that functionality back. Note that this is different than the "Form" option on the Data menu. There's a separate suggestion on UserVoice for that.

(March-2018: MS updated the Title and Description to avoid confusion with the Data Form request)

Dot plots are simple graphs that show distribution of values along a single axis. This can be faked using a scatterplot, but the y-axis is unused (and people always ask what that axis is...) Programs like Minitab allow for this graph to help visualize the data without any statistical assumptions.

I have a great deal of trouble with the mouse click in Excel (Version 15.22). I have to move the mouse out of the cell I'm working in, click on a cell far away from it several times, and then come back and try it again.

This is never an issue with Excel (Version 14.6.4). I'd like to use the later version but it's too difficult to use with the cell selection issue.

In the touch bar for Mac make that the function highlight "remember" the last color, like in the ribbon. Specially because the usual bright yellow does not appear in the touch bar menu of colors! Same for font color in touch bar.
This would make a lot easier and helpful to use the touch bar to format cells

In Mac XL 2011 You had ability to create Macros that made use of Relative References in a addition to absolute references. In the Excel Mac 2016 Answers forum this is vitally important.

Any possibility of returning this to Excel Mac 2016

[10/22/2015 - Dan [MS]: Added image to show where this feature used to exist in older versions of Mac XL]

Excel 2011 had the possibility to sum individual cells by typing "=", and then just clicking on individual cells across the workbook that you want to sum, and "return" when done. This functionality is no longer available in Excel 2016 (you have to type "=sum(", then clicking on the individual cells while holding down the command key, "return". I would be happy if the old functionality is brought to Excel 2016.

The font used in the text import wizard really needs to be changed. 1. The preview window is to small and the font used in the preview window is to small and should be like Helvetica or something so the text is much easier to read. The zero's wth slashes is awful. please fix this so it is as nice as the windows version. Thank you.

In Excel 2016 for Mac there is no way to (easily) insert personalised labels to an XY scatter plot (like in the 2013 version for Windows, for instance...). In the Windows version (which I know best) there was the possibility to choose values for the labels that were not part of the XY plot itself but that option does not exist for the (2016) Mac version I can modify a few labels manually but with hundreds of point it is very complicated...
I believe this feature is of utmost relevance!!

Allow users to aggregate data in a pivot table from multiple worksheets.

I'd like to be able to add embed a .pdf document in a spreadsheet, and view it as either an icon or a link to the embedded document.

Thanks.

The forecast tool is fully available in the Windows version. Its absence actually limits various processes that are so important from financial and statistical point of view. Please look into this and try including it in the future.

Please reinstate the option+click shortcut or at least a way to customize for it. It makes my work much easier and is the only reason I've yet to upgrade. Thanks a lot!

Why is it so much harder to make text superscript or subscript in Excel, both for mac and windows?

Since the introduction of Office 2016 all of my Office apps give me an upgrade 'nag' ribbon on first opening.
I tried 2016. It is terrible. Many apps are missing critical features that make them useless for my work.
I don't need regular nags to harass me into updating to an inferior version.
Please get rid of these annoying things please. I didn't pay this much for Office to be subjected to annoying in-app advertising.

while saving the opened file through 'save as' option, it does not give option for 'new folder'

Bring VBA on Excel for Mac to parity with Excel for Windows.
Currently, there are too many missing VBA elements missing. It is a major problem for those of us with mixed environments. Many things that worked under Excel 2011 no longer work in 2016.

Why is the not being addressed?

please