This post is brought to you by Allie Rutherford, a Program Manager on the Analytics and Presentation team. Excel will try to read your mind and tell you what PivotTable you’re looking for (more or less). Create PivotTables with nearly no effort and virtually no expertise, we’ll recommend some to you!
In the new Excel, we published a feature that allows Excel to continue its emergence as your go-to BI tool, whether it’s for analytics or for exploration. That feature is called “Quick Explore,” and with it you can drill up, drill down, and drill across your PivotTables and PivotCharts in ways never before possible in either Excel desktop or Excel in the browser.
Excel for the browser has adopted a number of features that, previous to the 2013 release, only existed in the client application. In this blog I want to introduce you to one of those features: the field list and field well. This is one of the features that allows you to use the Excel web app as a first class analytic tool.