Version 1609 (Build 16.0.7369.2024)
Released to Current Channel on October 4, 2016
Get & Transform improvements
Several improvements to Get & Transform are included in this version:
- Parameters can now be added to queries, allowing a query to obtain parameters from another query or a list of values instead of only fixed values.
- New queries can now be created that are based on existing Merge or Append operations.
- Web pages can now be previewed when importing data from the web using Get & Transform.
Macro recording for new chart types
Excel's macro recorder now supports the new Treemap, Histogram, Pareto, Waterfall, and Box & Whisker chart types.
New Tell Me help options
Tell Me help now has the ability to understand color changes. For example, entering Make my font red into Tell Me help will present the option to instantly set the font color to red. This new feature allows you to set font, highlight, shading, page, shape border and shape fill colors.