![]() ![]() New Charts: Microsoft has moved a number of add-in charts to the standard build, including TreeMap, Sunburst, Waterfall, Histogram, and Pareto.One-Click Forecasting: Excel automatically scans your worksheets, searching for data trends, and extrapolating into charts and tables. ![]() Automating data grouping will provide a deeper analysis experience, along with updates for PivotTable and PivotChart. Power Pivot: Essential data analysis tool Power Pivot has received a power boost and is now able to calculate and analyze millions upon millions of rows of data.Power Query used a built-in JSON parser, which has also made its way into Excel to help build visualizations. Power Query, an Office 2013 add-in, has made it into Office 2016 as standard. Inbuilt Business Intelligence: Microsoft hasn't quite brought it all under one roof, but there are more export options to PowerBI.But Microsoft has somehow boosted Excel even further into the data analytics stratosphere with a raft of new features: Excel is still, well, Excel, excelling at what it does best: numbers, data, analytics, and more. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |