Excel 2016: PivotTable and Power Pivot changes

Share this content

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.

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

About Simon Hurst

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.



Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.