This is a series of posts I’ve wanted to write for a long time. The more I use PowerPivot, the more I realise how many more cool things you can do when building your Excel reports if you know a bit of ...
The combination of the filtering functionality built into PivotTables, and the ability to delete and reorder tuples in a set without needing to edit the set expression itself that the Excel named set ...
This blog post was brought to you by Diego Oppenheimer a Program Manager on the Excel team. Some weeks ago I introduced an important, new part of the Excel 2013 Data Model and how you could create ...