Excel Product Team FY20 Goals

Mike Glenn - yes, you can expect to see data types continue to evolve pretty significantly over the coming years. This year there are a few big additions, one of those being Wolfram Alpha backed data types (which is what you saw in that M365 briefing). That functionality will be rolling out to Insiders in the next month or so. 

ExcelPBI - With import data (power query), our main investments right now are on getting cross platform support, as well as some alignment with a couple other native parts of Excel which we'll talk about in more detail later this year. You may have seen that we started adding PQ refresh support to Mac earlier this year. We'll continue investing there. 
We are not investing in custom visuals right now. The main investments we're making in the charting space are in the web, as we had a lot of feedback from folks who wanted to see more functionality similar to what they get in Windows & Mac. It's been a huge push, but a lot of the core infrastructure work we needed is now out, and folks will see pretty rapid improvements there through the year. I'll spend more time on the overall web backlog and the progress to date in future posts. 

Konrad Schaefers - it is definitely interesting 🙂 We're improving the type of solutions you can build and problems you can solve with Excel. Hopefully you've seen the modern arrays and array formula work already, where you can run calc against an collection of values (rather than a single value), and the result of a formula can also be an array. Some of the other formula improvements like LET are also a piece of this. And data types give you more complex structures in a cell, as opposed to just text/numbers.