Everyone is using Data Validation in Excel for simple or complex projects. However if you decide to clear your data validation rules there is No direct command on the ribbon to do that: So you have to go to the Data Tab >> Open the data Validation dialog box >> Click on Clear All >> Close the dialog Box.
My suggestion is to integrate this functionality with the Data Validation button in the ribbon (as explained in the attached Graphic) which will enable the user with a click to either clear Data Validation from a selected range or from the entire worksheet (as in case of Conditional Formatting)
I designed the proposed look of the Data Validation button.

There is No synchronization between the Filter command on the Table Design Tab and the similar command on the Data Tab. So if you apply a Filter from the Data Tab then clear it, the corresponding Filter command on the Table Design is inactive. On the Other hand, if you insert a Slicer from the Table Design Tab ► it inactivates the Filtering commands on the Data Tab. Filter on all tabs should synchronize together as well as with the Slicer.
Looking at the distribution of commands on the Table design Tab, I would prefer removing the Filter command from the Style options group (it has nothing to do with formatting) and rather group it with the Slicer button in the Tools group. to avoid any confusion I would also move the 6 options affecting the styles, to the right side of the Styles gallery. Look at the before and after design.

The new Information Rights Management (IRM) is great to protect workbooks from being opened or edited by non authorized users.
Unfortunately it also deactivates all ad-ins. In principle this makes sense as add-ins can access and modify information within the workbook. However, current restrictions go a bit too far as even as an owner/author of the workbook with FULL CONTROL my add-ins are deactivated. Should I not have full rights to do anything with the workbook? In our company thousands of users across EMEA use a self developed add-in to calculate service costs. Now they cannot use IRM as it would block this add-in.

FEATURE REQUEST:

Under "Additional permissions for users" can you please add any of the following options

"allow all add-ins"
"select a specific add-in to be allowed"
"allow all users with FULL CONTROL to use add-ins"

Thank you!

Using the new lambda function, can we have the ability to put parameter names in square brackets to turn them into optional parameters for the user?
LAMBDA(parameter1, parameter2, [parameter3])
This would be extremely useful for reusable functions. For example, I've created a function that combines arrays, but I don't want to have limit that function to passing only a specific number of arrays or forcing the user to enter commas for the remaining criteria. Similar to index, or sumifs or other function that has optional parameters please!
Also, if you're feeling generous, I'd love the option of hidden parameters too, which the user doesn't enter, but we can use recursively in our function call. For example, I might want to add a counter, that I can pass back using recursion, or the result of a calculation that only gets performed on the first recursion, but passed as a hidden parameter thereafter.
Thanks guys, loving the huge amount of work being done on Excel these days. Very much worth the subscription.

From time to time, users need to remove multiple characters from a string. For example, you might want to remove all punctuation, or all accented characters.

Right now, you have to do that with a lengthy nested formula using the SUBSTITUTE function. Such formulas are hard to read and challenging for a novice to debug. Or you could write a VBA user-defined function that performs each of the substitutions for you.

The better approach would be a SUBSTITUTES function that works like SUBSTITUTE but accepts an array (or range of cells) for the Find parameter, and possibly also for the Replace parameter.
=SUBSTITUTES(text, OldTextArray, NewTextArray, optional InstanceNum)

If NewTextArray is a single value, then each of the values in OldTextArray would be replaced with that single value.

If NewTextArray matches OldTextArray in dimensions, then an element of OldTextArray is replaced with the corresponding element of NewTextArray.

If InstanceNum is omitted, then all matches are replaced. If InstanceNum is a positive integer, then just that instance is replaced. If InstanceNum is a negative integer, then just that instance (counting from the end of the string) is replaced. If the absolute value of InstanceNum exceeds the number of matches, then all matches are replaced.

To remove punctuation from the text, you might use:
=TRIM(SUBSTITUTES(A2, {",",".","?","!",";",":","_","-"}," "))

To replace the last comma with an ampersand, you might use:
=SUBSTITUTES(A2, ", ", " & ",-1)
This formula would turn "dog, horse, mouse" into "dog, horse & mouse"

Spreadsheets needs a radical improvement, no spreadsheets at the moment allows subcolumns creating subcells. This would improve the formatting dramatically. We should not have just letters, A, B, C, D... we should be able to divide these columns (letters) in subcolumns and subcells A, A1, A2... but...
How these spreadsheets would be read? Easy.
As they are right now (classic style).No subcolumn, no subcell, Column A, Row 2: Read: A2
Advanced style (subcolumn and subcells), subcolumn A1 Row 2: Read A1#2
Just columns could be divided with subcolumns, this generates a subcell (comprised with the subcolumn and the row)
Rows cannot be divided with subrows
With this, the resolution of the cells would increase and the formatting would improve dramatically
As far as I know LibreOffice is researching this.
Please, click on the attached picture to see subcells in action
Remember you can drag subcells separators, the same you do with columns separators, so the formatting possibilities are unlimited.

Correção na documentação da função SOMA.

Correção da documentação na função SOMA, como neste exemplo anexo informa que se deve informar de 1 a 255 "números" mas que na verdade são argumentos, podendo dentro delas constar números, célula, intervalo de células, funções ou fórmulas e não somente números, para um usuário que está começando e lê isto pode, e já
foi presenciado, inserir de forma manual números nos argumentos por não ter o conhecimento e não estar especificado de forma correta a diversas formas que pode ser aplicada.
Como sugestão alterar o "núm1;núm2"... para arg1;arg2... e de 1 a 255 "números"para de 1 a 255 argumentos que podem ser números, célula, intervalo de células, funções ou fórmulas.

Corrigir descrição da opção "Remover Duplicatas" no Microsoft Excel

No caminho Dados>Ferramentas de Dados temos a opção "Remover Duplicatas".

"Duplicatas" no Comércio significa: "título de crédito nominativo pelo qual o comprador fica obrigado a pagar, em determinada data, a quantia correspondente à fatura de mercadoria vendida a prazo."

Ao deixarmos o mouse na opção já aparece "Duplicatas" que está errado por fazer confusão ao comercio, e no texto em seu "balão" aparece como "Duplicadas", onde o seu único significado é "que ou o que se duplicou; que foi copiado por uso de artefato próprio ou manuscrito (diz-se de documento ou escrito).

O mesmo erro ocorre ao selecionarmos a opção na janela de opção de colunas à remover onde na mesma linha consta inicialmente como "Duplicadas" (correto) e no final como "Duplicatas" (errado)

Segue anexos para melhor entendimento.

Currently, in cells formatted as time ([$-x-systime]h:mm:ss AM/PM), if I sum 16:00 and 12:00, I get 04:00. I would like to have the possibility of getting 28:00.

Maybe this could be achieved through a new TimeSpan cell format that would show the absolute number of years, months, days, hours, minutes, seconds, etc. without a calendar, according to the selected format.

So, 28:00 could, also, be shown as "1 day and 4 hours", or "1d4h", depending on the format selected by the user.

Those TimeSpan cells would operate with other cell formats nicely. It would be possible to add a time interval to another or to a DateTime.

Thank you for your attention!