This is the sixth and final part of Simon Hurst’s series looking at the changes and new features in Excel 2016.
In the first part we looked at an overview of the changes and covered those that related to the Office interface. Then in Part 2 we used the tools in the new Get & Transform group of the Data ribbon to construct a list, based on merging two other lists, that would automatically reflect changes when refreshed. Part 3 looked at the Forecast Sheet feature and Part 4 covered the first three (and easiest) of the new chart types: Treemap, Sunburst and the long-awaited Waterfall chart with Part 5 covering the remaining new chart types including the new funnel chart available to Office 365 subscribers as part of the January 2016 update.
We'll complete the series by looking at the changes to PivotTables and Power Pivot.
PivotTable Fields Search
The inclusion of a search box in the PivotTable Fields pane is a small but useful improvement. Where a PivotTable is based on a table, or series of tables, containing a large number of individual fields, it can be time-consuming scrolling through the list to find the field you want to add to the PivotTable. The new search box allows you to enter any part of the name of the field that you want to find and the list of fields will be filtered accordingly:
...To read the full article, register on AccountingWEB for free.
About Simon Hurst
Simon Hurst is the founder of technology training consultancy The Knowledge Base and is a past chairman of the ICAEW's IT Faculty.