Tables, Power Query, Power Pivot and Pivot Tables are amazing tools that will transform the way people build their reports, but only once they know about them!

Let's SHOUT about how good these things are and how well they work together by putting them onto a single new Ribbon called "Reporting" - something like the attached image.

You should be able to pick dates when selecting stock info.

E.g set the date as 06/11/2019 to get XNAS:MSFT open price on that day.

Ao copiar dados de uma coluna com vários dados repetidos.
Como temos a opção com o botão direito do mouse de Colar Especial > Valores, poderia ter uma opção de Colar Especial > Valores Únicos.

If you input =A1 in Cell B1 excel returns the data only.

Id like to have the option to link the formatting too. Cell Colour, text colour, borders, comments...... chose one, some or all formats

Want to be able to activate the office license to guest user. Like Azure AD member.

Every time I open excel the default fill color is set to yellow. We should have the option to change the default fill color to another color.

Like copy down (control+d) to copy cell immediately above, I would like to see a copy up (control+u) to copy cell immediately below

This is a great idea. But I am in UK and entering my shares does not work.
(XLON:RDSB) produces a field error.
(XLON:AV.) produces a US$ price which is about 10 times the actual £ price.
The template is just what I need; but as with many others I have looked at it is not easily adapted for UK use. This severely limits the value of their subscription for UK users of Office 365.

Can UK versions be supplied, please?

I want to sync settings that is ribbon customize in my O365 account.
Now I need export ribbon and import.

I use all ways to move thru my spreadsheets, but for accuracy I like the bar and using my curser up and down to the cell I need. STEPPING UP ON MY SOAPBOX NOW: I really tired of MS is trying to be Apple. You are MS and your programs created accuracy and easy for customer. Cool are for non-working people who have the time to hope it will work.....

I've always wanted the option to copy multiple selections to the clipboard. When you paste, you'd be presented with the option of everything on your clipboard, to be able to pick which selection(s) you want to paste.

How about a searchable dropdown list on data validation?

To Convert EDB to PST I would like to suggest a perfect solution that can easily Export Exchange EDB Files to Outlook PST, If you use this Regain EDB to PST Converter Software then you can Export Exchange EDB Files to Outlook PST in just few clicks. this Software Convert Exchange Public and Private folders to Office 365 or PST format. If you want to use this Software free demo version before buy this Software then you can also try this Software free demo version.

Download this Software free demo version from here: http://www.edbtopstconverter.emltopstutility.com/

Please add double strikethrough to Excel. I've often wished that it was available in Excel as it is in Word. It seems if it's available in Word, it'd be easy enough to add it to Excel.

Please consider this addition.

Thanks!!!

In Excel, the only way to make your worksheets/reports that you build in Excel a dark theme, is to add a background image.
On the PowerPivot/Sharepoint server, background images are not supported.

It would be nice if you could save an Excel sheet with dark background color as a configurable default, so that you don't have to change cell backgrounds (which go away with PowerPivot refresh), and don't have to do a background image (which is incompatible with server refresh/presentation).

Even outside of server refresh, we find issues on file exchange too.

blad verwijderen kan niet als je een laptop hebt met een touchpad

Team, I have some of the cool ideas to make excel intelligent. Implementing machine learning / Deep Learing algorithms as functions in excel would really enable small business entities take wise decisions. Here is a presentation I have shared in Open Data Science Conference. Would love to take excel to next level as OLD IS ALWAYS GOLD.

https://www.youtube.com/watch?v=4pXQRmliTcM&feature=youtu.be