The use helper columns in tables now often is unnecessary if using the the new dynamic arrays. But if I want to use the output of one of the new functions as the source for a data validation list, I need to put the function in a cell and reference to that cell as the source for the data validation list. I would like to be able to put the dynamic array function directly into the source field of the data validation dialog.
Example: I have a table with a column of countries. I want to add a cell with a dropdown to chose one of those countries. I have to create a list of country names on the sheet using UNIQUE and SORT and then reference to the cell with this formula as the source for my data validation dropdown. I would prefer inputting the formula directly into the data validation without the helper list on the sheet.
(A similar suggestion has been posted for Excel on Mac, this adds and elaborates the suggestion for Excel for Windows.)

A Table has a lot more functionality than a List. Although there are 6 different ways of converting a List into a Table, Excel users find it easy to do that with a shortcut. Surprisingly there are 2 shortcuts performing the same exact task:
CTRL + T (T stands for Table) or CTRL + L (L stands for List)
Why should we reserve 2 shortcuts for the same action? let's keep only the relatively new one CTRL + T (users are familiar with this one)
While Assign the older shortcut CTRL + L to copying to the left (L stands for Left) maintaining the same logical association:
CTRL + D >> To copy Down (D stands for Down)
CTRL + R >> Copy To The Right (R stands for Right)
CTRL + L >> To copy to the Left (L stands for Left)

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!

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.

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"

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.