3 ms·
biased opinion here, i helped build Excel 2013. We did a lot of investments in making it easier to work with your data. Off the top of my head here are some of
by doppenhe 14y ago
biased opinion here, i helped build Excel 2013.
We did a lot of investments in making it easier to work with your data. Off the top of my head here are some of the top things we did:
Flash fill : Automatically detects what you are trying to fill/parse and does it for you.
Suggest Pivottables: Select a range and ask excel to aqutomatically create a Pivot for you.
-Suggest charts: Excel suggest what type of charts work best with selected data.
Data model - Although you need Pro Plus to use powerpivot and powerview, basic functionality that "converts excel into a database" is built in. You can combine data from multiple sources and create relationships between data.
Apps for Office : A new way of programming against the productivity suite in javascript and html5
Chart enhancements: creating beautiful charts is easier and the options are more accesible.
A lot of this information is on our blog: http://blogs.office.com/b/microsoft-excel/ http://blogs.office.com/b/microsoft-excel/
Twitter account: @MSEXCEL
and if your particularly inclined to data analysis and business intelligence I blast cool features and how tos on my personal account: @doppenhe