For those without a strong Excel, math, and/or computer science background, formulas can be much more complicated than they need to be. To help them along, Excel could suggest simplifications to commonly used simplifiable expressions. It would be like a spell checker, but for logic.

Here are some simplifications that I've done over the years:
IF(A1=1,"",IF(A1<>1,"s","error")) has an unreachable part "error" and becomes IF(A1=1,"","s").
NOT(A1<B1) becomes A1>=B1.
IF(A1<0,0,A1) becomes MAX(A1,0).
DATE(YEAR(A1),MONTH(A1)+1,1) becomes EDATE(A1,1).
SUMIFS(,,"="&A1) becomes SUMIFS(,,A1).
(A1B1)+C1 becomes A1B1+C1.
...
and so on.

If you VLOOKUP (or HLOOKUP) 123 (or a range containing 123) into a range which clearly has 123 in it, but the latter is formatted as text, it doesn't find it. If it LOOKS right, it should find it!

It would be very helpful if Excel could record the total editing time spent working on a spreadsheet. Or if Excel could better still, automatically log each time period spent editing a spreadsheet. Helps when billing customers and giving volunteer hours as I do a lot with Excel.

1) Bug: when panes are frozen, in the moment when filter is applied the sheet is being violently scrolled horizontally in a random direction, hiding the active column.
Please do not scroll on filter application.

2) Missing functionality: The filter popup list can be re-sized to show more or wider items. Unfortunately the size of the popup is not remembered on the next pop.

Many thanks!

If I give an Excel-table a name, then I can use the Go-To function to find it. Why can’t I find named Pivot tables in the same list?

It is observed that the pivot "calculated item" feature has two serious drawbacks:
(1) The calculation takes a long, long time compared to "calculated field" feature.
(2) The calculated numbers generated via "calculated item" on the pivot table can be altered or defaced which does not happen when "calculated field" feature is used.
The above drawbacks render the use of "calculated item" in pivots unusable. Can we address these?

Allow users to edit the Macro Button (like we could in an older version of Excel) for custom macros in the Quick Access Toolbar. Currently, we can select from ~180 images but it was so much nicer when you could go in and 'draw' your own button.

Other Microsoft products allow keyboard shortcuts to align text. Please add these to Excel: Ctrl-E to center a cell's contents, Ctrl-R for right alignment, Ctrl-L for left alignment.

Function to only use every xth-row or column in another function

Many know the F4 is used with authoring a function. However it needs to be memorized. please create a button on the ribbon to switch between types of referencing.

Right now, I often use formulas like this:

=IF(COUNTIF("A", myRange)>0, ..., ...)

It's be handy to be able to just use:

=IF(IN("A", myRange), ..., ...)

This could also help with formulas where a number of different criteria are allowed:

=SUMIFS(B:B, A:A, "2016") + SUMIFS(B:B, A:A, "2013") + SUMIFS(B:B, A:A, "2010")

becomes

=SUMIFS(B:B, A:A, IN(A2, "2016", "2013", "2010"))

if it was possible that just with one click, we can create a Tree Grid Map of directory, which will give option of inducing sub folders & files with option of inserting hyperlink.

So that i don't have to open 7-8 sub folders before opening my files.

(nothing against VBA, its a great tool) if i create a directory using VBA it is not very beautiful..... i wish i could see small folders with little Expansion buttons it would be very great.

I open my excel to cross over multiple screens, but when i open a file its a crap shoot as to where it appears across the screens. I know the file is open as I can see it in the list of open files but beats me where it is. I have to go to "View/Arrange All" and then vertical to be able to find the file. But doing that moves all my other files that I have placed in my work area for a reason.

Often I have typed a heading in a workbook, and then had to re-type the same or nearly the same information when saving the workbook. MS Word has an intelligent guess at the Save As option by using the first words in the document, but Excel just offers Book1.xlsx. What if we could have Save, Save As, and Save As Cell Contents? In other words, select your chosen cell, click on Save As Cell Contents, and you have your desired file name with no duplication of effort.

I WANT THE EXCEL I PAID FOR WHEN I BOUGHT THE MACHINE AND WHICH HAS DISAPEARED WHEN MICRO SOFT INSTALLED 10 - REPLACING WINDOWS 8 - WHY IS THIS SO - I WANT MY EXCEL WHICH I PAID FOR BACK.

I have two screens but if I want to display and work on two or more excel files on separate files then I need to open the program a number of times and then open the file within that open file. Word allows you to open and move any number of documents to a second screen, I don't understand why you can't do it in excel. Cheers. Matt